Author Topic: pluto_main.Package_Version preventing dump  (Read 746 times)

royw

  • Guru
  • ****
  • Posts: 261
    • View Profile
pluto_main.Package_Version preventing dump
« on: May 20, 2008, 06:03:56 am »
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]
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]
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]
dcerouter_72579:/var/lib/mysql/pluto_main# mv Package_Version.frm ~
Now the dump works:
Code: [Select]
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