zeldor.biz

Linux, programming and more

Copyright © 2019 · Wintersong Pro Theme on Genesis Framework · WordPress · Log in

Nextcloud meets MariaDB

August 8, 2018 by Igor Drobot Leave a Comment

nextcloud

SQLite is good for testing and simple single-user Nextcloud instance,
but it does not scale for multiple-user production cases. For the first Installation its quiet simple and reliable.

After some years of usage my SQLite-database reached a size of 130MB and the performance was not more the same as after the first days.

You can convert a SQLite database to a more performing MariaDB database with the Nextcloud command line tool:
[Read more…]

Filed Under: Networking Tagged With: MariaDB, MySQL, Nextcloud, sqlite

InnoDB recovery

August 12, 2017 by Igor Drobot Leave a Comment

InnoDB recovery

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…]

Filed Under: Linux Tagged With: InnoDB, InnoDB recovery, MariaDB, MySQL

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…]

Filed Under: Debian, Linux, MySQL Tagged With: MySQL, MySQL Backup, MYSQL Dump, mysqldump, mysqldumper

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…]

Filed Under: Linux, MySQL Tagged With: MySQL, mysqldump, single-transaction, skip-lock-tables

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)

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:

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

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

Logon:

1
mysql -u root -p

mysql -u root -p

Execute:

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

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'

mysqladmin -u root password 'new-password'

Filed Under: Debian, Linux, MySQL Tagged With: Access denied, debian-sys-maint, MySQL

  • 1
  • 2
  • Next Page »
Yeaaah Cookie! We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok