MySQL Backup from within MySQL Connector

Question

This is probably pretty simple, but I can't find the answer in the docs. Anyway I need to programmatically create a backup of a mysql table. Typically I would just invoke a "mysqldump" from a batch file or shell script. In this specific project I cannot access any batch files or outside shell scripts. I can also not use System.Diagnostrics.Process classes to simulate running mysqldump from the command line.

This leaves me with accomplishing this task from within the MySQL .NET Connector. How can I mimic "mysqldump" from within a query (in Windows) that I can send to my connection instance then execute?

Thoughts?

Would this help?

Uwe Keim
– Uwe Keim

2011-06-24 19:05:06 +00:00
Commented Jun 24, 2011 at 19:05 — Uwe Keim
– Uwe Keim, Commented Jun 24, 2011 at 19:05

MJB · Accepted Answer · 2011-06-24 19:09:48Z

1

If you need a hot backup, I think you are out of luck. All backup options/products require external products to be run. Is this ISAM or INNODB tables?

answered Jun 24, 2011 at 19:09

MJB

9,4196 gold badges37 silver badges49 bronze badges

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

2 Comments

kmarks2 Over a year ago

They are MyISAM. If they were INNODB I'd just wrap all my calls in transactions and forget about backups.

MJB Over a year ago

Hmm, I think with MyISAM you can lock the tables, flush them and then copy them to annother table. Of course that brings things to a grinding halt.

Collectives™ on Stack Overflow

MySQL Backup from within MySQL Connector

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related