How to guide database in mysql

This article introduces how to guide the database in mysql, the content is very detailed, interested friends can use for reference, I hope it can be helpful to you.

1. Import to database

After creating an empty database

Go to the mysql installation directory bin

(1) Import command mysql-u root-p password database name Source d:\ ajswlw.sql

two。 Database export data file

(1) Export mysql database ajswlw

Enter the mysql installation directory C:\ Program

Files\ MySQL\ MySQL Server 5.5\ bin >

Mysqldump-h localhost-u root-p ajswlw > d:\ ajwlw.sql

(2) Export the tb_user table and data of mysql database ajswlw

Enter the 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) the structure of exporting mysql database ajswlw is not implemented.

Enter the 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

Basic operation of 3.mysql

Create database ajswlw

Create table tb_user

Show tables

Desc tb_user

4.mysql has a limit on the size of the imported file, up to 2m, and the configuration can be modified.

Modify the parameter 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

On how to guide the database in mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.