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. Quote Link to comment 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. Quote Link to comment 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! 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.