ooh ooh, i know this one, i have python do this for me every day !
target_dir = '/path/to/where/you/want/to/dump'
os.system("mysqldump --add-drop-table -c -u user -ppassword database
table > "+target_dir+"/table.bak.sql")
dont forget the p in front of your password !
hope this helps
On Tue, 2005-12-27 at 13:07 +0000, John Joseph wrote:
> Hi
> I am trying to execute some MySQL commands using
> some python scripts
> I want to do a “mysqldump” of my database “john” to
> a file backup.date.sql
> the normal command to take a dump is
> mysqldump john > backup.sql
>
> I tried python , by importing
> “import os”
> but I am stuck in how to call “mysqldump” in
> python and execute it
> Help and guidance requested
> Thanks
> Joseph
>
>
>
>
> ___________________________________________________________
> NEW Yahoo! Cars - sell your car and browse thousands of new and used cars
> online! http://uk.cars.yahoo.com/
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
