How can I restore the .sql file in WordPress?

Bhavesh January 28, 2011

I have a self-hosted WordPress site. I have installed a plugin “Wordpress Database Backup” for backups.

Now I want to restore .sql file. How do I do that? I tried phpmyadmin, one method is stated by WordPress site, but when I did it, my site crashed. Now how do I use that .sql file to restore?

  1. Aibek
    January 31, 2011 at 10:47 am

    Hi Bhavesh,

    I suggest using WP DB Manager plugin instead,

    Among several features there an option to restore the database. It should let you restore the database backup file you have.


    January 29, 2011 at 5:53 am

    Hello, you can try this method, maybe it helps you.

    -- Log in to phpMyAdmin
    -- Click Databases
    -- Select target database (This is the database where you want your information to go)
    -- tables in database will appear
    -- Click Import Tab
    -- Click Browse and point it to backup file
    -- Check SQL radio button
    -- Click Go button.

    Wait until it finishes running. Hopefully it will succeed.

    • Aibek
      January 31, 2011 at 10:48 am

      If I am not mistaken there is a 2 max. 2MB file size restriction when importing via PhpMyAdmin.