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.

While what ykaryl posted above is entirely correct, this is a bit confusing for me from the OP:
want to restore my computer installation to a database backupped from my domain,

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

Hmm, that *is* simple. Unfortunately.. it didn’t work. My backup is 68 MB and Xampp doesn’t like that so it isn’t letting me upload at all, and I have no idea how to work around that.. help?

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

Do as Spencerp said above. Because that is the way, you can Import large DB.

You can also try SQLDump Splitter..

The GUI is in English. It will split your MySQL files into predefined chunks. And then start importing one by one.

The GUI is in English. It will split your MySQL files into predefined chunks. And then start importing one by one.

But then how do I merge them at the end?

After the split, you will have number of files ending with .sql

For restoration,
1. Login to your phpMyAdmin
2. Select your DB, then click on import.
3. From the list of Spilitted files, Select file “
*****com_****_phpmyadmin_DataStructure.sql first because it contains the structure Tables”.

After you get file import successfull.

4. Continue with next file starting starting 0 or 1 till last file.

…. Sorry I haven’t reported back..

I’ve basically given up on this for the moment. Thank you all anyway ??