0
votes
0answers
52 views

MySQL won't start after reboot. Exiting with signal 11

last night I was doing a server maintenance that required DB reboot. No changes in a config were made. Current setup is as follows: master (server1) - master (server2) and slave (server0) MySQL ...
0
votes
1answer
88 views

Configuring MySQL for Power Failure

I have absolutely no experience with databases and MySql. Now the problem is I have an embedded device running a MySQL database with a web based application. The problem is when I shutdown my embedded ...
0
votes
1answer
103 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
0
votes
0answers
70 views

MyISAM table - Inncorrect key file

I have a MySQL 5.1.63 server and two uncorrectable MyISAM table. I tried the following ways to repair it: mysqlcheck -r db.tbl1 ALTER TABLE db.tbl1 ENGINE=InnoDB myisamchk -re /var/lib/mysql/db/tbl1 ...
0
votes
0answers
272 views

No more disk space mysql is marked as crashed and last (automatic?) repair failed

I have a mysql (MyISAM) table which is about 15 Gbs. The total available size after i setup ubuntu 12.04 (using wubi) is 18 Gbs. Now i have the error is marked as crashed and last (automatic?) repair ...
2
votes
2answers
330 views

Mysqld InnoDB crash

my MySQL server just crashed and I cannot restart/recover it. I've tried: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . ...
1
vote
1answer
101 views

MySQL master-master replication between database running on 3 different server

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can't figure out how can I ...
2
votes
1answer
173 views

MySQL crashing when trying to restore from dump

So I had a very large corrupt innodb table. mysqld would crash whenever I did a check table on it. I did a innodb-force-recovery=1 and did a dump of the table. No errors showed up. I dropped the ...
0
votes
2answers
133 views

MySQL: recover 5.0 database from datafiles and insert to 5.1 MySQL server

I have an old server backup with MySQL data files in /var/lib/mysql and I need to access the data inside of one of the databases inside that directory. I unfortunately don't have any SQL-dumps of the ...
1
vote
2answers
2k views

InnoDB recovery

My MySQL server run to crash due to (page file write error). I did a disk diagnosis but no errors found. I restarted MySQL server. It scanned the bin log like for 1-2 hours and recorded log as below: ...
0
votes
2answers
126 views

Splitting up SQL server dump

Is there a way how to split up dump of whole database server (with such tables as 'mysql' or 'information_schema') to single databases? Looking for better way than insert this whole dump and export ...
0
votes
1answer
115 views

Mysql start and backup all tables with SHH Accsess

i have crashed my server.Now is in recovery mode. I have backuped all files but i can't backup mysql tables. From my hosting provider say that i must to start a mysql server and to backup all files. ...
5
votes
1answer
505 views

Recovery strategy for Master-Master replication

I have implemented a HA solution for mysql based on master-master replication. There is a mechanism on the front end part which guarantees that only one db will be read/written to at a given time ...
5
votes
2answers
3k views

Recover a MySQL database with only bin-log file

Here is the CATASTROPHE: We are working in our company with a web application for test management: TestLink. One team was working on it for more than 1 month till now. Yesterday, another team wanted ...
5
votes
1answer
441 views

Mysql disaster recovery

We just got a major disaster: somebody made an uncontrolled update on the production database, and obviously, the backup process is not working since a long time, so we got a major data loss. A 40 ...
1
vote
1answer
764 views

MySQL failed to start after killed a long running “LOAD DATA INFILE” process

I killed a MySQL process which is running a LOAD DATA INFILE command to load a 9GB .csv file into a table in a InnoDB database. Now, when I run mysql DATABASE, it just stopped and showed Reading ...
4
votes
1answer
2k views

MySQL data recovery (innoDB) - missing .frm files but intact ibdata

A recent server fiasco left me with a by-all-appearances intact ibdata file but only half of my .frm-containing directories. I've copied all of this to a fresh mysql install, and have successfully ...
0
votes
1answer
697 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...
1
vote
1answer
359 views

How to recover from failed Mysql schema update, with replication?

I have two MySQL servers configured with master-slave replication. Before we deploy a new application version we: 1) STOP SLAVE 2) Take a MySQL dump of the slave. However, if a mistake is done ...
1
vote
1answer
513 views

What permissions do I need to do a mysqlcheck on all tables?

I'm trying to run mysqlcheck, and I want to run it on all tables, so I'm passing it the -A option. However it's silently skipping all tables that it's doesn't have permission to view. Is there some ...