Mysqlimport

1. backup:
cd /backup
mkdir -p adir
chmod 1777 adir
mysqldump -Ffe db_name table_name --skip-add-locks --where="where_clause" --tab="adir"

2. restore:
cd /backup
mkdir -p adir
chmod 1777 adir
mysql -e "SET GLOBAL local_infile = 1"
mysqlimport --use-threads=8 -fik -v --local db_name table_name.txt

Similar codes

0 vote273 views1 answer
Oracle list proxy users
SQL
0 vote294 views1 answer
Sql pivot table
SQL
8 votes266 views1 answer
Oracle find text in functions
SQL
0 vote268 views1 answer
Query on date sqlite flutter
SQL
0 vote283 views1 answer
With_for_update sqlalchemy
SQL
11 votes301 views2 answers
How to import mysql database command line
SQL
0 vote270 views1 answer
TSQL function split string
SQL
0 vote283 views1 answer
Sql check for null and empty string
SQL
0 vote293 views1 answer
Set Mamp mysql globally
SQL
7 votes264 views3 answers
How to check table name in current database sql
SQL