|
erics, December 2nd, 2018 mysqldump -u {yourUserNameHere} -p –no-data –compact {yourDatabaseHere}
Categories: How-To's, Technology create table, Database, howto, mysql, mysqldump, Structure, Table, tips
| 
No comments
erics, September 27th, 2018 There are many things to configure in Nagios, especially when using custom check commands. Recently I needed to configure all of the Continuent Clustering Nagios checks. Once setup on the database side, I wanted to confirm that everything was working. Basics: Run a Remote NRPE Check To test a remote NRPE client command from a […]
Categories: How-To's, Technology cli, Clustering, Command, Command line, Continuent, Disaster REcovery, DR, HA, High Availability, howto, mysql, nagios, NRPE, Test, tips
| No comments
erics, May 16th, 2018 SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.
Categories: How-To's, Technology howto, Join, Left Join, mysql, Query, Row, Rows, select, SQL, Table, tips, Where
| No comments
erics, December 7th, 2017 START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL) 1 2 3 4 5 6 mysql –execute="SET GLOBAL innodb_fast_shutdown=0;" service mysqld stop yum remove mysql mysql-* yum install mysql57-devel mysql57-server mysql57-test service mysqld start mysql_upgrade mysql –execute=”SET GLOBAL innodb_fast_shutdown=0;” service mysqld stop yum remove mysql mysql-* yum install […]
Categories: How-To's, Technology 5.5, 5.7, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.5, MySQL 5.7, tips, upgrade
| No comments
erics, August 25th, 2016 In this case I had done a restore from a MySQL 5.1 server to a MySQL 5.6 server. That was not too smart, because it broke the mysql database table structures and prevented me from logging in remotely. Local login worked both via the socket and TCP. mysql -u root -p -h remoteHostName Enter password: […]
Categories: How-To's, Technology Error, howto, login, mysql, mysql_upgrade, remote, Remote Login, tips
| No comments
erics, August 24th, 2016 As PHP deprecates old functions, sometimes code maintenance changes become required for long-running sites. As of PHP 5.5, the MySQL functions are deprecated and are removed in PHP 7! I recently had to convert multiple sites to mysqli PHP functions because a new server was running PHP 5.6 and the old server was on PHP […]
Categories: How-To's, Technology convert, mysql, mysqli, php, PHP5.5, PHP5.6, PHP55, PHP56, WordPress
| No comments
erics, March 22nd, 2016 Quick-and-dirty way: tcpdump -i eth0 -s 0 -l -X dst port 3306 NOTE: That option above is a dash-ELL which provides for unbuffered output. Maciej Dobrzanski posted the following script on the Percona site at https://www.percona.com/blog/2008/11/07/poor-mans-query-logging/, which I am reposting without permission because it is so good: 1 2 3 4 5 6 7 8 […]
Categories: How-To's, Technology 3306, mysql, Network, Scan, Sniff, Sniffer, tcpdump, Watch
| No comments
erics, October 2nd, 2015 I needed to automate the addition of new users with a sequential member’s ID in WordPress. Additionally, there were non-numeric entries in that column that had to be ignored. The wp_users.user_login column is a varchar(60) and so does not naturally handle numeric operations well at all. The solution is a combination of REGEXP and cast(): […]
Categories: How-To's, Technology Cast, Char, Column, Filter, howto, Max, mysql, Numeric, Regex, regexp, select, sort, SQL, tips, Varchar, Where, WordPress
| No comments
erics, August 13th, 2015 Amazon Web Services (AWS) offers MySQL Server via the Relational Database Service (RDS) offering. Unfortunately, AWS doesn’t allow ICMP Ping to reach the nodes, so as configured by default, Nagios will fail on the host check. The solution is to submit a Passive Check for that host. Login to the Nagios web console Click on […]
Categories: How-To's, Technology Amazon, AWS, Check, Host, Host Check, howto, mysql, nagios, Passive, Passive Check, Ping, RDS, tips
| No comments
erics, October 29th, 2014 [root@db1 ~]# service mysqld stop [root@db1 ~]# cd /var/lib/mysql [root@db1 mysql]# ls -l ib_logfile? -rw-rw—- 1 mysql mysql 5242880 Oct 29 23:00 ib_logfile0 -rw-rw—- 1 mysql mysql 5242880 Oct 29 22:38 ib_logfile1 [root@db1 mysql]# mv ib_logfile0 ib_logfile0.old [root@db1 mysql]# mv ib_logfile1 ib_logfile1.old [root@db1 ~]# vi /etc/my.cnf innodb_log_file_size=64M # comment out the old value, if one […]
Categories: How-To's, Technology Change, howto, InnoDB, innodb_log_file_size, my.cnf, mysql, Percona, tips, update
| No comments
