Import/export data in Mysql

Import the backup database file to Mysql,use below command.

1.use cmd command to locate the mysql bin directory:

e.g., C:\Program Files\MySQL\bin

2. use the command to import data to database: 

mysql -uroot -p123 sfproject<d:\php\maxtor_bak1

Note: sfproject is the database name. and d:\php\maxtor_bak1 is the backup file.

 

 

C:\Program Files\MySQL\bin>mysql -uroot -p123 sfproject<d:\php\maxtor_bak1

backup db

mysqldump -uroot -p123 Maxtor>D:\php\maxtor_bk