programitically通过c＃.net恢复mysql数据库备份文件（.sql） [英] restore mysql database backupfile(.sql) through c# .net programitically

问题描述

这是我的代码

 ProcessStartInfo startInfo =  new  ProcessStartInfo （  cmd.exe）; 
 Process.Start（startInfo）; 
 startInfo.Arguments =   mysqldump -u admin -p admin -h host test> c：\ backupfile.sql; 
 Process.Start（startInfo）; 

i通过读取所有文件文本并将其存储在字符串中并使用执行来尝试mysqlcmd.executenonquery（）但它只生成数据库表而不存储过程和其他对象。



谢谢你

解决方案

尝试了这些链接：



https://www.google.co.in/search?q=using+c%23+restore+mysql+database+script+with+all +数据库+对象+和+数据&安培; EI = 8-89UqObG4rprQfOwIGoCA&安培;开始= 10安培; SA = N&安培; BIW = 1366&安培;波黑= 622&安培; DPR = 1个＃q =还原+的MySQL +数据库+备份++在+ C +％ 23 + .net [ ^ ]

http://dba.stackexchange.com/questions/24371/how-to-import-a-sql-file-in-mysql [ ^ ]

http://www.techtasks.net /2013/01/how-to-backup-restore-mysql-database-command-prompt.html [ ^ ]

http://forums.mysql.com/read.php?28,18395,181484 [ ^ ]

www.dreamincode.net/forums/topic/271276-how-to-backup-and-restore-mysql-database-using- vbnet / [ ^ ]

http： //codeblow.com/questions/c-mysql-database-restore/ [ ^ ]

http://database.ittoolbox.com/groups/technical-functional/mysql-l/backup-and-restore-mysql-database-through-vbnet-3450158 [ ^ ]

http://social.msdn.microsoft.com/Forums/vstudio/en-US/697cae3f-daf0-4bff-a7b1-f846fba08980/how-to-take-mysql-backup-and-restore-using- windows-c [ ^ ]

http://stackoverflow.com/questions/4233988/back-up-and-restore-mysql-database-c-sharp [ ^ ]

http://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql- databasetables / [ ^ ]

http://stackoverflow.com/questions/8855224/how-to-execute-sql-mysql-file-in-my-c-sharp-application [ ^

this is my code

ProcessStartInfo startInfo = new ProcessStartInfo("cmd.exe");
Process.Start(startInfo);
startInfo.Arguments = "mysqldump -u admin -p admin -h host test > c:\backupfile.sql";
Process.Start(startInfo);

i have tried it by reading all file text and store it in string and execute using mysqlcmd.executenonquery() but it generate database tables only not stored procedures and other objects.

thank you

解决方案

tried these links:

https://www.google.co.in/search?q=using+c%23+restore+mysql+database+script+with+all+database+objects+and+data&ei=8-89UqObG4rprQfOwIGoCA&start=10&sa=N&biw=1366&bih=622&dpr=1#q=Restore+MySQL+Database+backup++in+c+%23+.net[^]
http://dba.stackexchange.com/questions/24371/how-to-import-a-sql-file-in-mysql[^]
http://www.techtasks.net/2013/01/how-to-backup-restore-mysql-database-command-prompt.html[^]
http://forums.mysql.com/read.php?28,18395,181484[^]
www.dreamincode.net/forums/topic/271276-how-to-backup-and-restore-mysql-database-using-vbnet/[^]
http://codeblow.com/questions/c-mysql-database-restore/[^]
http://database.ittoolbox.com/groups/technical-functional/mysql-l/backup-and-restore-mysql-database-through-vbnet-3450158[^]
http://social.msdn.microsoft.com/Forums/vstudio/en-US/697cae3f-daf0-4bff-a7b1-f846fba08980/how-to-take-mysql-backup-and-restore-using-windows-c[^]
http://stackoverflow.com/questions/4233988/back-up-and-restore-mysql-database-c-sharp[^]
http://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/[^]
http://stackoverflow.com/questions/8855224/how-to-execute-sql-mysql-file-in-my-c-sharp-application[^]

这篇关于programitically通过c＃.net恢复mysql数据库备份文件（.sql）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！