.Net Problem with mysql database

[shamwaghmare]

Hi I new to deployment can you please guide me through this

I am using VS 2005 and mysql 5

Client is asking for in the installation following things should happen

1) silent Installation of mysql server with predefined password so user can not know it.
2)Automatic restoration of mysql database

What will be the procedure to this .


Thanks in Advance

[Cosmin]

Hi,

silent Installation of mysql server with predefined password so user can not know it.

This can be done by adding MySQL Server as a prerequisite for your package. Please note that the User Guide contains a tutorial which may help you. In order to install MySQL Server silently, you can use a custom command line for its package in the Properties tab of the "Edit Prerequisite" dialog.

Unfortunately the MySQL server installation package doesn't support specifying the password from the command line. However, you can try using a BAT file as a custom action to set the password after MySQL server is installed.

Automatic restoration of mysql database

For this you can try using the SQL Scripts feature. Please note that the User Guide contains a SQL Scripts tutorial which may help you.

Regards,
Cosmin