Jump to content

Archived

This topic is now archived and is closed to further replies.

chriss

Copy tables to another db

Recommended Posts

How to copy all tables (with all data) from one db to another db.

Share this post


Link to post
Share on other sites

phpMyAdmin -> Database -> Export

 

-> Hold control and select all tables.

 

-> Check SQL, Structure, and Data.

Share this post


Link to post
Share on other sites

I can\'t use admin mode. I\'m on SunOS, not Win. I just want to know how to do that in mysql console.

Share this post


Link to post
Share on other sites

Try this

 

mysqldump -u username -p password databasename table name> table.sql 

 

Import data

 

 mysql -uuser -ppass database < table.sql 

 

Check manual for more details

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.