Category: MySQL

On DBs

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 : ------------------------------------------------- #!/bin/sh date=`date '+%m-%d-%y'` mysqldump -u database_username -pdatabase_password database_name > ~/mysql_backup/database_name.$date -------------------------------------------------...

/ 27 March 2009

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. Login to your server via SSH and change directories to the...

/ 12 September 2008