wendyhouse

Would converting the backup .sql text file into WXR then importing it into my working (relatively empty) 2.9.2 blog be a solution route to getting my blog history re-instated?

If so, can you guys point me to a converter? I’ve not yet been able to find one using a web-search… …and I’m not even sure this approach will work.

Expert opinion, guidance would be much appreciated 🙂

Does anyone have any constructive suggestions or could help me to troubleshoot by asking me to check aspects of my config file or sql database?

I do not know the formatting rules that are acceptable for a import/expert back-up file.

Hence despite knowing how to use many different text editors – I do not know ‘how’ to ‘split’ the contents of a back-up file in a way that does not cause errors during the restore.

I was hoping that you guys could help.

Thank you for taking the trouble to – think about this – give me relevant useful information.

Now I know the text I am looking for is create table rather than create database.

I tried deleting (using wordpad) the create table text (illustrated below) from the backup made automatically by wordpress. Then tried importing the file with this missing text using MyPhpAdmin UI, making sure to select V4 compatibility drop-down.

The restore failed – in that the test posts in the V5 database are what shows on my blog 🙁

Maybe there is some other problem. Both Starfieldtech and Godaddy said that the crate databse text was my problem. but could it be comething-else that interrupts a restore – like the size of the file (16.4 MB)? How would you recommend that I solve this? In my ideal world WordPress would provide an automatic restore back-up aswell as the automatic make-back-up.

I REALLY appreciate your input because you are wordpress experts, and supporters, not .sql server experts. I’ll do my best to help you to help me.

This is the text I deleted from my backup .sql before restoring it. The restore failed:

CREATE TABLE wp_startupcomments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID bigint(20) unsigned NOT NULL default ‘0’,
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default ”,
comment_author_url varchar(200) NOT NULL default ”,
comment_author_IP varchar(100) NOT NULL default ”,
comment_date datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default ‘0’,
comment_approved varchar(20) NOT NULL default ‘1’,
comment_agent varchar(255) NOT NULL default ”,
comment_type varchar(20) NOT NULL default ”,
comment_parent bigint(20) unsigned NOT NULL default ‘0’,
user_id bigint(20) unsigned NOT NULL default ‘0’,
comment_comvatar_url text NOT NULL,
comment_favicon_url text NOT NULL,
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt)
) TYPE=MyISAM ;

Sambol – thanks for answering!
at the bottom left hand side of IE it says “Done, but with errors on the page” and a little yellow triangle. This stays for about a minute then disappears