ImagineAdmin / cronnix

Automatically exported from code.google.com/p/cronnix
0 stars 0 forks source link

Scheduling a mysql backup #16

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. I want to run that each day : "mysqldump --user=XXXXXXXX --password=XXXXXXX 
-A > /PATH/TO/DUMPFILE.SQL"
2. In fact it creates an empty file
3. If i run that into the terminal it runs good

What is the expected output? What do you see instead?
I want to have a dump of my mysql databases

What version of the product are you using? On what operating system?
302 on MAC OS Lion server

Please provide any additional information below.

Thanks

Original issue reported on code.google.com by enquet...@lepetitconsultant.com on 7 Jun 2012 at 10:06

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
I modified what's needed, now it works good.
Here is the script
/usr/local/mysql/bin/mysqldump --opt -h localhost -uUSER -pPASSWORD SGBDNAME 
--single-transaction > "/path/tobackup/mydatabase.sql"

Just one question: does cronnix has to be started to have the schedule work ? 
Or it's just a gui to set up the cron : no need to start it after setting up 
paramaeters...

Thanks

Original comment by enquet...@lepetitconsultant.com on 7 Jun 2012 at 1:01

GoogleCodeExporter commented 8 years ago
It's like you said: CronniX is simply a GUI to edit cron's config files. It 
should be running by default on your system.

Glad it's working for you now!

Cheers,
Sven

Original comment by sven.a.s...@gmail.com on 7 Jun 2012 at 10:26