[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade
greg12866 at nycap.rr.com
Fri Dec 31 15:44:14 UTC 2010
On 12/31/2010 06:47 AM, Richard Morton wrote:
> I used this method to restore the database.
> mythconverg_restore.pl --drop_database --create_database
> I selected a specific directory and file as well.
> the mythconverg_restore was supplied with 0.24-fixes from mythbuntu
> I have a party tonight so need a working system. I have therefore
> installed 0.23.1-fixes which is a shame; I still need to fix this, so
> please keep sending things to try.
> mythtv-users mailing list
> mythtv-users at mythtv.org
These are the commands I use and it has never failed me. Thanks to Mike
Dean and his script..
mysql -uroot -p -e 'DROP DATABASE IF EXISTS mythconverg;'
mysql -uroot -p < /home/greg/mythtv/database/mc.sql (adjust paths to
suit your install)
mythconverg_restore.pl --directory (my backups are stored here, you
would need to adjust your paths) /mnt/video3/db_backups --filename
(your most current back up) .sql.gz
More information about the mythtv-users