Sql

mysqldump -u username -p database_name > data-dump.sql

mysqldump -u username -p dbname > filename.sql

mysql -u username -p dbname < filename.sql

mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql

mysqldump -u username -p --skip-lock-tables database_name > path/filename.sql

tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database

 docker exec -i 082158cc76d3 mysqldump -u root --password=password db_django > backup.12_may_2022.sql

PREVIOUS	NEXT

Code Example
Sql :: mysql get time from datetime
Sql :: mysql last day of next month
Sql :: sql alter table add column if exists
Sql :: sql database size
Sql :: oracle table statistics
Sql :: create table if not exist in sqlite
Sql :: mysql random limit 1
Sql :: how to change table name in sqlite
Sql :: start mysql server
Sql :: oracle current date without time
Sql :: name of today sql
Sql :: get date from now() mysql
Sql :: how to update an attribute in MySQL
Sql :: install mysql workbench ubuntu 20.04 terminal
Sql :: sql pick random row
Sql :: Unit mysql.service could not be found.
Sql :: oracle next run dates
Sql :: what is meant by trigger in dbms
Sql :: sqlite print all column names
Sql :: sql find column name like
Sql :: check sql database table lock
Sql :: mysql bidirectional composite primary key
Sql :: bigquery get current date
Sql :: python mysql check if database exists
Sql :: Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
Sql :: mysql cli connect with password
Sql :: mysql case when null
Sql :: mysql tinyint max value
Sql :: select count from table mysql
Sql :: copy one column data to another in sql