Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 > all.sql
When this command is run I receive these error messages:
mysqldump: mysqldump: Couldn't execute 'show create table `help_category`':
Can't find file: './mysql/help_category.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `help_keyword`':
Can't find file: './mysql/help_keyword.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `help_relation`':
Can't find file: './mysql/help_relation.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `help_topic`': Can't
find file: './mysql/help_topic.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `proc`': Can't find
file: './mysql/proc.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `procs_priv`': Can't
find file: './mysql/procs_priv.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `time_zone`': Can't
find file: './mysql/time_zone.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table
`time_zone_leap_second`': Can't find file:
'./mysql/time_zone_leap_second.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table `time_zone_name`':
Can't find file: './mysql/time_zone_name.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table
`time_zone_transition`': Can't find file:
'./mysql/time_zone_transition.frm' (errno: 13) (1017)
mysqldump: mysqldump: Couldn't execute 'show create table
`time_zone_transition_type`': Can't find file:
'./mysql/time_zone_transition_type.frm' (errno: 13) (1017)
When I recover the databases using this command:
mysql --force -u root -p -h localhost < all.sql
Tables are missing (and not the ones the dump is complaining about) and
relations are broken.
I'm assuming that the dump is dying before all the data is received.
Can anyone give me advice on how to obtain a clean dump with all the tables so
I may sleep well at night?
I'm using MySQL 4.0.26 client and sever for these databases.
I had thought that using the --force switch would alleviate my concerns.
Unfortunately not...
Best regards,
perror 13
Error code 13: Permission denied
Mysql does not have permiission to read its own tables.
Perhaps you have been testing recovery strategies as root, and have
changed the permissions?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
