pluto_main.Package_Version preventing dump

[royw]

Howdy,

Probably not a common case but thought I'd document an unusual occurrence.

My system was 0710 beta 4 i386 upgraded to RC1 via DVD install with keep database option.

While attempting a database dump of pluto_main I got:

Code Select Expand


linuxmce@dcerouter:~$ mysqldump -u root --databases pluto_main     >pluto_main.sql
mysqldump: Got error: 1146: Table 'pluto_main.Package_Version' doesn't exist when using LOCK TABLES


Here's some investigation using mysql:

Code Select Expand


mysql> use pluto_main;
mysql> show tables;
+--------------------------------------------------+
| Tables_in_pluto_main                             |
+--------------------------------------------------+
...
| Package_Version                                  |
...
mysql> select * from Package_Version limit 1;
ERROR 1146 (42S02): Table 'pluto_main.Package_Version' doesn't exist
mysql> describe Package_Version;
ERROR 1146 (42S02): Table 'pluto_main.Package_Version' doesn't exist
mysql> drop table Package_Version;
ERROR 1051 (42S02): Unknown table 'Package_Version'

Following this advice: http://lists-archives.org/mysql/21070-lock-tables.html I removed Package_Version.frm from the pluto_main database directory:

Code Select Expand


dcerouter_72579:/var/lib/mysql/pluto_main# mv Package_Version.frm ~

Now the dump works:

Code Select Expand


linuxmce@dcerouter:~$ mysqldump -u root --databases pluto_main     >pluto_main.sql
linuxmce@dcerouter:~$ ls -l pluto_main.sql
-rw-r--r-- 1 linuxmce linuxmce 23763604 2008-05-19 20:48 pluto_main.sql


My guess is that Package_Version table was removed for RC1, but the dvd installer did not remove the .frm file.

HTH,
Roy