Wednesday, April 01, 2009

export data or backup mysql

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: