Jump to content


Photo

*SOLVED* help on phpmyadmin


  • Please log in to reply
2 replies to this topic

#1 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 21 April 2006 - 01:34 PM

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!


#2 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 21 April 2006 - 01:46 PM

with the version of phpmyadmin that i'm using... this is what i'd do;

1. Login to phpmyadmin
2. Select the database
3. Click the Export link at the top of the page
4. Select all the tables in the list that i want to backup
5. Ensure Structure AND Data are selected
6. 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.
wisewood: proven fact, I am both wise, and wooden.

#3 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 21 April 2006 - 02:06 PM

thanks bro!!!

it worked!
:)





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users