Restore Nightmare

Thanks guys,

Podz asked,

“Do you have SSH access (command line) to the server? If you do life becomes easier.” How would I know?

“Do you have access to the original database?” Yes.

“Does the exported file contain any stats data which could be dumped?” The blog is a WP 1.5 so many of the plugins are probably out of date and I haven’t copied those over yet. I hope that’s OK. Also, my backup starts with Blacklist. I assume that’s from a plugin. My guess is this could be deleted. Is that correct?

I doubt if there is any other stats data, but I’m not totally sure.

Also, I didn’t get an answer about if I miss a line. Can the db tell if something is missing and let me know or would I just be out of luck?

Coolzor, every line is a separate line. Here’s what it looks like.

INSERT INTO wp_bas_log VALUES (11001, ‘2005-12-14 10:49:26’, 0, 22);
INSERT INTO wp_bas_log VALUES (11002, ‘2005-12-14 10:59:07’, 0, 2);

Those are two separate lines. I don’t know if that gives you enough info to know if it’s a structured data base or not. What do you think?

Thanks guys for your help.

I started copying and pasting and got this error…

INSERT INTO wp_bas_visitors
VALUES ( 489, 1073186778, 2, 5, 5, ‘2005-06-15 16:34:09’ )
MySQL said:

#1146 – Table ‘visitors_wrdp1.wp_bas_visitors’ doesn’t exist

What do I do now?

Thanks Podz, I’m still not clear on what happens if I miss a line. Could you clear that up for me?

Also, related to that, does it seem that I can delete the Blacklist as well?