The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
If you have a recent backup i would start by restoring it.
|
#3
|
|||
|
|||
Quote:
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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|