↑ Grab this Headline Animator

Friday, July 11, 2008

How to generate SQL scripts for MY SQL server Database

Open command window
map the path to C:\Program Files\MySQL\MySQL Server 4.1\bin where Mysqldump.exe recides.

Then run the following command in command prompt
mysqldump -d DataBaseName > c:\test.sql -u root -p

After pressing Enter key it will ask for password for connecting to database. Enter the password and press enter.

The scripts file will be generated in the path u mentioned(c:\test.sql).

Submit this story to DotNetKicks

No comments:

Post a Comment

Post your comments/questions/feedback for this Article.


Latest Articles