database - DROP TABLE IF EXISTS `wp_options` error?

admin2025-01-07 5

I am trying to manually restore my WordPress site which has been backed up using Updraft plus plugin. I uploaded & extracted all the files to their respective folder. However, when I tried to upload database via PhpMyAdmin I got following error.

How to fix this issue?

Share Improve this question edited Feb 13, 2017 at 13:41 prosti 4,3134 gold badges25 silver badges45 bronze badges asked Feb 13, 2017 at 6:55 basic123 111 silver badge1 bronze badge

2 Click on Databases at the top and select the database. If the database no longer exists, create a new one under the same tab. – Dave Romsey Commented Feb 13, 2017 at 7:10

Add a comment |

4 Answers 4

Sorted by: Reset to default 0

Check this ref. If you don't have the database create instruction inside your script:

CREATE DATABASE your_db;

You need to manually do that.

Else if you have the database:

use this to select it first before executing the script.

USE your_db;

It seems that you have not select the database in which you want to execute your query.

Please execute following query first to select your database:

use database_name

Or else in your query add database name before table name like

drop table if exists databasename.tablename

You must be inside a database before importing.

simple answer, open with your favorite editor the .sql backup file, and with ctrl+F find that line, comment it out or delete it and try again, that error will no longer exist

转载请注明原文地址:http://conceptsofalgorithm.com/Algorithm/1736258507a517.html

databaseDROP TABLE IF EXISTS wpoptions error

最新回复(0)