33 pointsStarting to get into this DEV thingI'm new here
johnpent
Member
—
31st May 2011 (11 months ago)
Hi,
I was asked to move from one server to another as my database has grown out of control. The issue I am having is that I can download a 2.7 gig database all day long, no problem. Putting it back up is a huge headache. Now, I did it recently, but things are not right with the server I moved to. Having to do it again.
I tried the usual big dump, and it just found something wrong and could not do it. I uploaded it in pieces of 50 megs or less; of course that takes hours of tedious work just sitting and uploading.
I read all about phpmyadmin and how it could be done online directly from one install to the other. Of course it did not work as one side or the other just did not even allow the connection.
Before I go through the nightmare of so many tables split up, is there an easy way to do this? I searched everywhere, and there just does not seem to be a tool to do it.
I was asked to move from one server to another as my database has grown out of control. The issue I am having is that I can download a 2.7 gig database all day long, no problem. Putting it back up is a huge headache. Now, I did it recently, but things are not right with the server I moved to. Having to do it again.
I tried the usual big dump, and it just found something wrong and could not do it. I uploaded it in pieces of 50 megs or less; of course that takes hours of tedious work just sitting and uploading.
I read all about phpmyadmin and how it could be done online directly from one install to the other. Of course it did not work as one side or the other just did not even allow the connection.
Before I go through the nightmare of so many tables split up, is there an easy way to do this? I searched everywhere, and there just does not seem to be a tool to do it.
10626 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Sales & Support Lead
—
31st May 2011 (11 months ago)
#
Ugh. That's terrible.
Definitely no fun to split it up like that, but that's probably the way I'd tackle it as well. I'll ask a few of our resident gurus if they have an easier suggestion though.
Moving a big database is not fun at all and there will definitely be time out errors if you try doing it through phpmyadmin. If you have shell access, that is the best way to go about it (it is the fastest and less tedious route). If you do have shell access, you would do a dump on the old server via the command line, then do a wget of the file from the new server via the command line and then do an import. The command for the import can be found here: http://www.ehow.com/how_2036644_import-sql-database.html, under the Using the SSH Command Line section.
Responses (5)
Sales & Support Lead — 31st May 2011 (11 months ago) #
Ugh. That's terrible.
Definitely no fun to split it up like that, but that's probably the way I'd tackle it as well. I'll ask a few of our resident gurus if they have an easier suggestion though.
Any members have a tip here?
Thanks!
Member — 1st June 2011 (11 months ago) #
Moving a big database is not fun at all and there will definitely be time out errors if you try doing it through phpmyadmin. If you have shell access, that is the best way to go about it (it is the fastest and less tedious route). If you do have shell access, you would do a dump on the old server via the command line, then do a wget of the file from the new server via the command line and then do an import. The command for the import can be found here: http://www.ehow.com/how_2036644_import-sql-database.html, under the Using the SSH Command Line section.
Member — 1st June 2011 (11 months ago) #
Joshmac,
Thanks... that appears to be the solution. I have full access and that should work.
Thank you!
John
Member — 1st June 2011 (11 months ago) #
I am glad to hear it.
Member — 1st June 2011 (11 months ago) #
There are two great articles on WPMU.org
1) 8 Tips for Keeping a Squeaky Clean WordPress Database
http://wpmu.org/8-tips-for-keeping-a-squeaky-clean-wordpress-database/
and
2) How to Backup and Import a Very Large WordPress MySQL Database
http://wpmu.org/how-to-backup-and-import-a-very-large-wordpress-mysql-database/
Become a member