dmccabe Posted June 30, 2008 Share Posted June 30, 2008 What is the simplest method for me to move 2 tables and all the info contained in them to another db? This isnt a script or anything I need, as it is just a one off job. I have local access to the server and also phpmyAdmin and MySQL Administrator access. Link to comment https://forums.phpfreaks.com/topic/112577-moving-tables-from-1-database-to-another/ Share on other sites More sharing options...
br0ken Posted June 30, 2008 Share Posted June 30, 2008 Use phpmyAdmin to create a SQL Dump file of your database. Open this up and extract the information for the two tables you want to copy, change the database name at the top and then run. This would work for you. Link to comment https://forums.phpfreaks.com/topic/112577-moving-tables-from-1-database-to-another/#findComment-578297 Share on other sites More sharing options...
dmccabe Posted June 30, 2008 Author Share Posted June 30, 2008 Excellent, I will give it a go when I am back at work thanks! Link to comment https://forums.phpfreaks.com/topic/112577-moving-tables-from-1-database-to-another/#findComment-578445 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.