如何使用Windows应用程序以编程方式将数据库备份从mysql备份到.net [英] How to get programmatically database backup from mysql to .net using windows application

问题描述

嗨 请任何人有解决方案，所以请给我如何使用.NET从mysql以编程方式获取数据库备份
如果有人知道，请给出代码.........

Hi Please Anybody have solution so please give me how to programmatically get database backup from mysql using .NET
please give code if anybody know .........

推荐答案

您可以使用 SHOW TABLES [ ^ ]和 DESCRIBE [ SELECT [

You can use a combination of SHOW DATABASES[^], SHOW TABLES[^] and DESCRIBE[^]

When you got the table struct you can use SELECT[^] statement to retrieve all data in 1 table at the time. Repeat that for all tables in the database.

最好的方法是使用 ^ ]或查看 phpmyadmin [

Best way is to use mysqldump[^] or check out phpmyadmin[^] and find out how they do it.

这篇关于如何使用Windows应用程序以编程方式将数据库备份从mysql备份到.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！