We help IT Professionals succeed at work.

I have a 6MB .SQL file that needs to be imported for use with Word Press

Medium Priority
438 Views
Last Modified: 2012-05-11
Good morning.

I have inherited a Word Press site and have been provided the actual .sql database. I use Plesk and have attempted to import the database using PHP MyAdmin, however the process times out and a complete import cannot be completed. I do see where it says 2MB max, therefore I have zipped the file which made it less than 1MB.

I have no way of contacting the former web developer and only have this .sql file. Is there another way that I can get this .sql file imported?

Thanks.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
you can import through the mysql client using linux. no need to zip that file, instead just split that...

Please refer the following

http://wpmu.org/how-to-backup-and-import-a-very-large-wordpress-mysql-database/

Commented:
If you got login, password, ip and port to mysql server, try use Navicat software.

It's pretty easy; just fill in login and password, create database if needed then import mysql file.
It should bypass the phpMyAdmin 2mb limit.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank You!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.