Shulou(Shulou.com)06/01 Report--

Editor to share with you mysql how to export the database, I hope you will learn a lot after reading this article, let's discuss it together!

How does mysql export the database?

1. From the win+r shortcut, type cmd to open the command window.

two。 Enter mysql-u root-p "and press enter.

3. Enter the correct password and log in to the database.

4. Then switch to the specified database and use the "show tables;" command to display all the tables.

5. Exit mysql, use "exit", then go back to the command line and enter the command "mysqldump-uroot-proot-P3306-- default-character-set utf8 test > the path you want to store". This command means to package mysql's test database to the path you specified, in utf8 format.

6. Go to the path we specified to find the exported SQL file. As shown in the figure, test.sql is the exported file.

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software.

After reading this article, I believe you have a certain understanding of how to export the database of mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.