MySQL

How to install MySQL on CentOS

Here are the steps of what you need to do in order to install and setup MySQL on a new server. We’ll prepare a fresh CentOS 6 system (64 bit) for use as a database server. All you need is access to an SSH client and your server root credentials.

Read the full article →

How to deploy HyperDB

Ever since I’ve started experimenting with HyperDB I thought that once I’ve got enough servers at my disposal, and if I ever figure out how to setup MySQL replication I’d bring the two together. I believe that day has finally come: HyperDB is now deployed across over 60 sites I’m taking care of. I want [...]

Read the full article →

How to increase the Upload Limit in phpMyAdmin?

Since phpMyAdmin is written in php, all we need to do is change the file upload limit in the php.ini file. On CentOS and RHEL distributions, this file is located in /etc/php.ini Find this section: ;;;;;;;;;;;;;;;; ; File Uploads ; ;;;;;;;;;;;;;;;; ; Whether to allow HTTP file uploads. file_uploads = On ; Temporary directory for [...]

Read the full article →

Where are the MySQL data files on CentOS?

They’re located in /var/lib/mysql/ Each database has a subfolder here. You’ll also find the MySQL log files here.

Read the full article →

How to repair MySQL tables from the Command Line

Sometimes your tables crash and your website is unresponsive. You don’t have access to phpMyAdmin to do a repair, because you can’t access Plesk. That sucks! When you’re out in the field and all that’s at hand is a trusty SSH connection from your mobile, here’s an alternative way to bring your WordPress Sites back [...]

Read the full article →

How to move WordPress from one server to another

It’s not as difficult as one might think, as this article explains: http://codex.wordpress.org/Moving_WordPress If however this means not a lot to you, or you have tried and it’s still not working, you should check out the following topics: How to backup your Database How to restore your Database Hope this helps

Read the full article →