| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/t/ |
Upload File : |
#------------------------------------------------------------------------------ # Test mysql_tzinfo_to_sql program against bundled zoneinfo files. # The mysql_tzinfo_to_sql program loads the time zone tables in the mysql # database. It is used on systems that have a zoneinfo database (the set of # files describing time zones). # Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One # likely location for these files is the /usr/share/zoneinfo directory # (/usr/share/lib/zoneinfo on Solaris) This test loads zoneinfo files from # std_data/zoneinfo to ensure stability. # usage: # 1] mysql_tzinfo_to_sql tz_dir # 2] mysql_tzinfo_to_sql tz_file tz_name # 3] mysql_tzinfo_to_sql --leap tz_file # Test aims loading zone tables in the mysql with above command. # Data is loaded into zone table from test_zone database instead of mysql # database. #------------------------------------------------------------------------------ --source include/not_windows.inc # no embeeded run --source include/not_embedded.inc # Create tables zone tables in test_zone database CREATE DATABASE test_zone; USE test_zone; CREATE TABLE time_zone as SELECT * FROM mysql.time_zone WHERE 1 = 0; CREATE TABLE time_zone_leap_second as SELECT * FROM mysql.time_zone_leap_second WHERE 1 = 0; CREATE TABLE time_zone_name as SELECT * FROM mysql.time_zone_name WHERE 1 = 0; CREATE TABLE time_zone_transition as SELECT * FROM mysql.time_zone_transition WHERE 1 = 0; CREATE TABLE time_zone_transition_type as SELECT * FROM mysql.time_zone_transition_type WHERE 1 = 0; --echo # Load zone table for Japanese zones. (mysql_tzinfo_to_sql std_data/Japan test_japan). --exec $MYSQL_TZINFO_TO_SQL $MYSQLTEST_VARDIR/std_data/Japan test_japan >$MYSQLTEST_VARDIR/tmp/loadzonefile.sql --source $MYSQLTEST_VARDIR/tmp/loadzonefile.sql --echo # Load Moscow zone table with --leap option. (mysql_tzinfo_to_sql --leap std_data/Moscow_leap) --exec $MYSQL_TZINFO_TO_SQL --leap $MYSQLTEST_VARDIR/std_data/Moscow_leap >$MYSQLTEST_VARDIR/tmp/loadzonefile.sql --source $MYSQLTEST_VARDIR/tmp/loadzonefile.sql --echo # Load zone table files in Europe folder. (mysql_tzinfo_to_sql std_data/Europe) --exec $MYSQL_TZINFO_TO_SQL $MYSQLTEST_VARDIR/std_data/Europe >$MYSQLTEST_VARDIR/tmp/loadzonefile.sql --source $MYSQLTEST_VARDIR/tmp/loadzonefile.sql # Load timezone info file with garbage content --error 1 --exec $MYSQL_TZINFO_TO_SQL $MYSQLTEST_VARDIR/std_data/Factory test_junk_content # Cleanup DROP DATABASE test_zone; --remove_file $MYSQLTEST_VARDIR/tmp/loadzonefile.sql