Linux, programming and more
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…]
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…]
Collection of some MySQL commands, very useful to create and restore MySQL-Backups. [Read more…]
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…]
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:
1 2 3 4 | 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' |