[Edvin]

Hey

I have a big problem with my mysql database. Few days ago, it starts to auto-deleting, and I don't know the reason. I don't gave to anyone database infos, like: password, databasename and host.

I don't use any syntaxes like: "DROP", or something to affect tables.

What can cause this?

[doreto]

Did you have mysql log from this days were you thing is deleting ? that really will help solve the problem

[playbox12]

Change the password to your database and see if it happens again. There is not such thing as auto deletion, it must be caused by someone deliberately executing a delete query.

[Edvin]

@doreto i have logs, when this think happen' i put mysql_debug, and i found something ... suspect?

Код:

mysql_query( "DELETE FROM `DM_Event`", THREAD_NONE );

And when this query have been actioned, in debug.txt show me this:

Код:

[10:39:50] CMySQLHandler::Query(DELETE FROM `DM_Event`) - An error has occured. (Error ID: 1146, Table 'zp_26221.DM_Event' doesn't exist)

... This can cause that? I don't know, but ...

@playbox12 Yes, now i changed my DB password, hope this problem stop now ...