zeldor.biz

Linux, programming and more

Copyright © 2025
Log in

Migrate MySQL users

December 24, 2020 by Igor Drobot Leave a Comment

Following line will query all mysql user with their grants and print the creation statements for them.

By copy pasting or by filling a SQL-file, you can easily migrate all MySQL-user to a new mysql or mariaDB instance.

mysql -u root -p"YOUR_PW" -Ne "select distinct concat( \"SHOW GRANTS FOR '\",user,\"'@'\",host,\"';\" ) from mysql.user;" mysql | \
mysql -u root -p"YOUR_PW"| \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'

Filed Under: Linux Tagged With: MariaDB, Migrate MySQL User, MySQL, SQL

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

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