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
657 Members
Windows Troubleshooting
Windows Troubleshooting
579 Members
Best Windows Software
Best Windows Software
561 Members
Mac OSX Tips & Issues
Mac OSX Tips & Issues
253 Members

Comments for this Question are closed.

Answers (3)
  • Aibek

    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.



    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