-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello. I am a new member to this list. I would like to run an sql query as a cron job and can't figure out how. Here is some background.
I have mysql loaded on several of our linux servers. I currently use mysqldump in a cron job in conjuction with logrotate as a backup method. I like the ascii files I get as a result and can work with them easier than more traditional methods of backup. I user the mysql command quite often with sql commands searching for db entries. I always enter these sql commands after getting into the mysql command prompt.. I also know exactly what sql statement I want to execute. I have succesfully executed it from both the mysql command prompt and from Mysql control center. However, I do not know how to execute an sql statement from the linux command prompt. If I could this, I could easily enter it into the crontab or cron scripts as needed. Help would be greatly appreciated. Thank you. - -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810 814.796.4795 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+71X1oPG25PauKIkRAv7bAKCeRKH0AgvPaAWz+iAsqvbMKCwJmgCffox2 basbxJJYBV7NYNQso8KxR4A= =fNWJ -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]