A brief analysis of the game kimono memo problem

Today, after the game was restarted, I found that the data could not be imported into the target database after it was backed up.

mysql -h10.66.125.733 --port 3306 -u sanda -pX12234455 --default-character-set=utf8 sanda_s10 < /data/mysql/8/user.sql

return

ERROR 1044 (42000) at line 20: Access denied for user 'sanda'@'10.105.%' to database 'sanda_s10'

After checking, the following two permissions are missing:

mysql> grant LOCK TABLES on *.* to sanda@'10.105.%';
mysql> grant alter on *.* to sanda@'10.105.%';

Or grant all permissions

grant all privileges on *.* to 'sanda'@'%' identified by 'X12234455';
grant all privileges on *.* to 'sanda'@'%' with grant option;

2. When mysqldump was being run, when the data was exported more than halfway, the database network connection was disconnected, but the servo operator was not aware that the backup process had been interrupted. Since this was the first time we encountered such an exception, our servo tool needs to strengthen this prompt, and notify the servo operator of the disconnection exception in a timely manner. JAVA calls the system command without returning an error message, so we need to check.

3. Before merging each partition, check whether the disk is large enough for backup.

4.Support multiple areas on one page

5. From the client and server merging a table and sending a request to merge the next table, change it to the server merging a table and broadcasting it to the client, so that there will be no problem even if the connection is disconnected

6. If the primary key conflicts, ignore this item and it will not affect the subsequent execution

Summarize

The above is all the content of this article on the brief analysis of the game kimono memo issue. I hope it will be helpful to everyone. If you have any questions, please leave a message at any time and the editor will reply to you in time. Friends are welcome to refer to other related topics on this site.