Unknown

SET @o:= (SELECT COUNT(*) FROM {tableName}) + 10; SET @n:= @o; UPDATE {tableName} SET {indexName} = @n:=@n+1 ORDER BY `{fieldName}` ASC; UPDATE {tableName} SET {indexName} = {indexName} - @o; ALTER TABLE {tableName} AUTO_INCREMENT=0;

show full processlist; ※ kill {id}

mysqldump -uroot -p {databaseName} -r {databaseFile.sql} --no-data※ option : --no-autocommit=1 --single-transaction=1 --extended-insert=1 CREATE DATABASE {newDatabaseName};USE {newDatabaseName};SOURCE {databaseFile.sql};CREATE USER {user} IDENTIFIED BY '{pass}';GRANT ALL ON {newDatabaseName}.* TO '{user}'@'localhost' IDENTIFIED BY '{pass}';GRANT ALL ON {newDatabaseName}.* TO '{user}'@'%' IDENTIF..