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

9 votes208 views3 answers
Find all tables with column name
SQL
5 votes188 views1 answer
How to check nls timestamp format in oracle
SQL
8 votes243 views1 answer
Oracle add datafile to tablespace
SQL
0 vote241 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote184 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote261 views3 answers
Characters found after end of sql statement
SQL
0 vote183 views1 answer
Mysql database is not starting in xampp
SQL
0 vote204 views1 answer
Mysql change innodb to myisam
SQL
0 vote188 views1 answer
Mysql convert charset
SQL
0 vote196 views1 answer
How to find username and password in oracle 18c
SQL