Recent Topics

1 Dec 07, 2005 11:33    

So my host rolled back my MySQL db to April. Don't ask. They're idiots.

I acquired a back up of the lost posts two months after this had happened. I've got all the posts from the start of my blog to last April and from the tail end of October till now in my current DB. I have, on my desktop, a mysql file with all of the posts from the beginning of my blog to the beginning of October.

Is there any easy way to just insert those posts missing in my current DB?

I've got phpmyadmin on the server, my host is *nix, and my desktop is OS X.

2 Dec 07, 2005 12:46

I don't know exacly the way how to do it, but this is the way I would do it :

Download every file and open it in wordpad.
Purge your hitlogentries (they take up to mutch lines)
Make one file your main file (I suppose the file with the oldest posts in it
Compare every bit of table and add the missing lines in the main file
See that you have no duplicate numbers

create a new database and start uploading table by table.
Check if your database is working.
Finished (change the definitions in _config.php.

3 Dec 08, 2005 02:20

What's wordpath?

Is there any convenient way to handle the different IDs (since the numbers will be out of order/duplicated)?

4 Dec 08, 2005 10:27

wordpad is a normal texteditor on every pc.
It can handle langer files than notepad.

5 Dec 08, 2005 10:30

My desktop is OS X.

It's alright tho, I just imported the sql into my db under a different table name and played around till i got everything working. It was much easier to deal with inside phpmyadmin.


Form is loading...