[mythtv-users] converting a .20.2 database to .21

[scram69]

On Wed, May 7, 2008 at 1:17 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:

>  > and do:
>  >     $ mysql -u root
>  >     mysql>create database mythconverg;
>  >     mysql>exit
>  >     $ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql
>  > Then, I would run mythtv-setup.
>  > If I do this, is the mc.sql step still necessary?
>
>  Your use of "CREATE DATABASE mythconverg;" would /only/ work on a MySQL
>  installation where an appropriate user has been created.  Also, it's
>  likely to cause character set issues (though, now, Myth's database
>  upgrade code does it's best to prevent the issues even on an
>  improperly-configured database).
>
>  The mc.sql script does more than just create the mythconverg database.
>  It a) creates the DB, b) creates a user mythtv, c) grants appropriate
>  permissions to the mythtv user, and d) sets the database character set.
>  As long as you do all these things (where the user/grants part will
>  "stick" even after a "DROP DATABASE", so they need only be done when
>  first setting up MythTV on the MySQL server), everything is good.
>  However, it /never/ hurts to run the commands in mc.sql (even if the
>  database already exists).***
>
OK, that makes sense now.  Thanks for spelling it out for me!