Sql

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

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

mysqldump db_name table_name >  table_backup.sql

mysqldump database_name > database_name.sql

PREVIOUS	NEXT

Code Example
Sql :: sql calculate percentage
Sql :: sql check double value
Sql :: postgres set default value
Sql :: mysql between date range
Sql :: sql truncate statement
Sql :: phone number sql
Sql :: order by oracle
Sql :: mysql version query
Sql :: Configure postgresql engine for your django application
Sql :: column get from sql table
Sql :: oracle difference between two dates in seconds
Sql :: install mysql workbench ubuntu 20.04
Sql :: change date format in oracle query
Sql :: copy postgres table from one schema into another
Sql :: mysql add text to existing field
Sql :: select last 2 characters sql
Sql :: oracle insert or update
Sql :: how to change column name in sql
Sql :: creating a table in sql
Sql :: mysql case when on date
Sql :: multiple count in sql
Sql :: mysql create view full table
Sql :: check if database exists sql
Sql :: generate a random otp in sql server
Sql :: oracle sql pad left zeros
Sql :: mysql compare datetime to another datetime
Sql :: sql select most frequent value in column
Sql :: left join in codeigniter query builder
Sql :: oracle list grants on procedure
Sql :: CONVERT time string into 12 hours in sql