MYSQL Database Import and Export command, mysql Import and Export
MySQL command line Export Database
1. Go to the bin folder under the MySQL Directory: directory from cd MySQL to the bin folder
For example, if the command line I entered is cd C: \
Mysqldump is a client program that MySQL uses to store databases. It mainly produces a series of SQL statements that can be encapsulated into a file that contains all the SQL commands needed to rebuild your database, such as CREATE database,create
Mysql import and export Database> mysqldump-u root stg> H:/stg. SQL
> Mysqladmin-u create stg
> Mysqldump-u root stg
-------------------------------------------------------Mysql common data export commands:
1. mysql exports the entire
MySQLGUIToolsv5.0 must be installed to use a graphical auxiliary tool. It is a visual MySQL database management console and provides four very useful images.
To use a graphical auxiliary tool, you first need to install MySQL GUI Tools v5.0, which is
Transfer from: http://www.cnblogs.com/chenmh/p/5300370.html introductionIn daily maintenance work often need to export the data, and mysqldump is to export the data process is a very frequent use of a tool, it comes with a lot of function parameters,
Export:Through the command line in the directory of the bin folder in MySQLInput: D:\phpstudy\mysql\bin>mysqldump-uroot-p database name > exported file nameImport:Need to enter mysql> firstInput: Mysql>use database nameMysql>source the file name of
http://www.cnblogs.com/chenmh/p/5300370.html IntroductionIn daily maintenance work often need to export the data, and mysqldump is to export the data process is a very frequent use of a tool, it comes with a lot of function parameters, the article
MySQL command line export database1. Go to the Bin folder in the MySQL directory: cd MySQL to the Bin folder directoryAs I entered the command line: CD C:\Program files\mysql\mysql Server 4.1\bin(or add the directory to the Windows environment
In the construction of PHP website, the maintenance of MySQL database is the daily work, MySQL database import and export to achieve backup function is one of them, in the previous PHP tutorial I introduced a number of MySQL command to maintain the
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.