HELP - MySQL at full load!
 

Hi, I have a problem!

I installed this plugin: Restore Posts and Threads of Deleted User.

https://vborg.vbsupport.ru/showthread.php?t=242229

I made a mistake and instead of entering the id of the destination user, I entered his nickname ...

Now I have MySQL burdened by this query:

UPDATE post
SET userid = 'nickname2'
WHERE username = 'nickname1';

There is no way to end it. I restarted Apache and MySQL, I rebooted the server, I have kill (KILL, KILL QUERY) the query to MySQL after reading processes with SHOW PROCESSLIST, but the query always returns.

I noticed that MySQL returns free when Apache is stopped. This could mean that the query returns because it is buffered in Apache or PHP. How can I do to clear this buffer?

How to solve this bizarre case?

If you have a recent backup i would start by restoring it.

Hi Marco, thanks very much for your reply.

I tried to restore the database, but I get the following error:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1

The database backup is performed by the script vb_backup.sh of vB 3.8.4, and the restore with SSH and the command 'mysql':

dbusername mysql -u root -p databasename < backupname.sql

We have this MySQL server:

Server version: 5.1.45 MySQL Community Server (GPL)

Any ideas?

--------------- Added [DATE]1275782688[/DATE] at [TIME]1275782688[/TIME] ---------------

Okay, to make usable the backup I had to remove the first line, which consisted of a warning:

Warning: The option '--all' is deprecated and will be removed in a future releas

It is probably added by mysqldump at the time to create the file .sql

Alright, thanks.