Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Backup, what am i missing??


Recommended Posts

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;




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:

Link to comment
Share on other sites

  • 4 weeks later...

Why don't you just run a cron job and use mysqldump?


me@mine:/etc/cron.daily$ su -c "cat /etc/cron.daily/sql_backup"



mysqldump --add-drop-table --host=localhost --user=root --password=mypass -B shop > /my/path/shop.sql



John Croson

Technology Operations Manager

Racine Art Museum

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...