Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help, can't add index
recreate the table with the index. This procedure will require some downtime of your sql-server. However - this should work. Follow the steps to backup/drop/create and restore your table: 1) Create a backup of your table: bash> mysqldump mydb large_table > large_table.sql 2) Modify the... -
Table keeps being damaged
I'm running mySQL 3.22.27. A table in my DB contains 190,000 entries. The table is accessed aproximately by 1.48 users a second. Every 5 - 15 minutes the table gets damaged, so that isamchk -a table1 returns: - check record links isamchk: error: Wrong bytesec: 0-0-0 at linkstart: 12202079...
