Page 1 of 1

Restore database from file ?

Posted: Fri 09 Dec 2005 09:51
by lm
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..

hmm

Posted: Fri 09 Dec 2005 13:23
by lm
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.

Posted: Fri 09 Dec 2005 14:18
by Serious
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.