Category: MySQL

On DBs

T
blank

Turbo charging MySQL by setting up the query cache

To 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…
M
blank

Moving mySQL DBs between servers

Moving 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…
T
blank

Taking backup of mysql database using cron

Taking 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 :…
H
blank

How can I repair corrupt MySQL tables?

How 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.…