How can I restore the .sql file in WordPress?

Bhavesh January 28, 2011
Pinterest Stumbleupon Whatsapp

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?

Ads by Google

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

    Hi Bhavesh,

    I suggest using WP DB Manager plugin instead, http://wordpress.org/extend/plugins/wp-dbmanager/

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

    Aibek

  2. FIDELIS
    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.