Exporting tables

[chinni_77]

Can I tranfer all my tables from one db to another db in mysql??

How can i do that if its possible.

thanks in advance

[chinni_77]

I fixed it:-)

[Norman_Graham]

How did you fix it? It might be interesting. I recently got a new computer and was amazed to discover that I could transfer all my databases and tables to a new version of MySQL simply by copying the folders and files in the data folder over to the new data folder. Unbelievably simple.

I have MySQL/PHP and Apache on Win98

Norman

[chinni_77]

Guten tag Norman,

well, if you have phpadmin, theres an option dump.here you can dump all the data as well as the structure.save this file and copy this file into the db which you want it to.

HTH

[riffy]

the code for that dump could be something like this:

DUMP
mysqldump -uroot -d db_to_dump > whatever.dump
(-d only dumps table structures)

IMPORT DUMP
mysql -uroot db_to_import < whatever.dump

-uroot just gives root access to mysql...whatever.dump can be named to whatever you want

when u import back to wherever u want to transfer that database, make sure that in the new place, the database already exists w/o any tables or data in it...the import will then just transfer everything...
if you want to include data, then take out -d in the mysqldump function

arif