Hi:

I want to export all table data from one Mysql database to another on different PC. What is the short method to do either data or both data and table structure. Also same from Mysql to Oracle database.

Thanks

Hi pb,

You can use mysqldump to create a file of sql statements, there are various flags that allow you to select which databases / tables / data to dump.

http://dev.mysql.com/doc/mysql/en/mysqldump.html

HTH,

Chris