hi,
Im using mysql 5.0.13 and table type is Innodb. Our company has 2 branches . I want to transfer that specifec table from branch A to branch B through email. But i dont knew what file in mysql subdirectory to make as my attachement. Anybody can help me.

thanks,

Popskie

Export the table and data to a .sql file. Email the file and then have them import it.

Ok, Im using Dbtools manager professional. I can export to .dbf, .mdb, .txt but there is no .sql here. if it is ok for u can i ask what tools you are using and its free? heheheh.

thanks for the big help.

Popskie

From the shell:
http://www.dbforums.com/mysql/1199569-copying-database.html#post4479795
I'm pretty sure you'll just have to specify the table name after the database name.

As far as good tools, I use phpMyAdmin. But you need php installed on your machine. If that's not an option, I'd try downloading one of the apps from the mysql site.

thanks for the reply. I hope dis solution is good.

Another way would be to use mysqldump. You can export your entire database into a single sql file, zip it up (if it's large) and copy it to the other server, unzip it and run it.

Not sure if DBTools has the capability, but if you can establish connections to both servers with it, it may let you duplicate databases/tables from one server to the other.

This whole post was about mysqldump .

ok thanks guys sqldump is good.

Hi,

Other option different to table dump is a database transfer or object tranfer, this option are available in many GUI's like MySQL Turbo Manager or MySQL Manager, this option is a lot easy that dump.


Regards,

If it was, I wouldn't have mentioned it.