Backup, what am i missing??

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

On a fresh install of OS 2.2 M

I keep getting this error when trying to restore a backup I make:

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]

Could someone suggest where I am going wrong.......

Is this a fault with mysql ??

Running on localhost with

Win32, Apache, PHP Version 4.3.2-RC2 , Mysql(Latest)

I have completed a whole site ready to go live, but would like to know why this is happening as I do not wish to have these problems when I do go live.
The backup function is an important part of the store, so it is vital that I figure this.......



Plz can anyone suggest where I should start solving this problem......cannot find anything in the forum posts !!!  :evil:
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.