PHP uses the EXEC function to import and export databases

To export the database code:

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

Note: 1) between-H and localhost to have a space (otherwise the output will be reported incorrect password)

2)-U and root,-p and password cannot have spaces between them (if there is a space in the middle of the output is empty)

3)--default-character-set=utf8 (used to set the font format for exported documents)

4) 2>&1 if the command in exec is incorrect, it will be printed in the document after adding 2>&1.

Import Database code:

EXEC ("Mysql-h localhost-uroot-ppassword dbname< d:/ccc.sql"); exit;

The above introduces PHP using the EXEC function import and export database, including the content, I hope the PHP tutorial interested in a friend helpful.

