Mysql command line export SQL

Mysql command line export SQL

MySQL command line to export the database:

1. Go to the bin folder under the MySQL Directory: directory from cd MySQL to the bin folder

For example, if the command line I entered is cd C: \ Program Files \ MySQL Server 4.1 \ bin

(Or directly add the directory to the path of the windows environment variable)

2. Export Database: mysqldump-u username-p Database Name> exported file name

For example, the command line I entered is mysqldump-u root-p news> news. SQL (after entering the command, you will be asked to enter the MySQL password)

(If you export a single table, enter the table name after the database name)

3. The file news. SQL is automatically generated under the binfile.