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

This article will explain in detail how to import and export the mysql database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. Import the database into mysql-uroot-p123456-default-character-set=utf8 test1232. Database export export entire database mysqldump-uroot-p123456 test123 > test123.sql export database single table mysqldump-uroot-p123456 test123log > test123_log.sql export database table structure mysqldump-uroot-p123456-d-- add-drop-table test123 > test123.sql

-d export empty table

-- add-drop-table add drop data table statement 3 before each data table is created. Problem record

When mysqldump exports from the command line, if you enter a password, you will be prompted with the following warning message (successfully executed, only a warning message will be prompted)

Warning: Using a password on the command line interface can be insecure.

3.1. Repair method

In the command line export, manually enter the password at the end of the / etc/mysql/my.cnf file to add [mysqldump] user=user_namepassword=password on "how to import and export mysql database" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

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.