MySQL Database import

[kinge4880]

I need to import a database from a MySQL dump for a WordPress blog that was previously hosted elsewhere. Can someone please provide instructions for this?

Thanks.

 

[descalzo]

Go to cPanel
MySQL Databases
Create the WP database. And user. Attach user to DB with ALL Privileges
Go to cPanel
PHPMyAdmin
Go to your database
Click on Import on top menu
Browse for the file on your computer, choose it
Go

 

[kinge4880]

Thanks for the response. I found the import, but now it looks like I won't be able to upload the database because there is a 50MB size limit and my database is 90MB (contains 6+ years of WP data). Is there a way around this?

 

[descalzo]

Unzip the file on your computer.
Make 3 copies of the file for 4 total.
Open #1 in Notepad++ and edit so you just have the first 1/4 of the file. Make sure you include complete SQL statements
Repeat 3 times, leaving each copy with 1/4 of the file.
Zip each individually.
Import each in order.

Should work. Bit of a pain.

 

[kinge4880]

Ok. So i broke the file in to 5 parts and have slowly (very slowly) been importing it. However On one of the files I hit my CPU utilization limit and my account suspended, but part of that file made it in so I have been having to pull out the duplicate lines and re-import. The file literally has one line left to import which does not appear to be a duplicate, but every time I try to import it, my account gets suspended. I still have one file to import after this one. This is very frustrating.