Sunday, April 26, 2009

How to dump sql data base into a file

Here are the steps to dump sql data base into a .sql file
1. Go to the bin folder of the mysql, which might be (C:/xampp/mysql/bin if you are using xampp)
2. Type the following command mysqldump -u root -p --database name of the database > file to ouput.sql

No comments: