Simple database table dumping in a specific path

Question

How can I dump MySQL database table only which will store my on drive 'c:', rather than whole database

here is my running python connect script:

cnx = mysql.connector.connect(user='test',
                         password ='test',host='192.168.25.63',
                       database='test',port='3306')

I also refer to this question using subprocess: How to copy a database with mysqldump and mysql in Python?

I just want to have a python script just like having MySQLdump using windows command.

Mazdak · Answer 1 · 2015-11-05T09:02:21.757

0

You can simply use following command with popen:

import subprocess
subprocess.popen("mysqldump db_name table_name > your_path/table_name.sql", shell=True)

edited Nov 05 '15 at 09:02

answered Nov 05 '15 at 07:12

Mazdak

105,000
18
159
188

but how can I test if the dump is success, or where it was stored. – Syntax Rommel Nov 05 '15 at 08:54
@Rockn'Roll You need to add the `path` at the leading of your dump name.Checkout the edit. – Mazdak Nov 05 '15 at 09:02
yup I already had that, but im still access denied, do I need to have grant privileges so that I can dump it or there is something error in my code? – Syntax Rommel Nov 05 '15 at 09:09
CMD.EXE was started with the above path as the current directory. UNC paths are not supported. Defaulting to Windows directory. Access is denied – Syntax Rommel Nov 05 '15 at 23:10
Note: that im just trying to dump it to my terminal from server, not a localhost – Syntax Rommel Nov 05 '15 at 23:32

Simple database table dumping in a specific path

1 Answers1