2013/6/20 Peter <one2001boy@stripped>
>2013/6/20 Peter <one2001boy@stripped>
>>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?
>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
>Was MySQL daemon stopped in both machines? It must be stopped in both of them.
>If you cannot afford stopping your mysql, you might want to take a look at
yes, the mysql daemon was stopped during the copy.
actually, the old machine cannot run anymore, and I copy it over from another machine by
moving the disk to another machine.