Database Restore gives error

weird2u2 <[email protected]>
Newsgroups gmane.comp.web.oscommerce.installation
Message-ID <ad4a09e009744453b0ddb92b544ff018@osCommerce-Forums>
This message was sent from: Installation and Configuration
http://forums.oscommerce.com/viewtopic.php?p=227528#227528
----------------------------------------------------------------

I have been testing the Restore / Backup functions on fresh installed 2.2OS

They do not appear to be working..! 

I add one new catagory.

I make a backup of the database. 

I delete the new catagory 

I then try to restore the backup_db that contained the new catagory

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 am not entirely sure if this is where the problem lies.. 

So have no idear where to start !! But am keen to solve this...  

Any clues plz... :roll: 

Using 12/07/2003 osCommerce 2.2 Milestone 2
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.