Backup, what am i missing??

[weird2u2]

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:

[jcroson]

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"

Password:

#!/bin/sh

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

 

JC