What does generated by server on drop tables mean

37 Views Asked by At

Hi i create a new table using phpmyadmin create table not query and suddenly all my tables are recreated by itself and lost all data i tried to check last binlog and i found some strange lines like this :

SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 57806
#220512 10:27:48 server id 1  end_log_pos 57965 CRC32 0xb94d36de    Query   thread_id=119584    exec_time=0 error_code=0    Xid = 4297955
SET TIMESTAMP=1652351268/*!*/;
DROP TABLE IF EXISTS `team_members` /* generated by server */
/*!*/;
# at 57965
#220512 10:27:48 server id 1  end_log_pos 58044 CRC32 0x043cb326    Anonymous_GTID  last_committed=100  sequence_number=101 rbr_only=no original_committed_timestamp=1652351268841270   immediate_commit_timestamp=1652351268841270 transaction_length=778
# original_commit_timestamp=1652351268841270 (2022-05-12 10:27:48.841270 UTC)
# immediate_commit_timestamp=1652351268841270 (2022-05-12 10:27:48.841270 UTC)
/*!80001 SET @@session.original_commit_timestamp=1652351268841270*//*!*/;
/*!80014 SET @@session.original_server_version=80029*//*!*/;
/*!80014 SET @@session.immediate_server_version=80029*//*!*/;
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 58044
#220512 10:27:48 server id 1  end_log_pos 58743 CRC32 0xebf54ace    Query   thread_id=119584    exec_time=0 error_code=0    Xid = 4297956
SET TIMESTAMP=1652351268/*!*/;
SET @@session.explicit_defaults_for_timestamp=1/*!*/;
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
CREATE TABLE `team_members`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tournament_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic
/*!*/; 

what does this mean ? and can i get my old data back from binlog ? I tried to get data from ibd but it seems the creation for tables again overwrite the old files

Notes that i create another table and the log contain same lines for all tables

0

There are 0 best solutions below