0
votes
1answer
56 views

MySQL MyISAM corrupt table, how to restore?

I have a MySQL MyISAM table that's corrupt. It first showed up in my mysql log as: [ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed and last (automatic?) repair failed I then ...
0
votes
1answer
280 views

MySQL Corrupt Table - No Space left - Index File too big

I noticed that one of my servers was running out of disk space, due to heavy MySQL usage. I stopped everything using the database, freed up some space and restarted mysqld. Now, I checked my table ...
0
votes
2answers
221 views

MySQL: Increased buffer pool, ibdata1 corrupt?

I tried increasing innodb_buffer_pool_size via my.cnf from default 128m to 256m, but on restart attempt, mysql shutdown failed with: 130125 11:49:55 InnoDB: Initializing buffer pool, size = 256.0M ...
0
votes
2answers
308 views

MySQL Tweaking for performance

[mysqld] myisam_repair_threads=4 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M table_cache = 1024 ...
1
vote
0answers
252 views

Corrupt mysql system tables

I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently. I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but ...
2
votes
1answer
211 views

Which is more durable? MyISAM or InnoDB with innodb_flush_log_at_trx_commit=0 [closed]

I am trying to determine the difference in durability between MySQL's MyISAM and InnoDB when innodb_flush_log_at_trx_commit=0. I am aware of the some of the benefits of InnoDB with ACID. However, ...
2
votes
1answer
1k views

mysql.proc has gone corrupt. How can I fix it?

I have a server running Debian 5.0, and MySQL. Suddendly, MySQL stopped working, and after many attempts to fix it, I decided to reinstall it. I installed MySQL 5.1.63, and when started it goes to ...
2
votes
2answers
802 views

MySql crash: Incorrect key file for table

We have a MySql 5.5 database running InnoDB on Linux. One table (named table_search) is running MyISAM to be able to perform full text searches. The table has 823 368 rows. Yesterday we had a server ...
0
votes
1answer
117 views

MySQL table keeps corrupting, need a simple fail over solution?

One of my clients servers recently crashed at the planet, we got an automatic email from them that they had to do a hard reboot. Since then mysqld stops running occasionally and then shopping cart ...
2
votes
1answer
284 views

Will repairing a MySQL table run the risk of data loss?

I recently had a table in my MySQL DB go haywire (part of my Invision Power Board install) which has never happened to me before. If I use the "Repair" tool in phpMyAdmin, will I run the risk of data ...
0
votes
1answer
238 views

MySQL: Corrupt ARCHIVE table. Help, Please?

I'm a programmer and a total newbie as a sysadmin... Today I started receiving error emails from our production site: Incorrect key file for table 'xxx'; try to repair it I found the server with 2 ...
1
vote
2answers
474 views

Copying /var/lib/mysql files over resulted in InnoDB corruption

My server had to be re-installed yesterday so they replaced the hard drive and hooked the old one up via USB. I grabbed the database files (/var/lib/mysql) and downloaded them and then I erased all ...
1
vote
1answer
312 views

MySQL InnoDB random data corruptions: hardware or software errors?

I'm an administrator of a social game which uses MySQL(Percona 5.1.56 to be precise) for data storage(all tables have InnoDB type). There are about 2 millions of players in the game and database size ...
0
votes
1answer
1k views

Mysqld not starting due to apparent db corruption

I am very new at admining mysql, and bad for me, something caused the db to get clobbered. There are many error messages in the log that I am not sure how to safely proceed. Can you give some tips? ...
4
votes
2answers
133 views

What are the warning signs that a MySQL table might be corrupted

For some reason, it's not the first thing I think of when diagnosing very strange table errors. I had an issue when doing an order by I'd wind up with only one record. Explain said I should have 28 ...
0
votes
1answer
89 views

MySQL on a laptop for remote workers - MyISAM keeps corrupting

We have an application that is used by remote, mobile workers. It intalls WAMP (Server2Go) on a laptop and uses MySQL to store data locally. All tables are MyISAM. Once a day, the workers sync the ...
0
votes
2answers
3k views

MySQL Tables Missing/Corrupt After Recreation

Yesterday I dumped my MySQL databases to an SQL file and renamed the ibdata1 file. I then recreated it and imported the SQL file and moved the new ibdata1 file to my MySQL data directory, deleting the ...
2
votes
1answer
386 views

MySQL: Auto-increment value: 0 is smaller than max used value: xx

Increasingly I'm getting tables having to be repaired dwith the message returned of: Auto-increment value: 0 is smaller than max used value: xx This has happened on tables with 200 rows and tables ...
2
votes
2answers
2k views

Diagnosing cause of orphaned inodes on Linux, busy MySQL?

One of our servers recently experienced some file system corruption and our root file system was automatically remounted as read only. The steps I took to recover were: attempted to remount > ...
0
votes
3answers
83 views

My previous team member “replicated” a database on a server onto another server. But now it's not in sync anymore

Database 1 is a regular database server. He replicated it to Database 2...a direct clone. Master-Master. They are in "sync" all the time. They each have 40 million rows. Today, Database 2 is ...
12
votes
7answers
4k views

How can I force a MySQL table to become corrupted?

I have written a simple Nagios plugin that calls mysqlcheck (which checks for corrupted tables) and will give a warning if any are corrupt. However none of my tables are corrupt now. So I'm not 100% ...
0
votes
2answers
350 views

MySQL dump-restore replaces characters with 3Fh

FreeBSD Server with Mysql and make.conf like that .if ${.CURDIR} == ${PORTSDIR}/databases/mysql50-server WITH_CHARSET=cp1251 WITH_COLLATION=cp1251_bin BUILD_OPTIMIZED=yes BUILD_STATIC=yes .endif .if ...
3
votes
6answers
12k views

Should I stop MySQL repair?

MySQL database (20 Gigabytes of tables and index) went corrupt. I launched the repair option using MySQL-admin graphic interface, now it has been running for 24 hours. When I have check the MyISAM ...