How to backup data in mysqldump
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
< backup-file.sql -u root -p 有一种用mysql db_name < backup-file.sql -u root -p ………………………………………………………… 添加mysql用户mysqlname 密码为password ，赋予dbname数据库所有权限 mysql>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.
