My MySQL database are deleting ...
#1

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?
Reply
#2

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

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.
Reply
#4

@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 ...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)