Friday, February 27, 2009

MYSQL- import/export data .dmp file

//import
mysql --host=... --user=... --password=... -vvf MySQL_database_name < dump_file_name

eg: in cmd
c:\documents and settings mysql -uroot -ppassword -vvf DB01<db01.dmp

//export


mysqldump --host=... --user=... --password=... -vvf MySQL_database_name > dump_file_name
eg: in cmd c:\documents and settings mysqldump -uroot -ppassword -vvf DB01>db01.dmp

No comments: