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

Posted on 2011-04-20
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?

Question by:Poly11
    LVL 14

    Expert Comment

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

    Please refer the following

    Expert Comment

    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.
    LVL 10

    Accepted Solution

    Try BigDump
    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!

    Author Closing Comment

    Thank You!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
    The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now