Mysql backup and database restoration mysqldump instance and parameter description mysqldump
BitsCN.com
We will certainly encounter the situation of backing up the database and restoring the database during the operation of the project. we generally
We will certainly encounter the situation of backing up the database and restoring the database during the operation of the project. We generally use the following two methods to deal with it:
1. Use into outfile and load data infile to import and
Mysqldump backup and restoration of mysql data instance mysqldump
For mysql database backup and restoration, we generally use the following two methods:
1. use into outfile and load data infile to import and export backup data
The exported data
Mysql backup and database restoration mysqldump instance and parameter description mysqldump
We will certainly encounter the situation of backing up the database and restoring the database during the operation of the project. we generally use the
Mysqldump parameter Daquan (parameter from mysql5.5.19 source)ParametersParameter description--all-databases,-AExport all databases.Mysqldump-uroot-p--all-databases--all-tablespaces, YExport all table
Original http://www.cnblogs.com/xuejie/archive/2013/01/11/2856911.html We will certainly encounter the backup database in the course of running the project, restore the database situation, we generally use two ways to deal with: 1. Import and export
This article mainly introduces the mysqldump command for importing and exporting database methods and instance summary. if you need it, refer to the usage of mysqldump command.
1. export all databases
System command
Use of the mysqldump command
1. Export all libraries
System command Line
Mysqldump-uusername-ppassword--all-databases > All.sql
2. Import all libraries
MySQL command line
Mysql>source All.sql;
3. Export some libraries
System command Line
Mysqldump usage database export mysqldump
BitsCN.com
Mysqldump usage database export
The mysqldump client can be used to dump databases or collect databases for backup or transfer data to another SQL Server (not necessarily a MySQL server ). Dump
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.