About 40 hours since my Dreamhost hosted blog got hacked (TechSangam.com). Most of my PHP files were infected and some file permissions were also messed up — Dreamhost abuse team fixed that but it was clearly safer to start a clean WP install.
I had 2 separate DB export files (one retrieved from Dreamhost’s backup process), the 2nd was an explicit “Export sql file” via phpMyadmin. Was using the 2nd one unsuccessfully until I realized that when I did a fresh Dreamhost “One Click” install, I had used the “existing db” as the option. Later Dreamhost forum post showed that it wouldn’t work — in the process an extra set of DB tables (with new prefixes) were created. After I realized this, I dropped those new DB tables, did a re-export and tried the import. Still didn’t work.
Then I switched to using the export file from Dreamhost backup – which only had one set of db prefix tables. I created a brand new WP install at techsangam/com/wp2/
Dreamhost’s One Click install creates a new database with the 11 WP tables. Add the my 20 imported tables from the backup (with a different prefix) – I have 31. Changing the DB_PREFIX to the imported tables. Loading up techsangam.com/wp2/ gives me a “Oops! This link appears to be broken”.
Am in the process of getting the DEBUG_MODE working but any suggestions — will be HIGHLY appreciated.
Thank you! THANK YOU all!
- The topic ‘Recovering from hacking – import from old db to new installation not working’ is closed to new replies.