[Tutor] How to call mysqlcommand in Python , "mysqldump for backup "

[nephish]

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 at python.org
> http://mail.python.org/mailman/listinfo/tutor