pixeltrace Posted April 21, 2006 Share Posted April 21, 2006 guys,i need help.how can i import or transfer my database from my old sqldatabase from my new sqldatabase?i transferred my website to a new webhosting provider so i need to transfer all my database from them.its quite a big database and i now there is an easy way to transfer my database to the new one but i dont know how.hope you guys can help me with this.thanks in advance! Quote Link to comment Share on other sites More sharing options...
wisewood Posted April 21, 2006 Share Posted April 21, 2006 with the version of phpmyadmin that i'm using... this is what i'd do;1. Login to phpmyadmin2. Select the database3. Click the Export link at the top of the page4. Select all the tables in the list that i want to backup5. Ensure Structure AND Data are selected6. Click Go.This will give you the mysql data which you can copy and then paste into phpmyadmin's SQL query box on the new host.Hope this helps. Quote Link to comment Share on other sites More sharing options...
pixeltrace Posted April 21, 2006 Author Share Posted April 21, 2006 thanks bro!!!it worked! :) 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.