Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to export MYSQL data". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to export MYSQL data.

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

2. Enter the bin directory of your own MySQL Server installation directory (my installation directory is as follows)

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

3. Export data input command: mysqldump-u user name-p database name > zentaodbbak.sql, click enter, enter the database password, and the file export begins.

Note that there is a space between-u and the user name, and my command is as follows

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

Enter password: *

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

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

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

Thank you for your reading, the above is the content of "how to export MYSQL data", after the study of this article, I believe you have a deeper understanding of how to export MYSQL data, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.