Tagged Questions
0
votes
1answer
28 views
Optimize command issuing “'View is not base table” and “Corrupt” error messages
I have no experience with MySQL. My boss ran an optimize against a MySQL database. Against a bunch of views we got the message
"tablexyz" is not BASE TABLE
and the next has message is
...
0
votes
0answers
113 views
MySQL loses connection
I think we've got a corrupt table in this situation. A website with a Drupal setup we host shows the following error:
General error: 2006 MySQL server has gone away: SELECT expire, value FROM ...
0
votes
1answer
85 views
View dropped, now shows as table “in use”, can't drop
I have a view on a MySQL/MyISAM setup, then the underlying table had a column dropped, and made that view invalid.
I tried dropping the view so I could recreate it, then MySQL said it was a table ...
1
vote
1answer
109 views
What would cause Mysql database entries to be truncated to 253 characters?
Randomly seeing database entries truncated to 253 characters on a php site and can't figure out why or if it could be malicious or a corruption issue. Any thoughts would be appreciated.
0
votes
1answer
266 views
MySQL: Can't find record in tablename
After crash:
mysql> repair table lot_not_sold;
+------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | ...
5
votes
1answer
716 views
MySQL INNODB corruption after server crash during concurrent truncate command
My server crashed today I think due to a concurrent truncate table command on one of our INNODB tables. The server could be restarted, but after it starts up, everytime I try to issue an SQL command, ...
2
votes
1answer
319 views
MySQL 5.5 : (InnoDB) - Manually edited an .ibd file to test recovery, now entire MySQL installation is broken!
So I wanted to test MySQL recovery from Innodb corruption.
file-per-table is enabled.
I have a few test db's on the MySQL instance.
I shutdown mysql. Manually edited/added random characters to an ...
2
votes
1answer
417 views
InnoDB “corruption”
I use:
5.1.63-0ubuntu0.11.10.1
Apache/2.2.20 (Ubuntu)
MySQL client version: 5.1.63
The system is continuously displaying the following error during reading data from a MySQL database:
...
2
votes
1answer
1k views
innodb_force_recovery when InnoDB corruption
When I start mysqld (in /etc/init.d), it failed with
InnoDB: corruption in the InnoDB tablespace.
What's the best innodb_force_recovery value to force mysqld to start? I have tried 4 and 6, but ...
2
votes
1answer
101 views
MySQL REPLACE appears to corrupt data
For reference, this issue was posted on StackOverflow.com before coming here.
In MySQL I am running multiple REPLACE queries to update hardcoded URLs in a database. Queries look like this:
UPDATE ...
2
votes
2answers
975 views
mysql 5.5 corrupt - missing temporary table
One of our mysql instances crashed and failed to start:
120422 10:04:13 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './databasename/#sql-29f6_45.ibd'!
...
2
votes
2answers
426 views
MySQL corruption even after full dump and re-import
We have a production issue where MySQL has started spitting InnoDB corrupt page errors and falling over.
The error message seem to relate to indexes so I assume the data itself is ok and when I ...
0
votes
1answer
242 views
How to avoid table crash?
Couple of days back I had a table with 7GB of data and it was showing 63MB of overhead in phpMyAdmin and I mistakenly started its optimization and after working of more than 40 mins it corrupted the ...
