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

4 votes362 views1 answer
Restart for pg_hba.conf file
SQL
8 votes348 views1 answer
Unique vs primary key
SQL
0 vote332 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote348 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote352 views1 answer
Laravel eloquent get generated sql
SQL
0 vote379 views1 answer
Sql server information_schema temp tables
SQL
0 vote564 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote438 views1 answer
Why do we need data structure in sql
SQL
0 vote335 views1 answer
MySql count occurences more than"
SQL
0 vote449 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL