How to restore SQL DB from local clean backup?

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.

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

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

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

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

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.

I must be thinking of another CMS.

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost

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

-Scott

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