Jump to content


Photo

Server to Server copy


  • Please log in to reply
1 reply to this topic

#1 zawadi

zawadi
  • Members
  • PipPip
  • Member
  • 25 posts
  • LocationChippenham UK

Posted 23 March 2006 - 01:06 PM

Hi, I need some help please.

I have just had a mysql database activated online, but I can only accsess it from my website online or the hosts copy of phpmyadmin. I need to move about 20MB and phpmyadmin hangs if i tyr the lot in 1 go.

can any 1 help?
That's the beauty of asymmetric warfare. You don't need a lot of money, or an army of people. You can do it from the comfort of your living room, with a beer in your hand.

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 23 March 2006 - 02:31 PM

20MB of files or 20MB worth of DB info? My suggestion would be to run an export on the old database and then an import on the new one. I don't think a direct transfer is possible. To cut this down, you can only export certain tables, doing it in chunks. Keep in mind that depending on the options you choose in phpmyadmin, it's going to take a while for the file to be generated and sent to you as a download. I'd suggest doing the zipped version as well, as it'll take about 1/10th of the time.

Info: PHP Manual





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users