Update: CRON for MySQL Shutdown
Novell Cool Solutions: Tip
By Rekha Bhaskaran
Digg This -
Posted: 17 Aug 2005
The Cool Solutions article at:
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:
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