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

2005-12-28 Thread nephish
Glad to help, glad you got it working too.! shawn On Wed, 2005-12-28 at 09:03 +, John Joseph wrote: > --- nephish <[EMAIL PROTECTED]> wrote: > > > 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.syste

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

2005-12-28 Thread John Joseph
--- nephish <[EMAIL PROTECTED]> wrote: > 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 t

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

2005-12-27 Thread 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, 2

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

2005-12-27 Thread John Joseph
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”