[mythtv-users] questions about database restore instructions

[Paul Catchpole]

Steve MacLaren wrote:
>
>
>
>     there is a mysql command DROP DATABASE which deletes the database.
>     drop=delete.
>
>     "assuming that you've dropped the database" = assuming that there is
>     no database with the same name (mythconverg) on that mysql server
>     _______________________________________________
>     mythtv-users mailing list
>     mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
>     http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> Ahh, OK.  So it seems I would want to
> 1) install a fresh copy of mythtv
> 2) "drop" or delete the existing mythtconverg database as per 
> http://www.mythtv.org/docs/mythtv-HOWTO.html#toc23.6
> 3) restore the database with my backup copy per 
> http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 
> <http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5>
>
> Thanks!
>
> -- 
> ________________________
> "The Linux of transportation."
> http://www.vehicledesignsummit.org/website/
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   
If you're running a new install of mysql on the second hard drive and 
plan it to be a replacement backend [rather than a slave] then you won't 
have an existing database to drop - hence you can forget about the 
'drop' and import the dump, creating the database in the process. You 
may or may not need to at least create the mythconverg database before 
the import...

PC