Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql export and import

1. Export DB:
mysqldump -u root -p DB_NAME > 18_06_21.sql

2. import DB:
mysql -u root -h HOST_IP -p DB_NAME < 18_06_21.sql
Comment

PREVIOUS NEXT
Code Example
Sql :: check if string contains substring sql 
Sql :: java string to sql timestamp 
Sql :: show the colums of table sql 
Sql :: mysqldump ignore table 
Sql :: sql case 
Sql :: create index mysql 
Sql :: sql pagination offset 
Sql :: postgresql size of database 
Sql :: mysql to get column name in database 
Sql :: mysql terminal run sql file 
Sql :: install mysql 5.7 
Sql :: mysql group by range 
Sql :: oracle revoke 
Sql :: phone no data type in sql server 
Sql :: mysql change default collation 
Sql :: how to insert json value in mysql 
Sql :: add a day big query 
Sql :: sql line numbers 
Sql :: how to select distinct in mysql 
Sql :: mysql select date range last 30 days 
Sql :: sql command to show all tables 
Sql :: Parsing XML IN SQL Server 
Sql :: pyspark sql row get value 
Sql :: soql last week 
Sql :: date in oracle 
Sql :: upper case sql 
Sql :: convert polygon to text in mysql 
Sql :: sql formats 
Sql :: mysql repeated values 
Sql :: oracle dependencies table 
ADD CONTENT
Topic
Content
Source link
Name
3+1 =