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;

Managing MySQL with Percona Toolkit by Frédéric Descamps | Colin Charles Agenda

Managing MySQL with Percona Toolkit by Frédéric DescampsPosted on 5/2/2012, 10:58 am, by Colin Charles, under MySQL.Frédéric Descamps of Percona.Percona Toolkit is Maatkit & Aspersa combined. Opensource and the tools are very useful for a DBA.You need Perl, DBI, DBD::mysql, Term::ReadKey. Most tools are written in Perl, and whatever is in Bash is being re-written En savoir plus surManaging MySQL with Percona Toolkit by Frédéric Descamps | Colin Charles Agenda[…]

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[…]

Using ODBC in the core – FreeSWITCH Wiki

2. Install the unixODBC driver You will need to obtain the ODBC for your chosen database. Instructions for obtaining the drivers for MySQL or PostgreSQL are provided below. For MySQL: sudo apt-get install libmyodbc For PostgreSQL sudo apt-get install odbc-postgresql 3. Configure /etc/odbc.ini & /etc/odbcinst.ini Add the following with the correct information into your odbc.ini En savoir plus surUsing ODBC in the core – FreeSWITCH Wiki[…]

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[…]

Tutoriel sur UTF-8 avec PHP et MySQL

UTF-8 PHP MYSQL (histoire d’encodage) * Accueil * UTF-8 PHP MySql * Barre de progression d’upload en PHP Encodage et programmation Les caractères qui s’affichent sur les écrans d’ordinateur, comme toute donnée informatique, ne sont qu’une sucession de 0 et de 1 du point de vue de la machine. C’est le nombre et l’ordonnance de En savoir plus surTutoriel sur UTF-8 avec PHP et MySQL[…]

Postfix Flush the Mail Queue

Traditionally you use the « sendmail -q » command to flush mail queue under Sendmail MTA. Under Postfix MTA, just enter the following command to flush the mail queue: # postfix flush OR # postfix -f To see mail queue, enter: # mailq To remove all mail from the queue, enter: # postsuper -d ALL To remove En savoir plus surPostfix Flush the Mail Queue[…]