Installing databases after installation of server.

Question

Hello,

I my software (coded in C# .NET ) I need the client to install a database server (MySQL in my case). I'm deploying the setup and making user install it like a pre-requisite.

After installing the DBMS server. I need to setup databases (that I created) on the client machine. How to do this automatically (as part of installation.)?

Answer 1

if you know username and password, you can run cmd to restore database from dump file

mysql -u #username# -p #database# < #dump_file#