Tweet
Hi,
when I try to restore a dump of the oreon database[0], I get an error.
In the database dump I found:
CREATE TABLE redirect_pages (
id int(11) NOT NULL auto_increment,
id_pages int(11),
pages varchar(255) NOT NULL,
right int(11) DEFAULT '1',
PRIMARY KEY (id)
);
RIGHT (5th line) is a reserved keyword for mysql and has to be set in backticks if we want to use it as a name.
You should rename this or let mysql set the names automagically in backticks.
/peter
[0] Created with the interface, restored with 'mysql -u oreon -p oreon < ~/2005-10-31-oreon.sql'
when I try to restore a dump of the oreon database[0], I get an error.
In the database dump I found:
CREATE TABLE redirect_pages (
id int(11) NOT NULL auto_increment,
id_pages int(11),
pages varchar(255) NOT NULL,
right int(11) DEFAULT '1',
PRIMARY KEY (id)
);
RIGHT (5th line) is a reserved keyword for mysql and has to be set in backticks if we want to use it as a name.
You should rename this or let mysql set the names automagically in backticks.
/peter
[0] Created with the interface, restored with 'mysql -u oreon -p oreon < ~/2005-10-31-oreon.sql'
Comment