script/mysql
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity

Commit Graph

  • 7b97a5d6ff create_database.sh: a really small changes on scipt output. master chris 2025-03-11 10:51:09 +01:00
  • 014cf46b74 Merge branch 'master' of https://git.oopen.de/script/mysql Christoph 2025-01-17 02:23:43 +01:00
  • e5ba1decfb dump_database.sh: fix error dumpimg remote database statement. Christoph 2025-01-17 02:23:23 +01:00
  • b890525173 dump_database.sh: fix error getting commandline valiues for mysql credentials. Christoph 2025-01-16 17:58:43 +01:00
  • 2ae83440cb README.create-user: some changes.. Christoph 2024-03-30 11:43:41 +01:00
  • 35f224d9f2 Add file 'README.create-user'. Christoph 2024-03-30 11:34:09 +01:00
  • 845e9cf8ad Fix errors in case of multiple mysql installations. Christoph 2024-01-17 01:40:49 +01:00
  • 62c2f65dbd Delete file 'databases-web0-alt.lst'. Christoph 2023-12-10 12:14:40 +01:00
  • 8efe89e79a Add not very well tested script 'dump_database.sh'. chris 2023-11-07 18:48:53 +01:00
  • be0404d9d6 restore_database.sh: while restoring the database set value 'max_allowed_packet' to '1G'. chris 2023-11-07 17:53:02 +01:00
  • d0d7c01ba3 Merge branch 'master' of https://git.oopen.de/script/mysql Christoph 2023-08-13 16:28:52 +02:00
  • a585a90b56 create_database.sh: add default database user. Christoph 2023-08-13 16:28:32 +02:00
  • 5bdb646de7 optimize_mysql_tables.sh, optimize_mysql_tables-ND.sh: some design changes.. Christoph 2023-08-09 11:09:11 +02:00
  • 30ca2c1a72 flush_host_cache.sh, flush_query_cache.sh: support parallel installations. Christoph 2023-08-09 09:15:49 +02:00
  • 8876617d4c create_database.sh: some minbor changes in script output. Christoph 2023-08-09 09:10:35 +02:00
  • cd815ee66f Add support vor unix socket located at /run/mysqld folder. Christoph 2023-08-02 16:06:15 +02:00
  • 270def192f Add script'mysqltuner.pl'. Christoph 2023-05-04 14:38:09 +02:00
  • a7f3c27011 Merge branch 'master' of https://git.oopen.de/script/mysql christoph 2023-05-04 13:28:18 +02:00
  • e0eb52d8d3 max_memory_limit_mysql.sh: add 'max_allowed_packet' which is also relevant for maximum memory usage. christoph 2023-05-04 13:27:54 +02:00
  • 11b1077ae0 Add support vor MariaDB. Christoph 2023-05-03 17:47:03 +02:00
  • eee88f670b max_memory_limit_mysql.sh: add support for MariaDB root 2023-04-07 02:11:01 +02:00
  • 1de383a138 Add scripts: 'grant_backup_privileges_to_user.sh' and 'grant_full_access_to_user.sh'. Christoph 2023-02-13 15:43:56 +01:00
  • 33c66606e9 Change comment.. Christoph 2023-02-13 15:43:12 +01:00
  • 51eca01227 create_database.sh: a minor change in script output. Christoph 2022-10-26 18:17:24 +02:00
  • 114deb22c7 Merge branch 'master' of https://git.oopen.de/script/mysql Christoph 2022-07-05 18:47:31 +02:00
  • 84bfe98c60 Add script restore_database.sh. Christoph 2022-07-05 18:46:56 +02:00
  • ca220a21fb create_database.sh: add (new) sovjket location '/run/mysqld/'. Christoph 2022-07-05 18:46:40 +02:00
  • 21dda2c815 create_database.sh: directory '/var/run' chnaged to '/run'. Christoph 2022-07-04 21:15:00 +02:00
  • c21a135b39 create_database.sh: support different charset and collate settings for database creation. Christoph 2022-06-07 01:20:06 +02:00
  • aef387faad repair_mysql_tables.sh: fix missing initial value for 'MYSQL_CREDENTIALS_GIVEN'. Christoph 2020-10-23 02:29:02 +02:00
  • 340b8fae1b Add example entries for possible ip-address/-network settings to 'Host' variable. Christoph 2020-09-01 16:01:09 +02:00
  • 3155c29c2f Add script 'drop_database_user.sh'. Christoph 2020-09-01 15:36:03 +02:00
  • 58a261d241 drop_database.sh: change some script output. Christoph 2020-09-01 14:46:24 +02:00
  • 09bda7f950 Get rid of unused commented code lines. Christoph 2020-09-01 14:38:28 +02:00
  • 2d761934d4 Fixed some errors on multiple MySQL installations. Christoph 2020-09-01 14:36:00 +02:00
  • 792579070c optimize_mysql_tables-ND.sh, flush_host_cache.sh, lush_query_cache.sh: check also socket path '/run/mysqld/mysqld.sock'. Christoph 2020-08-21 10:23:54 +02:00
  • 57ede258ab optimize_mysql_tables.sh: check also socket path '/run/mysqld/mysqld.sock'. Christoph 2020-08-21 10:20:20 +02:00
  • 21b284bf65 Add script 'grant_dbaccess_to_user.sh'. Christoph 2020-06-23 14:01:59 +02:00
  • 6849cf5c72 create_database.sh: support full UTF-8 support (utf8mb4). Chritoph 2020-05-26 00:04:01 +02:00
  • 65038c3b9a Update code to determin current database installation. Christoph 2020-05-25 23:19:15 +02:00
  • 9ddc792d23 second run: determin 'MYSQL_CREDENTIAL_ARGS' if not given. Christoph 2020-05-12 21:06:18 +02:00
  • ea8fc078c2 Try to determin 'MYSQL_CREDENTIAL_ARGS' if not given. Christoph 2020-05-12 19:25:56 +02:00
  • c8a177e2c2 repair_mysql_tables.sh: support multiple MySQL instances. Christoph 2019-11-06 00:38:54 +01:00
  • ffd923f3e4 Merge branch 'master' of https://git.oopen.de/script/mysql Christoph 2019-11-05 18:02:46 +01:00
  • e393a5df46 flush_host_cache.sh,flush_query_cache.sh: change default mysql credentials. Christoph 2019-11-05 18:02:31 +01:00
  • 14077cbac1 drop_tables.sh: support multiple mysql server instances. Christoph 2019-11-05 17:38:17 +01:00
  • 5d68e7494f Fix some errors for drop/create scripts in case og multiple mysql instances. Christoph 2019-11-05 17:17:04 +01:00
  • aa98cc0fbc Only one configuration file for all database creation/drop scripts. Christoph 2019-11-05 15:14:58 +01:00
  • 7894f27be1 Some changes in sample configuration files. Christoph 2019-11-02 13:06:49 +01:00
  • 8666b07ed5 optimize_mysql_tables.sh: main loop failed if mysql_credential_args contains a blank sign as i.e '-u root -S /tmp/mysql.sock'. Christoph 2019-11-02 12:35:59 +01:00
  • 789988b940 optimize_mysql_tables.sh: fix error if no mysql credentials givven in configuration file. Christoph 2019-11-02 11:07:57 +01:00
  • 52b57aafea create_database.sh: support mariadb 10.4 Christoph 2019-11-02 02:37:34 +01:00
  • b18c6a1a0e Add documentation to sample configuration files. root 2019-08-21 20:30:03 +02:00
  • 77f29da0ac repair_mysql_tables.sh: fix errors for support of multiple installations. Christoph 2019-01-31 04:03:35 +01:00
  • 170cb05242 optimize_mysql_tables.sh: fix errors for support of multiple installations. Christoph 2019-01-31 03:44:24 +01:00
  • b61cc133f0 create_database.sh: add support of multiple MySQL installations. Christoph 2019-01-30 14:58:24 +01:00
  • cd625ae265 optimize_mysql_tables.conf.sample: correct typo. Christoph 2019-01-15 14:50:50 +00:00
  • eb335c9a95 create_database.sh, max_memory_limit_mysql.sh: use configuration file 'mysql_credetials.conf'. Christoph 2018-12-10 16:32:47 +01:00
  • 5221328f91 create_database.sh: add support for MariaDB Christoph 2018-12-10 04:24:16 +01:00
  • 19c2e2f5bc max_memory_limit_mysql.sh: add support for configuration file (mysql_credetials.conf). Christoph 2018-12-10 04:23:46 +01:00
  • 8a825e2286 Merge branch 'master' of https://git.oopen.de/script/mysql chris 2018-12-05 18:27:14 +01:00
  • a494755a15 flush_query_cache.sh: fix error if mysql distribution is not MySQL (i.e. Percona/MariaDB). chris 2018-12-05 18:26:40 +01:00
  • a397141904 create_database.sh: supports creatuing user with access from outside. Christoph 2018-12-05 15:37:02 +01:00
  • 435fbfdf19 flush_query_cache.sh: query cache is no longer supported since version '8.0.3'. Christoph 2018-12-03 14:01:16 +01:00
  • 3baebe1300 create_database.sh: remove giving Super_priv to created user.. Christoph 2018-09-10 15:52:26 +02:00
  • 7ea7de9990 optimize_mysql_tables.sh,optimize_mysql_tables-ND.sh: fix error in writing the logfile. Christoph 2018-08-31 11:44:50 +02:00
  • 9525f9c624 optimize_mysql_tables.sh: minor changes. Christoph 2018-08-31 03:28:07 +02:00
  • 0fc3ec06be Optimize/Repair table scripts: ommit tables with table engine InnoDB. Christoph 2018-08-31 03:24:42 +02:00
  • dafc793007 create_database.sh: add support for MySQL version 8.0.x Christoph 2018-08-03 23:49:05 +00:00
  • bbed466b7f Add script 'repair_mysql_tables.sh'. Christoph 2018-07-30 11:43:27 +02:00
  • a842cf5906 optimize_mysql_tables.sh: if a database is given at the command line, only check tables of this database. Christoph 2018-06-24 15:40:19 +02:00
  • 6c2e2bee12 optimize_mysql_tables.sh: fix error in determin mysql binary. Christoph 2018-03-08 11:51:19 +01:00
  • 3ea5c8d2ef Some minor changes in script output. Christoph 2018-03-05 11:46:47 +01:00
  • 7cba022614 Merge branch 'master' of https://git.oopen.de/script/mysql Christoph 2018-03-05 03:16:10 +01:00
  • f18e3f54da Some minor changes. Christoph 2018-03-05 03:15:34 +01:00
  • 43421e7d85 optimize_mysql_tables-ND.sh: fix error in handling nd-archiv. Christoph 2018-03-05 03:02:42 +01:00
  • ab2421a717 optimize_mysql_tables-ND.sh: redesign in dependence to script 'optimize_mysql_tables.sh'. Christoph 2018-03-05 02:47:42 +01:00
  • 3016fb6f27 In case of not running in a terminal: do not print warning if no configuration file was found. Christoph 2018-03-05 01:33:43 +01:00
  • a0bf2ae89b Remove commented old code. Christoph 2018-03-05 01:11:51 +01:00
  • c4e6aafb33 Support of optimizing (repairing) tables of multiple mysql installations. Christoph 2018-03-05 00:57:51 +01:00
  • 5da83b8558 Add script 'drop_tables.sh'. Christoph 2018-02-19 17:04:46 +01:00
  • ce28ffd467 Change handling od database files. Christoph 2017-09-23 01:59:34 +02:00
  • e04e224888 Add/Redesign scripts for creating/dropping databases Christoph 2017-09-23 01:09:29 +02:00
  • 1a89bbbd84 remove configuration sample file 'optimize_mysql_tables.conf.sample'. Christoph 2017-07-03 16:22:44 +02:00
  • 7e8b097e17 Move optimize_mysql_tables.conf.sample mysql_credetials.conf.sample. Read configuration file by scripts 'optimize_mysql_tables.sh' 'flush_query_cache.sh' and 'flush_host_cache.sh'. Christoph 2017-07-03 16:20:48 +02:00
  • 37d7ada44c Add configuration file for script 'optimize_mysql_tables.sh'. root 2017-07-03 16:11:45 +02:00
  • 639adf672c Change Logging mechanism. Christoph 2017-07-03 04:06:05 +02:00
  • 3f869c36b1 add .gutignore Christoph 2017-03-08 03:13:57 +01:00
  • 9ec6b1c2e1 Initial import Christoph 2017-02-21 02:31:30 +01:00