Tag Archives: Mysql

Home »  Tag: Mysql

I recently switched to backwpup to backup my wordpress sites. Its a nice handy tool to make and sql dump a wordpress xml export zips its all up and uploads to dropbox. What else would anyone want ? you can find the free version of it here. https://wordpress.org/plugins/backwpup/ So in the case of a migration or restore I unzip the file in its new home and have to load the databasedump.sql back into the database. Presuming I have setup a database and a user with the appropriate permissions its just mysql -u username -p -h localhost databasename < databasedump.sql And thats pretty much it. The data is in the database. Related posts: RedHat / Centos 6.x: Upgrade or install MySQL 5.6 (fixed again) Centos: How to make splunkstorm forwarder autostart at boot. VPS : Basic checks for performance of a VPS and or a Server RedHat 6.x / Centos 6.x: How to install in […]

This is a quick Install How to Guide on How to install NSTI NSTI is the Nagios  SNMP Trap Interface. If you setup your Nagios to receive passive SNMP Traps, you did this most likely via snmptt then you have the option to store the SNMP traps in the MySQL Database. Due to the lack of Nagios to show only the last incoming trap there is no way (except of sending notifications via mail) to list all the incoming traps. Well now there is. NSTI You could find a few details about NSTI here http://exchange.nagios.org/directory/Addons/SNMP/Nagios-SNMP-Trap-Interface-%28NSTI%29/details Or in the Support Forum http://support.nagios.com/forum/viewforum.php?f=22 There is a Version 2.0 RC of which I would strongly advise to stay away simply cause it didn’t work. http://labs.nagios.com/2012/01/10/nagios-snmp-trap-interface-nsti-available/ So how do we install it. We use the version 1.4. It is assumed that you have installed snmptt as per http://assets.nagios.com/downloads/nagiosxi/docs/Integrating_SNMP_Traps_With_XI.pdf This has not yet enabled the mysql part of the trap’s. So do the following: […]

MySQL 5.6 has been released as GA and as per Oracle  Notes http://www.oracle.com/us/corporate/press/1904335 “With increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.” So lets try to install it on an existing Centos 6.3 OpenVZ Container running LAMP. Its my Lab container with WordPress and other things running. There is already mysql-5.1.67 on it which we will remove. Please make sure you have a backup / snapshot to roll back if it breaks anything or doesn’t work or perform as expected. We start getting the rpm packages. You can browse for the latest version packages here cd /tmp wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/ wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/ wget http://www.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/ libaio is needed yum install libaio Now it’s time to say good bye to the old mysql. yum remove mysql mysql-server mysql-libs Hello mysql 5.6 rpm -ivh MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm rpm -ivh MySQL-server-5.6.12-2.el6.x86_64.rpm rpm -ivh MySQL-client-5.6.12-2.el6.x86_64.rpm (updated) I now […]

Assumption: clean fresh minimal installed RedHat or Centos (or any similar linux) registered and updated to the latest revisions: This is a quick and dirty install for demo purpose. For the minimum of security please refer to http://doc.owncloud.org/server/5.0/admin_manual/installation.html rhn_register #with your details yum -y update #to get latest updates make sure either dns is working or your hosts and IP are in the local /etc/hosts file Time to start the clock: Install the needed packages. yum -y install mysql-server httpd php php-mysql unzip wget php-json php-xml php-mbstring php-zip php-gd curl php-curl php-pdo chkconfig httpd on; chkconfig mysqld on #It might be a good idea to reboot the box here. reboot /etc/init.d/mysqld start Initializing MySQL database:   Installing MySQL system tables.. . OK Filling help tables… OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR […]

%d bloggers like this: