v1g0 Posted January 7, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 34 Reputation: 1 Joined: 12/06/11 Last Seen: December 23, 2016 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 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 11 Reputation: 1 Joined: 01/11/12 Last Seen: February 13, 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 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 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...
Question
v1g0
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
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.