1. Import toDatabase
After you create an empty database
go to MySQL installation directory under bin
(1) Import command mysql-u root–p password database name <d:\bbs.sql
mysql-u root–yb Ajswlw<d:\sql.sql
(2) You can use the source command
mysql> use AJSWLWL;
Mysql>source D:\ajswlw.sql
2. Database Export Data File
(1) Export mySQL databaseAJSWLW
EnterMysqlinstallation directory C:\Program files\mysql\mysql Server 5.5\bin>
mysqldump–h localhost–u root–p ajswlw>d:\ajwlw.sql
(2) export the MySQL database AJSWLW tb_user table and data
go to MySQL installation directory C:\Program files\mysql\mysql Server 5.5\bin>
mysqldump–h localhost–u root–p AJSWLW tb_user>d:\user.sql
(3) export MySQL database AJSWLW structure is not implemented
go to MySQL installation directory C:\Program files\mysql\mysql Server 5.5\bin>
mysqldump–h localhost–u root–p ajswlw-add-drop-table>d:\stru.sql
3.mysql Basic Operation
Create Database AJSWLW
Create table Tb_user;
Show tables;
Desc Tb_user;
4.mysql Limit the size of the import file, 2M maximum, can modify the configuration
modifying parameters in PHP.ini: memory_limit=128m,upload_max_filesize=2m,post_max_size=8m
Modify upload_max_filesize=200m;memory_limit=250m, post_max_size=2000m
MySQL Guide database
