export file

[jinggang]

anyone can tell me how to built a export file in mysql.
hint:
export file is the file that include everything in the database. and the the file should with extension .sql

thanks!

 

[Sina]

you can do a mysql dump check the man pages at

http://www.mysql.com.

I have downloaded a SQLPorter,Migration tool from RealSoftstudio, which allows me to export or migrate database schemas and data from Microsoft Sql server to any MySQL database on windows or Linux, Locally or over the internet. I'm using it daily to update our MySQL database over the net and it works like a charm.

You can check it out at

http://www.realsoftstudio.com