|
Tuesday, 22 December 2009 09:10 |
|
This how to shows how to enable root log in on fedora GUI Desktop.
- Open Terminal from Applications -> System Tools
- Type
su - and then insert root pasword
|
|
|
Thursday, 03 December 2009 13:03 |
|
To export a MySQL database into a dump file, simply type the following command syntax in the shell.
mysqldump -u username –ppassword database_name > dump.sql
Replace username, password, database_name and dump.sql as your needs. All data, tables, structures and database of database_name will be backed up into a mentioned file dump.sql.
IMPORTANT: Don't put space after -p and the password
|
|
Thursday, 03 December 2009 13:02 |
|
If You need to export only the MySQL database's tables’ structures use –no-data switch.
mysqldump -u username -ppassword –no-data database_name > dump.sql
|
|
Thursday, 03 December 2009 13:00 |
|
For exporting MySQL database's only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing.
mysqldump -u username -ppassword –no-create-info database_name > dump.sql
IMPORTANT: Use this only if you sure that you have a duplicate databases with same structure.
|
|
Thursday, 03 December 2009 12:59 |
If You need to export only the MySQL database's tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql
|
|
|
|
|
<< Start < Prev 1 2 3 4 5 Next > End >>
|
|
Page 1 of 5 |
How To
