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

In this issue, Xiaobian will bring you about how to backup data in mysqldump. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

Use mysqldump

Export a library to a SQL file

mysqldump db_name > /path/name.sql -uroot -p

If database is too large, compress export

mysqldump db_name | gzip > /path/name.sql -u root -p[@more@]

Backup all libraries

mysqldump --all-databases > /path/name.sql -u root -p

mysqldump --all-databases | gzip > /path/name.gz -uroot -p

Backup a single table or several tables

mysqldump db_name tab_name > /path/sqlname.sql -u root -p

Recover Data Import Data

mysql db_name

grant all on dbname.* to mysqlname@localhost identified by 'password';

mysql > grant select,insert,update,delete,create,drop on database name.* to user (new)@localhost identified by 'password';

Or modify the mysql table directly

mysql > insert into user(host,user,password) values('%','user_name',password("you password"));

mysql > set password for user_name=password("you_password")

The above two must be overloaded authorization table (./ scripts/mysql_install_db)

Or in a shell environment.

mysqladmin -u root password "you password"

Export a database structure

mysqldump -u wcnc -p -d --add-drop-table smgp_apps_wcnc >d:wcnc_db.sql

-d No data--add-drop-table Add a drop table before each create statement

import database

Common source command

Go to mysql database console and

as

mysql -u root -p

mysql>use database

Then use the source command, followed by a script file (such as the.sql used here)

mysql>source d:wcnc_db.sql..

The above is how to backup data in mysqldump shared by Xiaobian. If there is a similar doubt, please refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

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.