| 26. 4. 1. mysqldump |
|
|
mysqldump outputs the table structure and data in series of SQL commands stored in a text file. |
The simplified syntax is |
|
c:\mysql\bin\mysqldump -u <username> -p <database> [<table>] > file.sql
|
|
To back up a 'myDatabase' database: |
|
c:\mysql\bin\mysqldump -u root -p myDatabase > myDatabase.sql
|
|
We could also have chosen to output just one table from the database, for example the employee table: |
|
c:\mysql\bin\mysqldump -u root -p myDatabase employee > employee.sql
|
|
We could even dump all the databases out (providing we have the permissions). |
|
c:\mysql\bin\mysqldump -u root -p --all-databases > alldb.sql
|
|