Use the exec function to import and export the database in php.

: This article describes how to use the exec function to import and export a database in php. if you are interested in the PHP Tutorial, refer to it. Export database code:

Exec ("mysqldump-h localhost-uroot-ppassword -- default-character-set = utf8 dbname> d:/aaa. SQL 2> & 1 ", $ output, $ return_val); exit;

Note: 1) there must be spaces between-h and localhost (otherwise, the output will report incorrect passwords)

2)-u and root,-p and password cannot have spaces in the middle (if there are spaces in the middle, the output result is blank)

3) -- default-character-set = utf8 (used to set the font format of the exported document)

4) 2> & 1 if the command in exec is incorrectly added; 2> & 1 is printed in the document.

Import database code:

Exec ("mysql-h localhost-uroot-ppassword dbname <d:/ccc. SQL"); exit;

The above describes how to use the exec function to import and export a database in php, including some content. I hope to help anyone who is interested in the PHP Tutorial.