v1g0 Posted January 7, 2012 Share Posted January 7, 2012 Hello, I would like create a script for manage picklog. The principle would be : - Copying picklog table on a second database (database backup) with archiving. - and truncate the picklog table of the main database. with crontab monthly Someone know how to do it ? Someone can help me for make this script please ? Quote Link to comment Share on other sites More sharing options...
wsoulrc Posted January 12, 2012 Share Posted January 12, 2012 hi, is easy, i dont create the script, but i guide you you can create de script in perl, and use cronjob and mysqldump mysqldump -p --user userdb dbname table > namebackup.sql //backup And cronjob is easy 30 23 1 * * /script.sh 30 = minutes 23 = hour 1 = day * = every months * = every day of week (is day = 1) Quote Link to comment Share on other sites More sharing options...
Asura Posted February 10, 2012 Share Posted February 10, 2012 Hi v1g0, I would recommend taking a read at Brian's post; and using that available script as a base for your own picklog management. http://rathena.org/board/topic/54049-auto-sql-backup-for-linux/page__view__findpost__p__58378 Quote Link to comment Share on other sites More sharing options...
Hello,
I would like create a script for manage picklog.
The principle would be :
- Copying picklog table on a second database (database backup) with archiving.
- and truncate the picklog table of the main database.
with crontab monthly
Someone know how to do it ?
Someone can help me for make this script please ?
Link to comment
Share on other sites