How to use the mysql dump file.

This article is just for recording the way how to use rgw mysql dump file.

Export (dump)

First of all, You have to move the directory to the root of mysql. and then You can see the mysqldump.exe file. at there, Let’s start to type the below command. then your file will save with the below file name.

mysqldump -u [user id] -p [database name] > [.sql file]

Import

It has to go the root directory either. and then follow the below.

mysql -u [user id] -p database name < [.sql file]