Sql

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

mysql -u username -p database_name < file.sql

mysql -u username -p database_name < file.sql

mysql> use db_name;
mysql> source backup-file.sql;

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

PREVIOUS	NEXT

Code Example
Sql :: mysql insert multiple rows based on select
Sql :: migrations.RunSQL
Sql :: mysqldump
Sql :: mysql split explode
Sql :: sql check
Sql :: Example SQL Test
Sql :: fanyi
Sql :: how to join result table in mysql
Sql :: alter in mysql
Sql :: mysql drop tables
Sql :: oracle sysdba connect as another user
Sql :: mariadb errno 121
Sql :: how to find symmetric pairs in sql
Sql :: grant privileges mysql to database 1064
Sql :: rasa mysql connection custom actions example
Sql :: how to get one year old query from plan cache
Sql :: hive hbase create external table
Sql :: formatting code with SQL Developer
Sql :: MySQL Age Counter
Sql :: t-sql update table variale
Sql :: ring MySQL create new table and insert records
Sql :: oracle dbms scheduler repeat interval every 5 minutes
Sql :: virtuoso sql query tutorial
Sql :: automated psql csv export script on windows
Sql :: missing index on mssql rds database
Sql :: sql gather statistics to increase performance
Sql :: mysql config slave
Sql :: dump only schema
Sql :: dump a single table named mytab
Sql :: database traccar