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: