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

6 votes171 views5 answers
Oracle list tablespaces
SQL
1 vote144 views1 answer
How to fetch alternate records from two tables
SQL
10 votes134 views5 answers
Create table mysql query
SQL
0 vote139 views1 answer
Mysql 8 geo to json
SQL
0 vote140 views1 answer
Postgres in operator with comma separated values
SQL
2 votes137 views1 answer
Postgresql add entry to table
SQL
0 vote147 views1 answer
Compress sql file database ubuntu
SQL
10 votes144 views4 answers
Mysql one week ago
SQL
11 votes132 views3 answers
How to get last row of table in sql
SQL
0 vote159 views1 answer
Sql basic commands
SQL