Restore database from file ?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply

Restore database from file ?

Post by lm » Fri 09 Dec 2005 09:51

Hi guys :)

I have exported my database to a file.sql and i works like a charm.

But how do I restore/overwrite it from the file ? I guess I have to use the .Restore() ?..

Code exam. is appreciated :)

thank you..



Post by lm » Fri 09 Dec 2005 13:23

Hmm. If I export the database with the sample code, and then imports it again, I can't load the database to my datagrid anymore ?

I guess my problem is kinda complex.. damnit.


Post by Serious » Fri 09 Dec 2005 14:18

If you have a sql query and want to execute it (even if it consists of many sdq statements) you can use MySqlScript component. See class reference in MySQLDirect .NET documentation for additional information and sample code for this class. You can also use designer features of this component to become familiar with its functionality.

Post Reply