https://tech.snathan.org/ 2026-05-01T08:14:25+00:00 https://tech.snathan.org/ https://tech.snathan.org/_media/wiki/dokuwiki.svg text/html 2014-11-15T15:13:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/mysql/check_all_database_sizes?rev=1416064422&do=diff Check the size of all MySQL databases The script below will get the sizes of all databases for a MySQL server. Make sure you “use” a database before you run the script. CREATE TABLE z_db_size SELECT TABLE_SCHEMA AS 'database_name', TABLE_NAME AS 'table_name', ((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024) AS size_in_mb FROM INFORMATION_SCHEMA.TABLES; text/html 2014-12-04T12:45:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/mysql/check?rev=1417697137&do=diff MySQL Check Cron this! #!/bin/sh # # MySQL Check # NOW=$(date +"%Y-%m-%d-%H-%M-%S") # MYSQLPASS="yourootpassword" # #MySQL Check /usr/bin/mysqlcheck -ACes -uroot --password=${MYSQLPASS} # exit 0 * Include option o to optimize the tables as well text/html 2014-11-19T12:37:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/mysql/creating_mysql_users_for_a_database?rev=1416400656&do=diff Creating MySQL Database & Users for the database Chosen names are as follows: Database p08_xxyyzz User up08xxyyzz Password 4PJmbVu6SdeySyW Database Creation DROP DATABASE p08_xxyyzz; CREATE DATABASE p08_xxyyzz; User Creation With Access from localhost text/html 2022-03-01T12:28:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/mysql/mysql_fresh_start?rev=1646137727&do=diff How to reset MySQL back to install point I corrupted my MySQL database by doing a simple mistake. Took the sqldump from another database and loaded it without realizing that the dump had the mysql database of the source database. That seemed to have caused major issues for obvious reasons. After that it was going back to restoring the MySQL database. But wait, I did not have a backup of my target database since it was brand new and I had nothing to save. Now I have corrupted the default mysql … text/html 2014-11-15T15:13:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/mysql/mysql_to_oracle_migration?rev=1416064422&do=diff Using HSODBC How to Setup HSODBC (Oracle9i on Solaris) to MySQL on Linux MySQL Migration Toolkit MySQL MySQL Migration Toolkit 12.3 The Modular Migration Process