|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 11:00 PM
| #1 | ||
 |
hello when i make check tables attachments, i get the information rt3.Attachments | check | error | Table upgrade required. Please do "REPAIR TABLE `Attachments`" to fix it! | when i do this, or mysqlcheck --check-upgrade --all-databases --auto-repair all is fine, he says tables repair but the table is still (after a new check) not "Upgrade" all other tables are. Cause of this , i cant dump the database, (he crash, with this failure) any ideas (?) it is a InnoDB Format. friendly regards | ||
      |
|
07-01-2007, 11:00 PM
| #2 | ||
| |
i forgot to wrote what happens after repair mysql> REPAIR TABLE Attachments; +-----------------+--------+----------+-----------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------+--------+----------+-----------------------------+ | rt3.Attachments | repair | status | Table is already up to date | +-----------------+--------+----------+-----------------------------+ 1 row in set, 1 warning (6 min 30.36 sec) | ||
| |
| Featured Websites | ||||
|
|
| Tags: check, mysql, questions, tablemysql, upgrade |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| mysql commercial licence upgrade | Adam Lipscombe | Database | 0 | 07-01-2007 9:34 PM |
| ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) | Cteodor | Database | 0 | 07-01-2007 6:43 PM |
| php & mysql table design | Rocket Rob | PHP | 17 | 07-01-2007 5:03 PM |
| Questions on MySQL 5.0.x stored procs and UDFs | robocop | Database | 0 | 06-10-2007 12:19 AM |
| MySQL Interview Questions | techguru | Database | 1 | 05-31-2007 8:43 PM |
| Featured Websites | ||||
|
mysql upgrade table/mysql check questions 
PacMan
Linear Mode
