|
|
Line 1: |
Line 1: |
− | This is the Database system used with MythTV. MySQL is a very versatile database system, used with many projects and web sites. For more info on MySQL itself, see [http://www.mysql.com]. For info on the MySQL database used with Myth, read on.
| + | #redirect [[:Category:MYSQL]] |
− | | |
− | == Database Schema ==
| |
− | | |
− | If you run into trouble with some of your MythTV tables or are looking for information on how the system is stored, browse the [[Database Schema]] for more information.
| |
− | | |
− | == Questions and Answers ==
| |
− | | |
− | Q: My database seems b0rked<br>
| |
− | A: Try these magic incantations, it will try to fix broken databases:
| |
− | <pre><nowiki>
| |
− | mysqlcheck -r -u mythtv -pmythtv mythconverg
| |
− | </nowiki></pre>
| |
− | If you only want to check which part of the data base that is broken, run mysqlcheck without the -r.
| |
− | | |
− | Q: When running mysqlcheck I get the error message "Access denied for user ..." <br>
| |
− | A: The problem may be that you are using the wrong password. The following commands will change the mysql password to "mythtv":
| |
− | <pre><nowiki>
| |
− | # mysql -u root mysql
| |
− | mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
| |
− | mysql> FLUSH PRIVILEGES;
| |
− | mysql> quit
| |
− | </nowiki></pre>
| |
− | Note that you will have to change the database password in the mythtv setup to "mythtv" once you get it running again.
| |
− | | |
− | Q: I'm getting a SQL error from mythbackend when upgrading. What does that mean?<br>
| |
− | A: Try using perror to get more information
| |
− | <pre><nowiki>
| |
− | 2004-05-25 22:56:24 Upgrading to schema version 1046
| |
− | 2004-05-25 22:56:24 Upgrading to schema version 1047
| |
− | DB Error (Performing database upgrade):
| |
− | Query was:
| |
− | ALTER TABLE record ADD COLUMN search INT UNSIGNED NOT NULL DEFAULT 0;
| |
− | Driver error was [2/-1]:
| |
− | QMYSQL3: Unable to execute query
| |
− | Database error was:
| |
− | Error writing file './mythconverg/#sql-785_2.frm' (Errcode: 28)
| |
− | | |
− | For future reference you can use perror with the mysql error number:
| |
− | $ perror 28
| |
− | Error code 28: No space left on device
| |
− | </nowiki></pre>
| |
− | | |
− | [[Category:Glossary]]
| |