Dotaz: Pomoc s prenesenim databaze

[OgeeN]

Ahoj,
Situace:
Mam novy server se zakladni instalaci Debianu Sarge a s nainstalovanym mysql 4.1. Do tohoto noveho serveru jsem pripojil pevny disk ze stareho serveru( stary server je nefunkcni vubec nenabootuje).
Ja ted potrebuju prenest veskere databaze z disku ze stareho serveru na novy server a to vcetne definovanych uzivatelu a vsech tabulek.
Existuje zpusob jak to provest?
Diky moc za pomoc.

Odpovědi

[Ja.]

Jasne. Vlez do adresare mysql (tusim ze /var/lib/mysql) a tam jsou adresare pro jednotlive DB (v adresari mysql je DB mysql a v te jsou uzivatele, opravneni apod.).
Nejdrive vypni novy mysql, pak presun tyhle adresare do noveho /var/lib/mysql (tj. na novem systemu) a pak spust mysql...
CAu

[OgeeN]

To mi bohuzel vyhodilo tuhle chybu:

Jan 1 08:55:05 localhost /etc/init.d/mysql[27411]:
Jan 1 08:57:08 localhost mysqld_safe[27510]: started
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 InnoDB: Database was not shut down normally!
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: Starting crash recovery.
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: Reading tablespace information from the .ibd files...
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: Restoring possible half-written data pages from the doublewrite
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: buffer...
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 InnoDB: Starting log scan based on checkpoint at
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: log sequence number 0 376201.
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: Doing recovery: scanned up to log sequence number 0 376247
Jan 1 08:57:08 localhost mysqld[27513]: InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin.000040
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 InnoDB: Flushing modified pages from the buffer pool...
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 InnoDB: Started; log sequence number 0 376247
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Jan 1 08:57:08 localhost mysqld[27513]: 020101 15:57:08 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
Jan 1 08:57:08 localhost mysqld_safe[27523]: ended
Jan 1 08:57:14 localhost /etc/init.d/mysql[27586]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 1 08:57:14 localhost /etc/init.d/mysql[27586]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jan 1 08:57:14 localhost /etc/init.d/mysql[27586]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 1 08:57:14 localhost /etc/init.d/mysql[27586]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 1 08:57:14 localhost /etc/init.d/mysql[27586]:


[OgeeN]

Tak byla chyba v pravech.
Uz to bezi. Dik.