Splitter un dump mysql avec Bash, en 1 dump par table

#!/bin/bash file=$1 # the input file directory= »$file-splitted » # the output directory output= »$directory/header » # the first file containing the header GREP= »DROP TABLE » # what we are looking for mkdir $directory # create the output directory while read line do # if the current line contains the wanted statement if [ $(echo « $line » | grep -c « $GREP ») En savoir plus surSplitter un dump mysql avec Bash, en 1 dump par table[…]

Collectd, monitorer mysql

coté collectd Host « localhost » User « collectd » Password « Secrets of the Universe with Philo » Database « mysql » # MasterStats true coté Ligne de commande mysql -u root mysql> CREATE USER ‘collectd’@’localhost’ IDENTIFIED BY ‘password’; mysql> GRANT SELECT, PROCESS, SHOW DATABASES, SUPER ON *.* TO ‘collectd’@’localhost’; mysql> FLUSH PRIVILEGES;

MySQL Error 23 on Linux | Chris Johnson’s Blog

If you have ever encountered a “23 error” you are most likely running MySQL on a windows machine. The error looks something like this: ERROR 23 (HY000): Out of resources when opening file ‘./somedb/sometable.MYD’ (Errcode: 24) What this error typically means is that MySQL has exceeded the limit for the number of files you can En savoir plus surMySQL Error 23 on Linux | Chris Johnson’s Blog[…]

With a Little Help from my Friend | How to recreate root account in MySQL

Today I was trying to log in to mysql database administration on one of my hosting machines and as I was getting ‘permission denied for user rott@localhost’ I tried to fix the root account and reset its password. But I wasn’t successful and later on I realized, that the root account was deleted from the En savoir plus surWith a Little Help from my Friend | How to recreate root account in MySQL[…]