| 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 : |
# Created: 2015-05-15 Lalit Choudhary -- source include/not_embedded.inc -- source include/big_test.inc --echo # --echo # WL#7755 mysqlpump: Extend mysqldump functionalities --echo # # Creating DB's and populating different types of data init for MYSQLPUMP testing. -- source include/mysqlpump_stmt.inc --echo # parallel-schemas option testing --exec $MYSQL_PUMP --parallel-schemas=3:db1 > $MYSQLTEST_VARDIR/tmp/output_file_1.sql --exec $MYSQL_PUMP --parallel-schemas=3:db1,db1_1gb --databases db1 db1_1gb > $MYSQLTEST_VARDIR/tmp/output_file_2.sql --exec $MYSQL_PUMP --parallel-schemas=3:db1 --parallel-schemas=db2,db3 --include-databases=db1,db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_3.sql --exec $MYSQL_PUMP --parallel-schemas=db3 --databases db1 > $MYSQLTEST_VARDIR/tmp/output_file_4.sql --exec $MYSQL_PUMP --parallel-schemas=1 --databases db2 > $MYSQLTEST_VARDIR/tmp/output_file_5.sql DROP DATABASE db1; DROP DATABASE db1_1gb; --exec $MYSQL < $MYSQLTEST_VARDIR/tmp/output_file_2.sql --exec $MYSQL_PUMP --parallel-schemas=2:db2,db1 --parallel-schemas=3:db3 --include-databases=db1,db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_6.sql --exec $MYSQL_PUMP --parallel-schemas=2:db3,db1 --parallel-schemas=1:db3,db1 --parallel-schemas=2:db3,db1,db1_1gb --include-databases=db1,db1_1gb,db3 > $MYSQLTEST_VARDIR/tmp/output_file_7.sql --exec $MYSQL_PUMP --default-parallelism=1 --parallel-schemas=db2,db3 --include-databases=db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_8.sql --exec $MYSQL_PUMP --default-parallelism=2 --parallel-schemas=4 > $MYSQLTEST_VARDIR/tmp/output_file_10.sql DROP DATABASE db2; DROP DATABASE db3; --exec $MYSQL < $MYSQLTEST_VARDIR/tmp/output_file_8.sql #--exec $MYSQL_PUMP --parallel-schemas > $MYSQLTEST_VARDIR/tmp/output_file_11.sql #--exec $MYSQL_PUMP --parallel-schemas= > $MYSQLTEST_VARDIR/tmp/output_file_12.sql #--exec $MYSQL_PUMP --parallel-schemas=string_edjdjh > $MYSQLTEST_VARDIR/tmp/output_file_13.sql # chrashing #--exec $MYSQL_PUMP --parallel-schemas=%&* > $MYSQLTEST_VARDIR/tmp/output_file_14.sql # default-parallelism option testing --exec $MYSQL_PUMP --default-parallelism=3 > $MYSQLTEST_VARDIR/tmp/output_file_16.sql --exec $MYSQL_PUMP --default-parallelism=0 > $MYSQLTEST_VARDIR/tmp/output_file_17.sql --exec $MYSQL_PUMP --single-transaction > $MYSQLTEST_VARDIR/tmp/output_file_18.sql --exec $MYSQL_PUMP --default-parallelism=3 --default-parallelism=1 --default-parallelism=2 > $MYSQLTEST_VARDIR/tmp/output_file_19.sql # mysqlpump: [ERROR] mysqlpump: option '--default-parallelism' requires an argument #--exec $MYSQL_PUMP --default-parallelism > $MYSQLTEST_VARDIR/tmp/output_file_20.sql # mysqlpump: [ERROR] mysqlpump: Empty value for 'default-parallelism' specified #--exec $MYSQL_PUMP --default-parallelism='' > $MYSQLTEST_VARDIR/tmp/output_file_21.sql #mysqlpump: [ERROR] Unknown suffix 's' used for variable 'default-parallelism' (value 'sgdhy7') #--exec $MYSQL_PUMP --default-parallelism='sgdhy7' --include-databases=db1 > $MYSQLTEST_VARDIR/tmp/output_file_22.sql # mysqlpump: [ERROR] mysqlpump: Error while setting value '#@' to 'default-parallelism' #--exec $MYSQL_PUMP --default-parallelism=#@&%* --include-databases=db1 > $MYSQLTEST_VARDIR/tmp/output_file_23.sql --remove_files_wildcard $MYSQLTEST_VARDIR/tmp/ output_file* # --result-file and --watch-progress --exec $MYSQL_PUMP --parallel-schemas=1:db1 --exclude-databases=mtr,mysql,sys,test --watch-progress 2>$MYSQLTEST_VARDIR/tmp/watch_progress_1.log --result-file=$MYSQLTEST_VARDIR/tmp/result_file_1.sql --exec $MYSQL_PUMP --parallel-schemas=2:db3 --exclude-databases=mtr,mysql,sys,test --watch-progress 2>$MYSQLTEST_VARDIR/tmp/watch_progress_2.log > $MYSQLTEST_VARDIR/tmp/result_file_2.sql DROP DATABASE db1; DROP DATABASE db2; DROP DATABASE db3; DROP DATABASE db1_1gb; --exec $MYSQL < $MYSQLTEST_VARDIR/tmp/result_file_1.sql DROP DATABASE db1; DROP DATABASE db2; DROP DATABASE db3; DROP DATABASE db1_1gb; --exec $MYSQL < $MYSQLTEST_VARDIR/tmp/result_file_2.sql --remove_file $MYSQLTEST_VARDIR/tmp/result_file_1.sql --remove_file $MYSQLTEST_VARDIR/tmp/result_file_2.sql # Cleanup DROP DATABASE db1; DROP DATABASE db2; DROP DATABASE db3; DROP DATABASE db1_1gb;