New answers tagged mysqldump
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
