Announcement

Collapse
No announcement yet.

failed to restore a database dump

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • failed to restore a database dump

    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'

  • #2
    Hi,

    That's why i prefer use mysqldump:
    Code:
    mysqldump --opt -Q -u user -p oreon > oreon.sql

    Comment

    Working...
    X