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

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?



Browse other questions & answers in the category ; tagged , , , , .
Join live MakeUseOf Groups on Grouvi App Join live Groups on Grouvi
Windows_10
Windows_10
534 Members
Windows Troubleshooting
Windows Troubleshooting
455 Members
Best Windows Software
Best Windows Software
455 Members
Mac OSX Tips & Issues
Mac OSX Tips & Issues
228 Members

Comments for this Question are closed.

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.

New comment

Please login to avoid entering captcha

Log In