MySQL-backup fungerar inte att köra som crontab
Postat: 07 okt 2008, 07:55
Det här scriptet går utmärkt att köra för mig om jag gör ./script.py men om jag skulle göra en crontab med 1 * * * * python /to/mysql.py så fungerar det inte. Enligt loggarna så körs det men filen vill inte skapas.. Någon som har idéer?
Kod: Markera allt
#!/usr/bin/python
"""
MySQL-Backup
Version: 0.1
Copyright (C) 2008 Johan "Louie" Haals johan.haals[AT]gmail.com
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see http://www.gnu.org/licenses/
"""
import datetime, commands
today = datetime.date.today()
today = "sql/" + str(today) + ".sql"
p = 'passwd'.decode('rot13')
commands.getstatusoutput("mysqldump --all-databases -u username -p"+p+" > " + today)
commands.getstatusoutput("chmod a-wrx "+today+"")