rename PC with TV-Server? (2 Viewers)

[hkjensen]

mysql --user=[username] --password=[password [Database]

ex:
mysql --user=root --password=123445 MpDb

If already login user following command to change database
use MpDb;

Commit changes with
commit;

 

[greybox]

Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.1.35-community MySQL Community Server (GPL)

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

mysql> use MpDb;
ERROR 1049 (42000): Unknown database 'mpdb'
mysql>

What am I doing wrong?

 

[hkjensen]

Try with database MpTvDb witch is the default databasename

 

[greybox]

The commands work now, thank you! But this raises a quesion: where the database files are? I did a search and found the following location:

c:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\mptvdb\

So it is not in C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\database anymore? This is what is included in automatic backups.

How do we backup the database if we have to?

 

[hkjensen]

If you want to backup the MySQL database there are at least 2 solutions
1. Copy the mptvdb folder to a safe place, to restore copy it back
2. Use MySQL Administrator and setup a backup project (Check MySQL homepage)