⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
sys_vars
/
r
/
View File Name :
general_log_func.result
drop table if exists t1; ## Creating new table ## CREATE TABLE t1 ( id INT NOT NULL auto_increment, PRIMARY KEY (id), name VARCHAR(30) ); '#--------------------FN_DYNVARS_018_01-------------------------#' ## Setting initial value of variable to OFF ## SET @@global.general_log = OFF; SELECT @@general_log; @@general_log 0 flush logs; SET @@global.general_log = ON; flush logs; SET @@global.general_log = OFF; ## Inserting some Records & Verifying output in log ## INSERT into t1(name) values('Record_1'); INSERT into t1(name) values('Record_2'); ## There should be no difference, case should pass ## '#--------------------FN_DYNVARS_018_01-------------------------#' ## Setting initial value of variable to OFF ## SET @@global.general_log = ON; SELECT @@general_log; @@general_log 1 ## Inserting some Records & Verifying output in log ## INSERT into t1(name) values('Record_3'); INSERT into t1(name) values('Record_4'); ## old log is a proper prefix of the new log ## SET @orig_file= load_file('MYSQLD_LOGFILE.orig'); SET @copy_file= load_file('MYSQLD_LOGFILE.copy'); SELECT @orig_file > @copy_file, left(@orig_file, length(@copy_file)) = @copy_file; @orig_file > @copy_file left(@orig_file, length(@copy_file)) = @copy_file 1 1 ## Dropping tables ## DROP TABLE t1;