Re: [gentoo-user] about mysql db backup... [SOLVED]
Bastian Balthazar Bux wrote: Seung Hyun Cho ha scritto: Hi, I've copied db folder in /var/lib/mysql to my new gentoo server from fedora server. When I connect to mysql in gentoo, I've got this error message... like... MySQL Error: 1017 (Can't find file: './db/table_xxx.frm' (errno: 13)) What is going on here? What should I do??? thanks. - the version of the dbserver are the same ? - check your /etc/mysql/my.cnf (not /etc/my.cnf) for datadir = /var/lib/mysql - check that /var/lib/mysql/mysql/db.frm exists - check that /var/lib/mysql/ is owned from mysql Regards Francesco -- gentoo-user@gentoo.org mailing list I didn't change the ownership of files... Thanks... -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] about mysql db backup...
Seung Hyun Cho ha scritto: Hi, I've copied db folder in /var/lib/mysql to my new gentoo server from fedora server. When I connect to mysql in gentoo, I've got this error message... like... MySQL Error: 1017 (Can't find file: './db/table_xxx.frm' (errno: 13)) What is going on here? What should I do??? thanks. - the version of the dbserver are the same ? - check your /etc/mysql/my.cnf (not /etc/my.cnf) for datadir = /var/lib/mysql - check that /var/lib/mysql/mysql/db.frm exists - check that /var/lib/mysql/ is owned from mysql Regards Francesco -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] about mysql db backup...
Seung Hyun Cho wrote: Hi, I've copied db folder in /var/lib/mysql to my new gentoo server from fedora server. When I connect to mysql in gentoo, I've got this error message... like... MySQL Error: 1017 (Can't find file: './db/table_xxx.frm' (errno: 13)) What is going on here? What should I do??? Try exporting the tables the ordinary way (mysqldump) on the fedora box and then importing them on the gentoo box. /Andreas -- gentoo-user@gentoo.org mailing list
[gentoo-user] about mysql db backup...
Hi, I've copied db folder in /var/lib/mysql to my new gentoo server from fedora server. When I connect to mysql in gentoo, I've got this error message... like... MySQL Error: 1017 (Can't find file: './db/table_xxx.frm' (errno: 13)) What is going on here? What should I do??? thanks. -- gentoo-user@gentoo.org mailing list