How to manage Picklog ?

[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 ?

[wsoulrc]

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)

[Asura]

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