Ad Widget

Collapse

MySQL error while importing mysql.sql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • serge.fonville
    Junior Member
    • Jul 2007
    • 8

    #1

    MySQL error while importing mysql.sql

    When I try to import create/schema/mysql with "cat mysql.sql | mysql zabbix" I get
    Code:
    [SIZE=2]"ERROR 1005 (HY000) at line 2: Can't create table './zabbix/slideshows.frm' (errno: 121)"[/SIZE]
    /etc/my.cnf
    Code:
    [SIZE=2][mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    default-collation=utf8_general_ci
    default-character-set=utf8
    default-storage-engine=InnoDB
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid[/SIZE]
    edit:
    After running
    Code:
    [SIZE=2]"yum remove mysql mysql-libs mysql-devel mysql-server php-mysql perl-DBD-MySQL"[/SIZE]
    I created the database then imported.
    Now everything imported flawlessly
    Last edited by serge.fonville; 26-07-2007, 10:06.
Working...