External Digital Feeds from Leading Technology News Sources
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 your server with the shell …
By News Monkey on March 27, 2009
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 < …
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 :
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.
By News Monkey on September 12, 2008