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 vote364 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote371 views1 answer
Oracle remove line breaks
SQL
0 vote362 views1 answer
Select row with latest date mysql
SQL
7 votes370 views1 answer
Mysql iif
SQL
0 vote365 views1 answer
How to change null display in psql
SQL
1 vote364 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote341 views1 answer
Postgresql conectar
SQL
5 votes339 views1 answer
Oracle asynchronous query
SQL
5 votes347 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote396 views1 answer
Recently updated stored procedure in sql server
SQL