[mythtv-users] Database setup

[Michael Nguyen]

Harry Devine wrote:

[snip]
> OK, I'm trying that now, and I can't dump the current database to 
> recreate it.  It gives me the same error about root at localhost not being 
> able to access the database.  If I can remove the DB and start over, I 
> think those instructions you sent above will work fine.
>   
Do you not know your MySQL root password?  You'll need this to do whatever.

1) To dump the database use:  mysqldump -uroot -p mythconverg > 
mythconverg.sql
2) To remove the database use:  mysql -uroot -p -e "drop database 
mythconverg"

You can actually just delete /var/lib/mysql/mythconverg and it'll also 
delete the database, but I'd figure out why you can't access your MySQL 
server first.


Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080322/084e4541/attachment.htm