MySQL Forums
Forum List  »  Install & Repo

MySQL 5.5 Drops database after some days of use
Posted by: kostas .
Date: February 14, 2014 06:04AM

Hi,
we use the installshield to install Mysql Server 5.5, Connector ODBC 3.51, MySQL Connector Net 6.4.4 and finally our .Net website in order to get it connect to mysql.

Also, we create the database (tables,data) through installshield scripts using the mysql.exe as following:

mysql.exe --user=root --password= <path to mysql script file>

Everything goes well and the website is up and running. However, after some days the database is dropped and the physical database folder is missing from C:\ProgramData\MySQL\MySQL Server 5.5\data folder. The website opens with an error: Unknow database <database name>

Notice that this is not consistent and happened only a few times, so we cannot reproduce it anytime we want.

One thing we thought that it has to do with the root user without password in mysql.exe parameters. Another thing is that odbc driver or .net connector drops the database because it has been created by root user account who do have the "drop" privilege.

Could you imagine what should be the problem?
Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.5 Drops database after some days of use
February 14, 2014 06:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.