Category Archives: Wordpress

Home »  Wordpress

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

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: 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 # chkconfig httpd on; chkconfig mysqld on # /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 THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password ‘new-password’ /usr/bin/mysqladmin -u root -h wiki.sabeo.ie password ‘new-password’ Alternatively you can run: /usr/bin/mysql_secure_installation which will also […]

I had that on one custom installation I took over where I didn’t want to change anything or rework the whole installation. The fix was extreme  easy. the WordPress directory was owned by root while apache was running as apache user. WordPress updates are executed by the apache client. So changing the directory to be owned by apache removed the ftp request. chown apache:apache wordpress Make sure you apply all other security measures. Related posts: RedHat 6.x / Centos 6.x: How to install in WordPress in less than 10 minutes

%d bloggers like this: