Archive for 'MySQL'
cPanel Server : Restoring MySQL SimLink.
Posted on 16. Feb, 2010 by wiredgorilla.
TweetIf you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the following: cd /var/lib/mysql/ touch mysql.sock chmod 1777 mysql.sock chown mysql.mysql mysql.sock Create a symlink for the sock file :- ln [...]
Continue Reading
How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1
Posted on 18. Apr, 2009 by wiredgorilla.
TweetThis tutorial is based on Falko Timme’s tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is [...]
Continue Reading
Turbo charging MySQL by setting up the query cache
Posted on 27. Mar, 2009 by wiredgorilla.
TweetTo make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell command locate , in our case we are running on a CentOS 5.2 distro and to its my.cnf located in [...]
Continue Reading
Moving mySQL DBs between servers
Posted on 27. Mar, 2009 by wiredgorilla.
TweetMoving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one nicely portable text file. on a new server it takes mysql -uUSER -pPASSWORD txp_database < txp_database.sql to import it.
Continue Reading
Taking backup of mysql database using cron
Posted on 27. Mar, 2009 by wiredgorilla.
TweetTaking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :
Continue Reading
How can I repair corrupt MySQL tables?
Posted on 12. Sep, 2008 by wiredgorilla.
TweetHow can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables.
