Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment
PREVIOUS NEXT
Code Example
Sql :: stuff in sql 
Sql :: year format in date mysql 
Sql :: sql double quotes in string 
Sql :: mac mysql this is incompatible with sql_mode=only_full_group_by 
Sql :: with transaction.atomic(): 
Sql :: between in sql 
Sql :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small 
Sql :: sql and or 
Sql :: sql from 
Sql :: SQL SELECT-Klausel 
Sql :: sql query to linq converter online 
Sql :: insert update sql server 
Sql :: iterative instruction sql 
Sql :: varchar2 length in oracle 
Sql :: knex last insert id mysql 
Sql :: Insert into Select * - NAYCode.com 
Sql :: sysdatetimeoffset 
Sql :: oracle apex call duration 
Sql :: where in clause tsql 
Sql :: SQL Primary Key single column 
Sql :: sql after date 
Sql :: shows all databases created by user in ms sql 
Sql :: mssql get running queries by spid 
Sql :: Provera dupliranih konatakata 
Sql :: show tables in oracle 
Sql :: REFRESH command materialized view pgadmin example 
Sql :: debian 10 install postgresql 2ndquadrant 
Sql :: child row: a foreign key constraint fails 
Sql :: oracle max field name length 
Sql :: resullt all update knex mysql 
ADD CONTENT
Topic
Content
Source link
Name
1+2 =