[morphjk]

HI everyone. I managed to stuff up my XBMC database when I was setting it up (due to the way I imported) and now as result it isn't working. So I ended up not using it but it is frustrating me that I don't have everything synced. So I would like to drop the database and re-setup mysql.

The issue I have is that I also have mythtv running in mysql so I need to make sure I don't do anything to that. So I am unsure how I go about it and would appreciate advice.

[nickr]

if you can use the commandline OK just do similar to this

Code:

mysql -u xbmc -h media -p
drop database MyVideos75
drop database MyMusic32
(ctrl-d to exit)

If you are on gotham, your databases might be a different name (eg the 75 and 32 will be bigger numbers. To see all the databases you can run the mysql command

Code:

show databases

EDIT: sorry should have been clearer on that first line

mysql - that's the commandline mysql client
-u xbmc thats the username you set up to access xbmc
-h media - thats the hostname where the database is located
-p - tell mysql to prompt for a password.

[morphjk]

if you can use the commandline OK just do similar to this

Code:

mysql -u xbmc -h media -p
drop database MyVideos75
drop database MyMusic32
(ctrl-d to exit)

When I did:

Code:

[media@garage ~]$ mysql -u xbmc -h -p

I got

Code:

ERROR 2005 (HY000): Unknown MySQL server host '-p' (0)

Doing:

Code:

[media@garage ~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10092
Server version: 5.5.34-MariaDB-log MariaDB Server

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Gets me in.

I haven't run the other commands but doing:

Code:

MariaDB [(none)]> show databases

Didn't return any thing at all.

But I am running Frodo.

When I set it up I ran:

Code:

mysql -u root -p
GRANT ALL ON *.* TO 'xbmc'@'localhost' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';

So at this point I haven't done anything

EDIT:
I just ran:

Code:

SHOW DATABASES;

Which gave me:

Code:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mythconverg        |
| performance_schema |
+--------------------+
4 rows in set (0.05 sec)

[nickr]

So it looks like you don't have any xbmc databases to delete.