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

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.
Poly11Asked:
Who is Participating?
 
c_a_n_o_nCommented:
Try BigDump http://www.ozerov.de/bigdump.php
Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

I have used this PHP script and works well for importing large MySQL databases without timouts!
0
 
KalpanCommented:
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/
0
 
MatazaCommented:
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.
0
 
Poly11Author Commented:
Thank You!
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.