Novell Home

Update: CRON for MySQL Shutdown

Novell Cool Solutions: Tip
By Rekha Bhaskaran

Digg This - Slashdot This

Posted: 17 Aug 2005
 

The Cool Solutions article at:
http://www.novell.com/coolsolutions/tip/15015.html

talks about a CRON job to shut down MySQL. To CRON the shutdown of MySQL without screen presence (i.e, "Press any key"), one has to follow these steps:

1. Start mysqld using this command:
mysqld_safe --autoclose
This will automatically close MySQL server screen after shutdown.

2. Shut down MySQL using this command:
mysqladmin -u myaccount shutdown -a
This will automatically close the mysqladmin screen after shutdown is complete.

The mysqlhotcopy utility will back up only MyISAM tables. To back up InnoDB tables, shut down MySQL server using mysqladmin and take the normal file system backup MySQL data directory.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell