MySQL Import export SQL file

Under Window

1. Export the entire database
Mysqldump-u user name-p database name > exported file name
Mysqldump-u dbuser-p dbname > Dbname.sql

2. Export a table
Mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u dbuser-p dbname users> dbname_users.sql

3. Export a database structure
Mysqldump-u Dbuser-p-D--add-drop-table dbname>d:/dbname_db.sql
-D No data--add-drop-table add a drop table before each CREATE statement

4. Import the database
Common source Commands
Enter the MySQL database console, as
Mysql-u root-p
Mysql>use Database
Then use the source command, followed by the script file (for example, the. SQL used here)
Mysql>source D:/dbname.sql

1. Import data to a database

mysql-uroot-d database name

1. Import data to a table in a database

MYSQL-UROOT-D Database Name Table name

D:\apmserv5.2.6\mysql5.1\bin>mysqldump-u root-p ERP lightinthebox_tags > Ligh
Tinthebox.sql

MySQL Import export SQL file