SQL Server: How to import and export data in MySQL

Importing and Exporting

The System Management Databases such as MySQL can handle easily and with great flexibility a very large volume of data. However, MySQL is also robust, it may be interesting to recover all the data contained in our database data to a backup (backup) or simply to switch to another database. Called "export" is to format a file (called dump) all information necessary to create a database identical.

Conversely, the import is called to create a DBMS in a new database from an export file (dump).

MySQL offers a number of tools to export its database to other DBMS or to import them.

Export MySQL database

MySQL provides several ways to export data. The key is the command line mysql to achieve almost any action on the databases it contains from a single command line:
mysql-h host-u user-ppass dbname> fichier_dump
The following notation is also possible:
mysql - host host - user user - passwordpass dbname> fichier_dump

represents the host name or IP address of the machine where the database you want to export is installed. By default it is localhost, that is to say the machine from which the command mysql is launched

user represents the user with whom you want to connect. By default it is the user root

password is the password of the user that you want to connect. If you do not specify a password, one will be asked interactively. There must be no space between-p and the password provided, unlike other fields

dbname is the name of the database to export.

fichier_dump is the name of the file where the database will be exported. If absolute path is not specified, the file is stored in the same directory that the command mysql. Be careful not to assign a name to an existing file in this directory!

Export a MySQL database with mysqldump

The command mysql to export an entire database hosted by MySQL efficiently but does not provide the flexibility necessary for exporting multiple databases or otherwise part of the basis of data (table or part of a table). The command mysqldump meets this need by providing the ability to specify more precisely the data to export. The syntax for this command:
mysqldump [options] dbname [tables]
Here are the options generally used:
mysqldump-h host-u user-ppass-RFILE dbname [tables]

host represents the name or IP address of the machine where the database you want to export is installed. By default it islocalhost, that is to say the machine from which the command mysql is launched

user is the user that you want to connect. By default it is the user root

password is the password of the user that you want to connect. If you do not specify a password, one will be asked interactively. It should not be any space between-p and the password provided

dbname is the name of the database to export.

file is the file name where the database will be exported. If absolute path is not specified, the file will be stored in the same directory as the mysql command.

Import a database in MySQL

The command-line mysql can also import data. Simply use the redirect " and indicate the dump file containing SQL statements to import:
mysql-u user-h host-ppass dbname <fichier_dump
The following notation is, once again, also possible:
mysql - host host - use user-passwordpass dbname <fichier_dump

Import a database with phpMyAdmin

To import a database using phpMyAdmin, simply copy-paste the "dump" of MySQL in the field provided to enter the query or click on the button "browse"to get the file containing the copy of base.

How to import and export data in MySQL

Importing and Exporting

Export MySQL database

Export a MySQL database with mysqldump

Import a database in MySQL

Import a database with phpMyAdmin

Post Comment: