I need help restoring from saved database (with a few twists)

Hiya….

It’s not vanilla simple, but it’s not too complicated either – especially for someone who’s got xampp working.

Navigate to localhost/phpmyadmin. Create a database for wp, doesn’t matter what you call it. Then click the tab for “import” (or if you have an older version, it may be under the sql tab); navigate to the backed up database on your hard drive, click “Go”.

You’ll see a message when the import is finished. Then you’ll need to change the wp-config.php info to match the login stuff for your xampp install (mine, f’rinstance, is username root, no password, database wp1 or whatever, and servername localhost – no password is designated by two single quotes with no spaces between); and once you’ve input that, you should be able to access wp on your xampp server just as if you were online.

And it’s VERY late for me, so if you have problems, please just email me at vkaryl *at* bytehaven *dot* com; I have a hardware install in the morning early but will check email as soon as I can.

Yeah, I have done that already on the localhost. =P I still have a copy of the “main blog” on it, I just basically used the database name, from the orginal online main blog..then basically did what vkaryl said above.. =) Also, used Podz’s guides as references too.. =)

I made a new database in the localhost/phpMyAdmin called the same, as from main online blog.

Had the “drop tables” and “add tables” from the one Podz’s guide on backing up the database..then imported the “main online” blog’s database informations..

I’m even still logging into that blog on the localhost, with my original login user and password from the online main blog..

spencerp

What I had done was, only grab each “section” of the restore file itself, one at a time.. Like the drop and add tables for *just* one “table” at a time..

Also, if it’s so *huge*, as long as you add the “drop and add tables” and created a “specific table”, you can always just copy and paste into it, the “Inserts” for that table… a chunck at a time.. That’s what I had to do with mine..

First..

Example only:
— Table structure for table wp_categories
—

DROP TABLE IF EXISTS wp_categories;
CREATE TABLE wp_categories (
< —- snipped —–> ;

Then after that table is added:
Example only:
— Dumping data for table wp_categories
—

INSERT INTO wp_categories (cat_ID, cat_name, category_nicename, <–snipped —>);

And add ALL of the inserts..from or for each table..

spencerp