New answers tagged

0

I have started the restore of the backup but for some reason i have not enable the log and also my session end. So how i will verify that restore was done successfully. It will almost certainly have failed. Without specific instruction to the contrary, ending your session forcibly kills any and all processes running within that session. Consider running the ...


0

The issue was using MySQLWorkbench 8.0.16 and mysqldump 8.0.19 which are both looking for performance_schema tables in MySQL 5.6, which only exist starting with MySQL 5.7. Updating MySQLWorkbench to 8.0.20 and using mysqldump with the flag --column-statistics=0 made the errors go away.


2

performance_schema.user_variables_by_thread is in MySQL-5.7 but not MySQL-5.6. It cannot be copied as its generated by the server to represent the internal state. MySQL-5.6 seems to have deprecated Jira support per https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html MySQL-5.7 reference on user_variables_by_thread


0

You can use this one for production It excludes 'performance_schema\|information_schema\|mysql\|sys'...modify for your needs MYSQL_USER= MYSQL_PASS= MYSQL_HOST= MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS} -h${MYSQL_HOST}" MYSQLDUMP_OPTIONS="--routines --triggers --single-transaction" DBLIST=`mysql -s --host=$MYSQL_HOST --user=$MYSQL_USER ...


4

PROPOSED SOLUTION DUMPFILE=mydump.sql grep "^USE " ${DUMPFILE} | sed 's/;//' | sed 's/`//g' | awk '{print $2}' EXAMPLE # grep "^USE " dump.sql | sed 's/;//' | sed 's/`//g' | awk '{print $2}' CR1281653 CR1289379 MasterDB ProjectDB TPLB23 a110107 a110107_copy cardfree_orders_lab mysql nulldatetest part_lab part_test partition_engine ...


1

You could do this (see test.sql sample file below): grep 'CREATE TABLE' my_dump_file_name.sql | wc Result: 2 8 54 The | (pipe) character feeds (pipes) the output of the grep into wc (not the wc!)! From man grep grep, egrep, fgrep - print lines that match patterns will give you lines of the the form CREATE TABLE `film_text` ( From man wc wc - ...


Top 50 recent answers are included