How to export mysql Data

Let's take a look at the data export method and use the command line provided by mysql to import and export data, as shown below. Another way is to use php to import a. SQL file.

Assume that the mysql user name and password are root xxx and the database is test.

Import SQL

The Code is as follows:	Copy code
Mysql-hlocalhost-uroot-pxxx test <xxx. SQL

Export SQL

The Code is as follows:	Copy code
Mysqldump-hlocalhost-uroot-pxxx database> xxx. SQL

Import. SQL to the mysql database using php

The Code is as follows:

Copy code

<? Php $ Conn = mysql_connect ("localhost", "root", "password"); // specify the database connection Parameters Function mysql_import ($ file, $ database) // The imported function. The parameter is the SQL file path and the imported database name. { Mysql_select_db ($ database ); Mysql_query ("source". $ file ."';"); Echo "import". $ file. "file to". $ database. "database complete "; } Mysql_close ($ conn ); ?>