Export method of MySQL database: 1. In the command line, first start the mysql service, and then use the "mysqldump dbname > c:mydb.sql -u root -p" command. 2. Enter cmd and directly use the "mysqldump -u username -p database name > exported file name" command.
MySQL is a relational database that can store data files. What should we do when we need to export the database?
There are 3 methods provided here:
Method 1:
cmd Go to the mysql bin directory and use the following command
mysqldump --opt -h192.168.0.156 -uusername -ppassword --skip-lock-tables databasename>database.sql
Just change the ip to localhost
If you install navicate, it will be easier. First connect to the database, select the database and then choose to dump sql
Method 2:
Enter cmd (note that it is in os cmd and not in mysql)
================== =
1. Export database (sql script)
mysqldump -u 用户名 -p 数据库名 > 导出的文件名
mysqldump -u root -p db_name > test_db.sql
2.mysql export a table in the database
mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名
mysqldump -u wcnc -p test_db users> test_users.sql （结尾没有分号）
Method three:
Start the mysql service
/etc/init.d/mysql start
Export the entire database
mysqldump dbname > c:mydb.sql -u root -p
Import the database
source mydb.sql
mysql -u用户名 -p 数据库名 < 数据库名.sq
The above is the detailed content of How does MySQL fully export the database?. For more information, please follow other related articles on the PHP Chinese website!