Difference between revisions of "MySql"

From MythTV Official Wiki
Jump to: navigation, search
(Cleanup)
m (Database Schema)
Line 3: Line 3:
 
== Database Schema ==
 
== 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|Database Schema]] for more information.<br>
+
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.
'''Note:''' This is being replaced slowly in the User Manual page for the [[User Manual/Technical Details Appendix/Database Schemata|Database Schema]].
 
  
 
== Questions and Answers ==
 
== Questions and Answers ==

Revision as of 18:27, 28 February 2006

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 [1]. For info on the MySQL database used with Myth, read on.

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
A: Try these magic incantations, it will try to fix broken databases:

mysqlcheck -r -u mythtv -pmythtv mythconverg

Q: I'm getting a SQL error from mythbackend when upgrading. What does that mean?
A: Try using perror to get more information

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