Am 20.06.2013 15:18, schrieb Peter: >> >>> I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole >>> database directory) from one crashed machine to another. >>> I find that I cannot start database to get the database data any more. > >>> How did you copy the database? >>> Manuel > >> I copy the files ib_logfile0 ib_logfile1 ibdata1 into /var/lib/mysql in >> linux and the whole database directory my_database_name into >> /var/lib/mysql/my_database_name, the same location as previous machine /var/lib/mysql/my_database_name
>and your "my.cnf"? >you hardly can move innodb around without the same settings sorry for the previous post missing the file. the my.cnf file is same in both machines.as follows: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Peter