• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

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.
0
Poly11
Asked:
Poly11
1 Solution
 
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
 
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
 
Poly11Author Commented:
Thank You!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now