Search
 
SCRIPT & CODE EXAMPLE
 

SQL

import dump mysql

mysql -u username -p database_name < file.sql
Comment

database dump mysql command

mysqldump -u username -p dbname > filename.sql
Comment

database dump mysql command

mysql -u username -p dbname < filename.sql
Comment

import mysql dump command line

mysql -u username -p database_name < file.sql
Comment

database dump mysql command

mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql
Comment

import mysql dump database command line linux

mysql -u<user_name> -puser_password> <database_name>
source /path/db.sql
Comment

import mysql dump command line

mysql> use db_name;
mysql> source backup-file.sql;
Comment

import mysql dump

tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database
Comment

PREVIOUS NEXT
Code Example
Sql :: sql date format 
Sql :: mysql auto increment after delete 
Sql :: sql concat 
Sql :: date sql get the last week count 
Sql :: read all columns of a table sql 
Sql :: sql server change schema of a table 
Sql :: oracle add time to date 
Sql :: update table from another table 
Sql :: how to select unique element in sql 
Sql :: postgres create column with default value 
Sql :: how to insert json value in mysql 
Sql :: SQL NOT BETWEEN Operator 
Sql :: CONVERT time string into 12 hours in sql 
Sql :: get column types SQL SERVER 
Sql :: sql datetime format 
Sql :: mysql récupérer le code création de vue 
Sql :: mysql update column to be nullable 
Sql :: change data type postgresql 
Sql :: mysql grant all on all databases 
Sql :: import sql dump into postgresql database 
Sql :: mysql remove first and last character from string 
Sql :: oracle shrink table 
Sql :: remove auto increment mysql 
Sql :: select distinct postgres 
Sql :: how to add month in update sql 
Sql :: data formate in sql 
Sql :: FIND AVERAGE SALARY EARNER IN SQL 
Sql :: mysql find duplicates 
Sql :: htaccess allow index 
Sql :: INITCAP in Oracle example 
ADD CONTENT
Topic
Content
Source link
Name
5+9 =