How to restore SQL DB from local clean backup?


#1

I am unfamiliar with the phpMyAdmin interface. I have 3 Wordpress blogs that got infected when I missed the last update. I restored the databases in the Dreamhost control panel, but the oldest copy there is 5 days old, and the infection was 6 or 7 days old. I have clean local copies that predate the infection, but could not figure out how to proceed in DreamHost’s phpMyAdmin interface. I know this must be possible! How do I get my local database backup restored into my blog? I need to delete or overwrite the databases of these blogs, because I am pretty sure the attack was an SQL injection to the DB.

I have already cleaned the visible foreign code out, updated Wordpress, and changed all passwords.


#2

You’ll first have to Drop all tables from the existing database. The interface has an Import link which you use to upload a local file.

-Scott


#3

Doesn’t WP have an embedded database restore function?

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#4

Thank you! I have found detailed instructions here, as well:

http://www.tamba2.org.uk/wordpress/restore/


#5

I don’t see anything about the database in the Wordpress admin screens. From what I’ve read so far, the only way in is via phpMyAdmin, whether in the ISP’s interface, or standalone.


#6

I must be thinking of another CMS.

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#7

WordPress only has an export/import function for posts and pages. It’s not that useful.

-Scott


#8

Ahh that must be what I was thinking of. Thanks Scott.

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost