Difference between revisions of "MySql"

From MythTV Official Wiki
Jump to: navigation, search
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]]
 

Revision as of 19:14, 23 December 2006

Redirect to: