[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade

[Greg]

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
> auto-builds.
>
> 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.
>
> R
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
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