How can I restore the .sql file in WordPress?
Question by Bhavesh /

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
Browse other questions & answers in the category ; tagged , , , , ; or ask your own question.

Comments for this Question are closed.

If you are looking for help, please ask a new question.

We will be happy to help you!

Answers (3)
  • Aibek

    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

  • FIDELIS

    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

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