mobile database

[weazy]

i have a mature database on a server that I would like to migrate to another machine that already has a database set up.

How do I move the tables that is in the mature database into the database on the new server?

thanks for your help.

=weazy=

[cgraz]

use phpmyadmin to dump the structure and data to a textfile, then import that textfile to your new database using phpmyadmin.

Cgraz

[weazy]

i dont see an import feature in phpmyadmin -- i see an export feature but .....

[cgraz]

Select your database. At the bottom, you'll see

view dump (schema) of database

() Structure only
() structure and data
() data only
[] Add 'drop table'
etc etc

Select structure and data

click go. copy and paste the results to a textfile

--

go to your other database's phpmyadmin.

Go to the same page. Right above those radio and checkboxes, you'll see a textarea where you can run SQL queries, then below that it says OR Location of the textfile. Browse for th textfile and click go.

Cgraz

[weazy]

yup yup
couldnt be easier

but what about the situation where i need a table or two out of a database?

the old database has about 1000 users i want the new database to have all those users but not necessarily all the rest of the tables.

also, i have two databases with similar tables that i would like to merge ... can phpmyadmin do all those things too?