MySQL

InnoDB recovery

August 12, 2017 by Igor Drobot Leave a Comment

In some cases databases gets corrupted(shit happens). After a hardware fail or not correct usage like a “kill -9” of mysqld process without gracefully flushing of opened tables.

After the start of mysqld.service, you can get a log-entry in your mysqld-log file, which informs you about the corruption of database, like this one “corruption in the InnoDB tablespace“.
In some cases mysqld.service will crash every n-minutes..

Independently of the symptoms the crashed database should be repaired immediately!
[Read more…]

MySQL Dump

October 11, 2011 by Igor Drobot Leave a Comment

Collection of some MySQL commands, very useful to create and restore MySQL-Backups. [Read more…]

MySQL: Error 1016 when using LOCK TABLES

August 8, 2011 by Igor Drobot 1 Comment

I run a nightly mysqldump of all my databases and one of them has over 500 tables, mysqldumper bring me a error while processing this huge database: [Read more…]

Access denied for user ‘debian-sys-maint’

March 29, 2011 by Igor Drobot Leave a Comment

While trying to start or stop MySQL I get:

1	Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

Dabian has a own way to login to the MySQL database the credantials are listed in a file:

cat /etc/mysql/debian.cnf
[...]
user = debian-sys-maint
password = bodCNLUx0GGYm6F

Logon:

1	mysql -u root -p

Execute:

1	GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'bodCNLUx0GGYm6F' WITH GRANT OPTION;

By the way set a new root passwort:

1	mysqladmin -u root password 'new-password'

MySQL Error Codes

February 5, 2011 by Igor Drobot 1 Comment

Sometimes you need a good reference, and this is one of those times. MySQL’s perror command returns many error codes, and I’ve provided a listing here. To find errors individually, just run:

1 2	# perror 28 OS error code 28: No space left on device

[Read more…]