提权

mysql -u root -p53dc4f31c941b104

mysqldump -u server -pRahcw7LK3Na22bXK server XT1RY > /www/wwwroot/xt/dbsql/XT1RY.sql ;

‘Xt1Arh’, ‘XT1RY’, ‘XT1TH’, ‘Xt1THA’, ‘Xt1THB’, ‘XT1XC’,
‘Xt1XCA’, ‘Xt1XCB’, ‘Xt2Arh’, ‘XT2RY’, ‘XT2TH’, ‘XT2XC’, ‘XT2XT’

mysqldump -u server -pRahcw7LK3Na22bXK server Xt1Arh | gzip > /www/wwwroot/xt/dbsql/bu.sql.gz ;

mysqldump -u server -pRahcw7LK3Na22bXK server XT1TH > /www/wwwroot/xt/dbsql/XT1TH.sql ;

mysqldump -u server -pRahcw7LK3Na22bXK server Xt1THA > /www/wwwroot/xt/dbsql/Xt1THA.sql ;

mysqldump -u server -pRahcw7LK3Na22bXK server Xt1THB > /www/wwwroot/xt/dbsql/Xt1THB.sql ;
mysqldump -u server -pRahcw7LK3Na22bXK server XT1XC > /www/wwwroot/xt/dbsql/XT1XC.sql ;

mysqldump -u server -pRahcw7LK3Na22bXK server Xt1XCA | gzip > /www/wwwroot/xt/dbsql/Xt1XCA.sql.gz ;
mysqldump -u server -pRahcw7LK3Na22bXK server Xt1XCB | gzip > /www/wwwroot/xt/dbsql/Xt1XCB.sql.gz ;
mysqldump -u server -pRahcw7LK3Na22bXK server Xt2Arh | gzip > /www/wwwroot/xt/dbsql/Xt2Arh.sql.gz ;
mysqldump -u server -pRahcw7LK3Na22bXK server XT2RY | gzip > /www/wwwroot/xt/dbsql/XT2RY.sql.gz ;

mysqldump -u server -pRahcw7LK3Na22bXK server XT2TH | gzip > /www/wwwroot/xt/dbsql/XT2TH.sql.gz ;
mysqldump -u server -pRahcw7LK3Na22bXK server XT2XC | gzip > /www/wwwroot/xt/dbsql/XT2XC.sql.gz ;
mysqldump -u server -pRahcw7LK3Na22bXK server XT2XT | gzip > /www/wwwroot/xt/dbsql/XT2XT.sql.gz ;

导出好多表：

mysqldump -u server -pRahcw7LK3Na22bXK server Xt1Arh XT1RY | gzip > mydb1.sql.gz

mysqldump -u server -pRahcw7LK3Na22bXK server XT3RY XT3TH XT3XC | gzip > mydb3.sql.gz
mysqldump -u server -pRahcw7LK3Na22bXK server XT4RY XT4TH XT4XC | gzip > mydb4.sql.gz

导入数据库：
mysql -u xtserver -pGGjkLf4ycxk55xzD xtserver < XT1RY.sql

压缩文件导入数据库：
gunzip -c Xt2Arh.sql.gz | mysql -u xtserver -pGGjkLf4ycxk55xzD xtserver

mysql -u xtserver -pGGjkLf4ycxk55xzD xtserver
mysql> source XT1RY.sql;

mysql -u xtserver -pGGjkLf4ycxk55xzD --force < XT1RY.sql

gunzip -c Xt1XCB.sql.gz | mysql -u xtserver -pGGjkLf4ycxk55xzD xtserver

导入不成功 ‘Xt1Arh’, ‘XT1RY’,

导入成功 Xt1THA ，XT1TH，Xt1THB,XT1XC

TSPDB
XT1RY
XT1TH
XT1XC
XT2RY
XT2TH
XT2XC
XT2XT
XT3RY
XT3TH
XT3XC
XT4RY
XT4TH
XT4XC
XTYR
Xt1Arh
Xt1THA
Xt1THB
Xt1XCA
Xt1XCB
Xt2Arh
point

删除表
TRUNCATE TABLE XT4RY;
TRUNCATE TABLE XT4TH;
TRUNCATE TABLE XT4XC;

删除之前的数据：
START TRANSACTION;
DELETE FROM Xt1Arh WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT1RY WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT1TH WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM Xt1THA WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM Xt1THB WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT1XC WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM Xt1XCA WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM Xt1XCB WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM Xt2Arh WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT2RY WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT2TH WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT2XC WHERE time < ‘2024-01-01 00:00:00’;
DELETE FROM XT2XT WHERE time < ‘2024-01-01 00:00:00’;
COMMIT;

分区

DELIMITER $$ – 设定分隔符，以便使用多行 SQL 语句

CREATE EVENT auto_add_partitions
ON SCHEDULE EVERY 1 YEAR
STARTS ‘2025-01-01 00:00:00’
DO
BEGIN
– 为每个表添加新的分区（假设2025年开始）
ALTER TABLE Xt1Arh ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT1RY ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT1TH ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE Xt1THA ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE Xt1THB ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT1XC ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE Xt1XCA ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE Xt1XCB ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE Xt2Arh ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT2RY ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT2TH ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT2XC ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
ALTER TABLE XT2XT ADD PARTITION (PARTITION p2025 VALUES LESS THAN (2026));
END $$ – 结束事件体

DELIMITER ; – 恢复默认分隔符

1. 查看事件列表
   你可以使用 SHOW EVENTS 命令查看当前数据库中的所有事件，包括 auto_add_partitions：

sql
SHOW EVENTS;