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 :: mysql group by date
Sql :: create delete procedure mysql
Sql :: sql end of month
Sql :: alter table add column in sql server
Sql :: mysql get first n characters of string
Sql :: postgres duplicate key value violates unique constraint already exists
Sql :: sql server add time to date
Sql :: alter column set not null to null postgres
Sql :: json with root element in sql server
Sql :: postgresql delete multiple rows
Sql :: oracle index hint
Sql :: postgres how to index a column
Sql :: get week day from date in sql
Sql :: mysql count multiple columns in one query
Sql :: insert snowflake
Sql :: increment integer in table sql
Sql :: oracle duration between timestamps
Sql :: set all auto_increment values in sql
Sql :: how to display value of variable in mysql
Sql :: sql not in
Sql :: how to select random rows from table
Sql :: sql having clause
Sql :: encrypt and decrypt in sql server
Sql :: how to find unique key in sql
Sql :: @firebase/database: FIREBASE WARNING: update at /users failed: permission_denied
Sql :: mysql case when in select
Sql :: how to create a table structure from another table in mysql
Sql :: sqlite insert if not exists
Sql :: sql values to array of objects
Sql :: pl sql case