800MB+ SQL file for Wordpress to Cpanel/phpMyadmin on CentOS VPS

Good Evening,

I am using a CentOS server with Cpanel and trying to work out the best way to migrate some Wordpress sites.

One of the sites has a SQL database of 800MB+ which phpMyadmin is struggling with in-browser.

Is there a fool-proof way to upload this SQL and get this Wordpress installation up & running?

Any help appreciated :)
susseditAsked:
Who is Participating?
 
eemitCommented:
If you can export it using phpMyAdmin (using compression to GZip-Compressed), then you can try the tool "bigdump" to import it.
0
 
Mitchell MilliganInformation Technology Network AdministratorCommented:
Do you have WHM access on the destination end of the move?  If so, you could export the cpanel account by doing a full backup in cpanel and then importing it in WHM.  That would take the load off of the browser and place it on the server instead.
0
 
Mitchell MilliganInformation Technology Network AdministratorCommented:
Or just do a sql backup through cpanel and then restore the cpanel backup of the mysql database in the destination if you just want that part of it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.