https://techdoku.nogafam.es/ 2026-04-28T15:10:54+00:00 https://techdoku.nogafam.es/ https://techdoku.nogafam.es/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2020-02-27T15:26:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://techdoku.nogafam.es/doku.php?id=docu:csheet:sysadm:db:my:57_date_problem&rev=1582817170&do=diff How to fix 5.7 datetime field problems on dump/restore If you ever step yourself in front of a MySQL 5.7, you better hide your head in the sand, if there is no choice and you have to fix it anyways, issue this command on a mysql cli before restoring/executing SQL commands text/html 2020-02-10T10:28:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://techdoku.nogafam.es/doku.php?id=docu:csheet:sysadm:db:my:create_user&rev=1581330493&do=diff Create a new user in MySQL Cheat sheet: CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; CREATE USER 'newuser'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT USAGE ON *.* TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON db.table TO 'newuser'@'localhost'; text/html 2021-06-17T13:01:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://techdoku.nogafam.es/doku.php?id=docu:csheet:sysadm:db:my:database_migration_help&rev=1623934876&do=diff Helping commands when migrating MySQL databases to different servers If you have a full databases dump in a single file, you can get only the dump for the wanted database, by doing this commands: # search for the create database sentences and track yours (get the line number) grep -inP '^create database' all-databases-dump.sql # imagine, the line number given by the previous command, is 564, then you'will do: tail -n +564 all-databases-dump.sql > yourapp-dump.sql text/html 2021-02-24T21:55:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://techdoku.nogafam.es/doku.php?id=docu:csheet:sysadm:db:my:docker_run_easy&rev=1614203753&do=diff Automatically run a mysql interactive shell to the configured db on docker This simple command will execute an interactive shell on the configured database on a docker container using the environment variables configured on the container. mysql -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE text/html 2020-03-04T10:05:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://techdoku.nogafam.es/doku.php?id=docu:csheet:sysadm:db:my:restore_1table&rev=1583316342&do=diff Restore 1 table from a Database dump You may sometimes need to restore just one table from a database dump in another database, this will do the job pretty well in standard cases. sed -n -e '/CREATE TABLE.*`table_users`/,/CREATE TABLE/p' thedbdumpfile.sql | tr '\n' ' ' 2>&1 | grep -oP '.*UNLOCK TABLES;