chriss Posted October 3, 2003 Share Posted October 3, 2003 How to copy all tables (with all data) from one db to another db. Link to comment https://forums.phpfreaks.com/topic/1109-copy-tables-to-another-db/ Share on other sites More sharing options...
Kriek Posted October 4, 2003 Share Posted October 4, 2003 phpMyAdmin -> Database -> Export -> Hold control and select all tables. -> Check SQL, Structure, and Data. Link to comment https://forums.phpfreaks.com/topic/1109-copy-tables-to-another-db/#findComment-3780 Share on other sites More sharing options...
chriss Posted October 5, 2003 Author Share Posted October 5, 2003 I can\'t use admin mode. I\'m on SunOS, not Win. I just want to know how to do that in mysql console. Link to comment https://forums.phpfreaks.com/topic/1109-copy-tables-to-another-db/#findComment-3785 Share on other sites More sharing options...
shivabharat Posted October 5, 2003 Share Posted October 5, 2003 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 Link to comment https://forums.phpfreaks.com/topic/1109-copy-tables-to-another-db/#findComment-3789 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.