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 :: how to retrive the today date sql
Sql :: mysql record group by created date count
Sql :: how to generate a unique random number in mysql
Sql :: update table from another table
Sql :: sql change a colum to unique
Sql :: mysql update with join
Sql :: how to drop function in sql
Sql :: how to check grants on a package in oracle
Sql :: mysql two column combination unique
Sql :: postgresql combine values in one field
Sql :: oracle number to percentage
Sql :: get column types SQL SERVER
Sql :: sql groub by count
Sql :: mysql add column to table
Sql :: change filed order in mysql
Sql :: brew start postgres
Sql :: how to lock table in mysql
Sql :: oracle apex debug time
Sql :: activate event scheduler mariadb
Sql :: como saber si tengo mysql instalado
Sql :: regexp in mysql
Sql :: sql server to uppercase
Sql :: mariadb date equals to current_date plus days
Sql :: sql count total by foreign key
Sql :: sql insert column
Sql :: average salary in sql
Sql :: createdb with postgresql on ubuntu
Sql :: open postgresql.conf
Sql :: mysql max
Sql :: to_char oracle