<br><br>On Saturday, October 8, 2011, Michael T. Dean <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br>> On 10/07/2011 02:33 PM, Mark Boyum wrote:<br>>> I would like to backup my database but find that the script dies as<br>
>> below. I know next to nothing about mySQL and would appreciate any<br>>> assistance.<br>>><br>>> How do I remove any trace of mythweatther as we no longer use it? I'd<br>>> like to clean it out of the database entirely and assume that would<br>
>> allow the backup script to run.<br>>><br>>><br>>> ./<a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a> --verbose<br>>> <--- SNIP ---><br>>> Executing command:<br>
>> '/usr/bin/mysqldump' --defaults-extra-file='/tmp/b1lBxr5u54'<br>>> --host='localhost' --user='mythtv' --add-drop-table --add-locks<br>>> --allow-keywords --complete-insert --extended-insert --lock-tables<br>
>> --no-create-db --quick --add-drop-table 'mythconverg' 2>&1<br>>> 1>'/home/mark/mythtv_backup/mythconverg-1264-20111007131620.sql'<br>>><br>>> mysqldump exited with status: 2<br>
>> mysqldump output:<br>>> mysqldump: Got error: 1146: Table<br>>> 'mythconverg.mythconverg.weatherscreens' doesn't exist when using LOCK<br>>> TABLES<br>><br>> SHOW ENGINES;<br>><br>
> I'm guessing you won't see a "YES" in the "Support" column for<br>> "InnoDB". That means that your distro disabled the InnoDB storage<br>> engine--because it saves 40MB of virtual RAM--to make a lean-mean<br>
> machine for you and broke your MythTV database in the process. If so:<br>><br>> <a href="http://www.gossamer-threads.com/lists/mythtv/users/419174#419174">http://www.gossamer-threads.com/lists/mythtv/users/419174#419174</a><br>
><br>> (And be very careful with the copy/paste of the command to the shell.<br>> It must end with "EOF" as the entire last line--with no added<br>> end-of-line spaces, which copy/paste is likely to put in. So, I<br>
> recommend you copy everything except the "EOF" line, then paste it into<br>> a shell, then make sure you're on a different line from the "DELETE"<br>> line and type in "EOF<Enter>".)<br>
><br>> Then, enable InnoDB on your mysql server, then restart mythfrontend and<br>> it will re-create the MythWeather tables (and backup will work because<br>> you won't have broken tables).<br>><br>> Mike<br>
><br><br>Thanks, <br>I'll look into Sunday night after the weekend activities are all settled.