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 vote129 views2 answers
How to get max from each department in sql
SQL
2 votes125 views1 answer
Postgresql drop primary key constraint
SQL
0 vote144 views1 answer
Sp help text in postgresql
SQL
1 vote129 views2 answers
Insert sqlite
SQL
0 vote106 views1 answer
In mysql workbench contnent not feching
SQL
3 votes156 views2 answers
@sqlresultsetmapping
SQL
0 vote194 views1 answer
Mssql unique key accept nulls
SQL
3 votes113 views4 answers
Psql list tables in schema
SQL
6 votes181 views2 answers
Database url postgres
SQL
18 votes134 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL