Mysql Database Import and Export, mysql Import and Export

Mysql Database Import and Export, mysql Import and Export

Mysql Command
Export Select * from table name into outfile "Address ";
Import Source D:/mydb. SQL/* import External SQL files to the database */

Dos command
Mysqldump-uroot-p123456 test> c:/a. SQL in the dos window, enter this command. test is the name of the database to be exported.
Mysqldump-uroot-p123456 test t1> c:/a. SQL in the dos window, enter this command to export table t1 in the test database.

By default, mysql imposes a limit on the size of the imported file. The maximum size is 2 MB. Therefore, when the file is large, it cannot be imported directly.
Solution: 1. Modify related parameters in php. ini: There are three parameters that affect the size of the mysql import file:
Memory_limit = 128 M, upload_max_filesize = 2 M, post_max_size = 8 M modify upload_max_filesize = 200 M? Modify the size that meets your needs. Can you modify the other two memory_limit = 250 M at the same time? Post_max_size = 200M so that the. SQL file below MB can be imported.