Re: Restoring mysql 3.23.54a-0.woody backups to 4.0.24-10 (sarge)
Sorry.. here are the details of the syntax errors:
mobile:~# mysql -u root -p < mysql_backup.sql.sql
Enter password:
ERROR 1064 at line 20: 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 'from varchar(255) NOT NULL,
return-path varchar(255) NOT NULL
mobile:~# head -35 mysql_backup.sql.sql| tail -20
-- Table structure for table 'mails'
--
DROP TABLE IF EXISTS mails;
CREATE TABLE mails (
id int(10) unsigned NOT NULL auto_increment,
tipo char(1) default NULL,
sub varchar(255) NOT NULL default '',
from varchar(255) NOT NULL,
return-path varchar(255) NOT NULL,
to varchar(255) NOT NULL default '',
path text NOT NULL,
size int(10) unsigned default NULL,
data date default NULL,
hour time default NULL,
ip varchar(15) NOT NULL default '',
atts varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
Thank you
Tom
Em Qui 04 Ago 2005 13:19, Tom escreveu:
> Hello!
>
>
> I have a old woody mysql 3.23.54a DB and have to transfer all
> databases and privilegies tables to a new mysql installation,
> version 4.0.24-10, running on debian sarge.
> Well, I ran
>
> mysqldump -u root -p --opt -A > mysql_backup.sql
>
> to create it, and when I tried to restore on the new system (mysql
> 4.0.24-10 on sarge), I got 'syntax errors' from 'mysql_backup.sql'
> file =(
>
> Some hint?
>
>
> PS: I searched on google, debian maillist and mysql doc with no
> results.
>
>
> Thank you
> Tom
Reply to: