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 remove last character
Sql :: mysql get last day of month
Sql :: oracle turn off constraint
Sql :: if date is today mysql
Sql :: how to check last gather stats on table in oracle
Sql :: how to get list of synonyms in oracle
Sql :: revokeprivileges mysql
Sql :: rename table postgres
Sql :: start mysql server mac
Sql :: mysql your password does not satisfy the current policy requirements
Sql :: how to copy a table from one database to another in mysql
Sql :: install mysql server linux
Sql :: mysql not supported auth mode
Sql :: use cases condition in sql query laravel
Sql :: how to check data type in sql server
Sql :: show user mysql
Sql :: How to fetch data in between startfromdate to starenddate in sql
Sql :: mysql show column data types
Sql :: sqlite show columns in table
Sql :: autocommit mysql
Sql :: altering the column name in MySQL to have a default value
Sql :: pl sql dynamic sql drop doesnt work
Sql :: cursor in sql server
Sql :: sql query with replace function
Sql :: postgresql show owner of database
Sql :: select * from table where name like
Sql :: c# get sql min date
Sql :: how to add column to table sql
Sql :: oracle sql day of month from date
Sql :: how to print longest name in sql