Horje
mysqldump Code Example
database dump mysql command 
mysqldump -u username -p dbname > filename.sql
mysqldump 
# Syntax
mysqldump -u [username] -p [database-to-dump] > [database-to-receive]

# Pipe it! Exporting DB from external host
mysqldump -u [username] -P [port] -h [host] [database-to-dump] | mysql -u root -h 127.0.0.1 [database-to-receive]

# Export specific tables by typing the name after the targeted DB
mysqldump -u [username] -P [port] -h [host] [database-to-dump] [tabl1] [table2] [table3] | mysql -u root -h 127.0.0.1 [database-to-receive]
mysqldump with WHERE clause 
$> mysqldump -umy_user_name -p database_name  --tables my_table1 --where="date_created > '2016-01-01' " > mytable1_filtered_dump.sql
Source: idiallo.com
install mysqldump 
# Mysql
sudo apt-get install mysql-client
# MariaDB
sudo apt-get install mariadb-clients
mysqldump 1 table only 
mysqldump db_name table_name > table_name.sql
Source: stackoverflow.com
mysqldump - date 
mysqldump -u <user> -p <database> | bzip2 -c > <backup>$(date +%Y-%m-%d-%H.%M.%S).sql.bz2
Source: stackoverflow.com



Shell

Related
ngx-bootstrap npm Code Example ngx-bootstrap npm Code Example
run spec file using pyinstaller Code Example run spec file using pyinstaller Code Example
diff from last commit Code Example diff from last commit Code Example
sudo snap linux store Code Example sudo snap linux store Code Example
git force rebase abort Code Example git force rebase abort Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 12



 

Horje