Category: MySQL

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…

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 mysql -uUSER -pPASSWORD txp_database < txp_database.sql…

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 :…