How to Monitor MySQL’s performance
1) mysqladmin extended (absolute values) The values making most sense to monitor are: * Slave_running: If the system is a slave replication server, this is… Read More »How to Monitor MySQL’s performance
mysql
Requete SQL sur la base d’OCS Inventory en Perl
Note Utilisation de INET_ATON de MySQL pour trier sur les IP #!/usr/bin/perl -w use strict; use warnings; use DBI; #Connection à la base de donnes… Read More »Requete SQL sur la base d’OCS Inventory en Perl
non-interactive mysql install on Debian / Ubuntu
echo mysql-server mysql-server/root_password select PASSWORD | debconf-set-selections echo mysql-server mysql-server/root_password_again select PASSWORD | debconf-set-selections aptitude -y install mysql-server libmysqlclient15-dev Note Scripted install of MySQL
Enable PHPMyAdmin Designer mode (diagrams to show relationships between tables)
Go to /path/to/phpmyadmin/config.inc.php (or something similar) Change these settings: $cfg[‘Servers’][$i][‘controluser’] = ‘pma’; $cfg[‘Servers’][$i][‘controlpass’] = ‘yourpass’; (don’t forget to give user pma a password otherweise people… Read More »Enable PHPMyAdmin Designer mode (diagrams to show relationships between tables)
manipular datos de una bd externa con django
from django.db import load_backend, transaction, connection #manipular datos de una bd externa def sincronizeDB(self): myBackend = load_backend(‘mysql’) # or ‘mysql’, ‘sqlite3’,… Read More »manipular datos de una bd externa con django
query – case sensitive en mysql
SELECT * FROM `table` WHERE BINARY `COLUMN` = ‘value’ Note binary
mysql – guardar los resultados en un fichero
SELECT id,title INTO OUTFILE “c:/result.text” FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY “n” FROM property;
Resetting a forgotten MySQL root password
First of all you will need to ensure that your database is stopped: root@steve:~# /etc/init.d/mysql stop Now you should start up the database in the… Read More »Resetting a forgotten MySQL root password
Réinitialiser le mot de passe d’un utilisateur mediawiki
UPDATE user SET user_password = MD5(CONCAT(user_id, ‘-‘, MD5(‘somepass’))) WHERE user_name = ‘someuser’;
utf8_unicode_ci vs utf8_general_ci
You can check and compare sort orders provided by these two collations here: http://www.collation-charts.org/mysql60/mysql604.utf8_general_ci.european.html http://www.collation-charts.org/mysql60/mysql604.utf8_unicode_ci.european.html utf8_general_ci is a very simple collation. What it does -… Read More »utf8_unicode_ci vs utf8_general_ci
- « Previous
- 1
- 2
- 3
- Next »