MySQL DATA export and mysql Database Export

MySQL DATA export and mysql Database Export

1. Open the command line window "run" --> Enter CMD

2. Go to the bin directory of your MySQL Server Installation Directory (my installation directory is as follows)

Cd C: \ Program Files \ MySQL Server 5.6 \ bin

3. Run the "mysqldump-u username-p Database Name>" zentaodbbak. SQL "command to export data. Click" enter ", enter the database password, and start exporting the file.

Note: there is a space between u and the user name. My command is as follows,

C: \ Program Files \ MySQL Server 5.6 \ bin> mysqldump-u root-p zentaoold> zentaodbbak. SQL

Enter password :******

C: \ Program Files \ MySQL Server 5.6 \ bin>

4. The file export location is in the bin directory of your MySQL Server Installation Directory (my installation directory is as follows)

C: \ Program Files \ MySQL Server 5.6 \ bin