Export MySQL database to sql file with Python os.system

Question

I want to export a database to sql file with Python, so I tried this

import os
os.system('mysqldump -u root -p database > database.sql')

and it asks me to write the password of the root user in the shell, but I'm doing a GUI application, so I don't want the user to interact with the shell.

Is it possible to give it the password in some other way?

nikora · Accepted Answer · 2014-12-07 03:40:38Z

6

You can prompt the user for the password and insert it into the command.

import os
os.system('mysqldump -u root -p%s database > database.sql' % password)

The syntax is -pmypass or --password=mypass

answered Dec 7, 2014 at 3:40

nikora

8171 gold badge14 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Thoma Over a year ago

Just because it is so unusual I want to be explicit here: There is NO SPACE between -p and yourpassword!

Collectives™ on Stack Overflow

Export MySQL database to sql file with Python os.system

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related