Sql

mysqldump -u username -p databasename > database_backup.sql

#Take backup of database
mysqldump database > backup-file.sql; 

#Restore database
mysql database < backup-file.sql;

mysqldump database_name > database_name.sql

mysqldump database_name > backup_name.sql

PREVIOUS	NEXT

Code Example
Sql :: sql if clause within where clause
Sql :: install postgresql 10 centos 7
Sql :: mysql if condition
Sql :: sql create database
Sql :: postgresql stored procedure update table values
Sql :: mysql regexp match word
Sql :: spring boot working with sql database connection
Sql :: convert multiple columns to rows in sql server
Sql :: como saber si tengo mysql instalado
Sql :: inner join distinct
Sql :: mysql get last 2 month data
Sql :: android studio SQLiteDatabase delete all data in database
Sql :: delete db postgres
Sql :: how to set a column as unique in sql server
Sql :: alter table mysql
Sql :: postgres top 10
Sql :: power bi dax is in the last 3 months
Sql :: drop CHECK constraint sql
Sql :: q operator in oracle
Sql :: sub query in linq
Sql :: mysql get date from datetime
Sql :: df to sql pandas sql achemy
Sql :: c# select Mysql
Sql :: how to find unique element in sql
Sql :: sql online compiler
Sql :: count occurrences sql
Sql :: sql string function update replace
Sql :: how to truncate foreign key constraint table
Sql :: array of objects sql
Sql :: truncate table in sql