Backup Restore DB not working

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227479#227479
----------------------------------------------------------------

Question:
I have been regulary keeping backups of my DB's as I have been entering product data. I have been adding HTML tags into the 'Product Descriptions'.

Will this cause a corrupt database, that will then not restore ??
____________________________________________________________

The whole store crashed the other day, just after I tried putting a <span> tag into the 'Product Name' section of admin, this was the first time for HTML tags into 'Product Name'...so can only assume this is the cause of first crash.

____________________________________________________________

To check this;

I have now reinstalled a fresh original database contained in the original install folder. And am now testing the Restore / Backup functions.

These do not appear to be working..!

I add one new catagory.
I make a backup.
I delete the new catagory
I then try to restore the backup_db that contained the new catagorie

I receive this error;

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'into address_book (address_book_id, customers_id, entry_gender,

create table address_book ( address_book_id int(11) not null auto_increment, customers_id int(11) default '0' not null , entry_gender char(1) not null , entry_company varchar(32) , entry_firstname varchar(32) not null , entry_lastname varchar(32) not null , entry_street_address varchar(64) not null , entry_suburb varchar(32) , entry_postcode varchar(10) not null , entry_city varchar(32) not null , entry_state varchar(32) , entry_country_id int(11) default '0' not null , entry_zone_id int(11) default '0' not null , PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (cuinsert into address_book (address_book_id, customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id) values ('1', '1', 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', '223', '12'); drop table if exists address_format;

[TEP STOP]



PLz plz can somebody send me in the right  direction....I feel quite lost now.
I have minimal knowledge with regards to mySQL and phpadmin.
So have no idear where to start !! But am keen to solve this... :)

Using 12/07/2003 osCommerce 2.2 Milestone 2