Thread: Can't move database - too large

Hey guys,

I am trying to move my larger blog to a new host because our current host is being completely unreasonable with numerous things.

When I backup the database via phpMyAdmin and try to upload that backup to the new host, it tells me the file is too big.

I have tried to run the "Big Dump" script, but it's no good.

Does anyone have an experience moving a large mySQL database and getting through this problem? And if so, can you help me? I'd really like to move my host, but this damn limit is stopping me!

Thanks guys.

Hello,
Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.

Originally Posted by KDisk

Hello,
Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.

Yes, they both use cPanel...I will look at that, thanks.

Originally Posted by KDisk

Hello,
Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.

That's still too big.

Would copying and pasting like half of the file into a new file, and uploading the two halves work? I am thinking of trying that, as I don't see why it couldn't work.

Yeah lol, I'm desperate now.

Is it a wordpress blog? If you don't have too many plugins that store table data, you might simply want to export and import using wordpress.

Exporting the data should be easy, importing it is where you need to split your sql files in multiple files and upload one by one.

Alex,
Please feel free to drop me an e-mail @ KMyers @ K-Disk.com and I will be happy to offer some one-on-one assistance with this

Originally Posted by billcrust

Is it a wordpress blog? If you don't have too many plugins that store table data, you might simply want to export and import using wordpress.

Exporting the data should be easy, importing it is where you need to split your sql files in multiple files and upload one by one.

Yes, it's a Wordpress blog. I'm pretty sure that it's the plugins that are giving me the errors. I am going to try to split the files, do you know of a fast way to do it? I tried copying and pasting it but there are thousands and thousands of lines and it would take forever.

Originally Posted by KDisk

Alex,
Please feel free to drop me an e-mail @ KMyers @ K-Disk.com and I will be happy to offer some one-on-one assistance with this

If I can't split the files I will definitely email you for sure. Thanks.

WoW this is definitely something,how big is your database,it should be quite large if it cant be moved,maybe you could delete some tables that can be replaced

You can also backup and restore individual tables using phpMyAdmin.

If you are using wassup, that could be your problem. I stopped using it because it is an incredible resource pig. If you are using that plugin and you have not changed the default settings, it keeps building history forever and tables get very large. You can delete the history in the configuration screen.

Originally Posted by TopDogger

You can also backup and restore individual tables using phpMyAdmin.

If you are using wassup, that could be your problem. I stopped using it because it is an incredible resource pig. If you are using that plugin and you have not changed the default settings, it keeps building history forever and tables get very large. You can delete the history in the configuration screen.

What TopDogger suggested is a very good idea if you dont have any other choice,but that has to be quite a large DB if you cant move it any conventional way