chriss Posted October 3, 2003 Share Posted October 3, 2003 How to copy all tables (with all data) from one db to another db. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.