I'm moving Photocart from a VPS to a fully Dedicated server.

Reason, I've simply outgrown the VPS and the Dedicated Server offers 1TB of storage 8 cores and 8GB ram, Gigabit Pipeline so way more grunt

My SQL file is 300mb.

Using the suggested method of exporting via admin and importing via admin won't work, as the file size is too large, and I'm hitting the max file size limit on import.

Question:
1) Can I backup the SQL file via cPanel, and restore it via cPanel on the new server
2) Is the SQL backup file that photocart creates from its internal Admin Backup the same as the cPanel backup with the exception Photocart adds the date the the original file name?
3) Any other suggestions?

The Dedicated server support guys suggetsted a SQL file splitter, but I trying for a more direct route first

Edited by

You will need to export the database from PHPMyAdmin in your hosting control panel then import it the same way on the new host.

Edited by

As I have already mentioned above, importing via PHPMyAdmin won't work, as the file size is too large, and the import fails

Edited by

You will have to break down the export, only exporting so many tables at a time.

You could probably export all the tables except for pics, and pc_gallery_stats at one time and import those.

Then go back and export the pics table and pc_gallery_stats table individually.

When exporting those, change "Maximal length of created query" from 50000 to 10000 which may help them import.

If you can't get those to import, then you will have to manually edit those files and break them into smaller files.

Edited by