Welcome!
This is the community forum for my apps Pythonista and Editorial.
For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.
mysqldump failed with an error
-
Hello Guys,
I have a Question is it possible to run the mysql dump on Pythonista ?
i try to use this code:
subprocess.Popen('mysqldump --user=username --password=passwd --databases mydb > test.sql')
but every time i tried i get this error:
Traceback (most recent call last): File "/private/var/mobile/Library/Mobile Documents/iCloud~com~omz-software~Pythonista3/Documents/UI/Test Ordner/MYSQL/mysqlRequest-CustomerEntries.py", line 139, in <module> mysql_data() File "/private/var/mobile/Library/Mobile Documents/iCloud~com~omz-software~Pythonista3/Documents/UI/Test Ordner/MYSQL/mysqlRequest-CustomerEntries.py", line 17, in __init__ self.list_data() File "/private/var/mobile/Library/Mobile Documents/iCloud~com~omz-software~Pythonista3/Documents/UI/Test Ordner/MYSQL/mysqlRequest-CustomerEntries.py", line 136, in list_data subprocess.Popen('mysqldump --user= username --password= passwd --databases mydb > test.sql') File "/var/containers/Bundle/Application/2952696D-C724-455F-8983-F13D0477091A/Pythonista3.app/Frameworks/Py3Kit.framework/pylib/subprocess.py", line 708, in __init__ restore_signals, start_new_session) File "/var/containers/Bundle/Application/2952696D-C724-455F-8983-F13D0477091A/Pythonista3.app/Frameworks/Py3Kit.framework/pylib/subprocess.py", line 1261, in _execute_child restore_signals, start_new_session, preexec_fn) PermissionError: [Errno 1] Operation not permitted
or do i something wrong ?
Thanks for your reply! -
@DavinE please read this topic about subprocess in Pythonista.
-
@cvp, Thanks for this topic!
now i need to find another way :D -
You may be able to run the string command that you were trying to Popen, using the commandline in stash.