| Author |
Message |
chump
Joined: Jun 06, 2006
Posts: 1
|
 Posted:
Tue Jun 06, 2006 8:49 pm |
|
i have anb installed on my site, and it works great....my problem is, when i try to restore a backup with the backup file sent to my email i get this error message in phpmyadmin
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 646
STR: =;
SQL:
CREATE TABLE `nuke_advbackup` (
`id` int(11) NOT NULL default '0',
`backupdir` varchar(100) NOT NULL default 'backup',
`mail_to` varchar(255) NOT NULL default '',
`mail_from` varchar(255) NOT NULL default '',
`excludes` varchar(255) NOT NULL default '',
`lastdb` varchar(25) NULL,
`lastfile` varchar(25) NULL,
`autostate` varchar(4) NOT NULL default '',
`autoinc` int(11) NOT NULL default '48',
`autolast` int(22) NOT NULL default '0',
`autogzip` varchar(4) NOT NULL default '',
`automail` varchar(4) NOT NULL default '',
`autodel` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=;
what am i doing wrong? i can backup my db other ways and it works fine when i try to use the sql file.....why dont these backup files work for me? thanks for your help  |
| |
|
|
|
ThaPizza
Joined: Jun 09, 2006
Posts: 2
|
| Posted:
Fri Jun 09, 2006 3:11 am |
|
I have the same problem.
I found out when I needed to put a database file back 
Anyway I created a MySQL backup in the MyAdmin tool, which saved my ass
Did you find the answer already Chump? Or still searching? |
| |
|
|
|
gotcha
Site Admin
Joined: Oct 25, 2004
Posts: 894
|
| Posted:
Fri Jun 09, 2006 4:08 pm |
|
The problem is with this part:
it should really be
You can fix your backup by doing a find/replace of the above with a decent text editor.
To fix this, open up includes/dump.php
Find
| Code: |
$structure .= ") TYPE=".$statusrow['Type']; |
Change to
| Code: |
$structure .= ") TYPE=".$statusrow['Engine']; |
|
| |
|
|
|
ThaPizza
Joined: Jun 09, 2006
Posts: 2
|
| Posted:
Fri Jun 09, 2006 4:21 pm |
|
That works like a charm 
Thx alot m8  |
| |
|
|
|
|
|
