40 lines
586 B
Markdown
40 lines
586 B
Markdown
# mysql
|
|
|
|
## dump
|
|
|
|
```bash
|
|
DB_HOST="127.0.0.1"
|
|
DB_NAME="dbname"
|
|
DB_USER="dbuser"
|
|
DB_PASSWORD="123456"
|
|
TARGET_FILENAME=${DB_NAME}_dump_$(date -d "today" +"%Y%m%d%H%M%S").sql
|
|
mysqldump -v -h $DB_HOST --user=$DB_USER -p"$DB_PASSWORD" $DB_NAME > $TARGET_FILENAME
|
|
```
|
|
|
|
## Import
|
|
```bash
|
|
mysql -uroot -p database_name < file.sql
|
|
```
|
|
|
|
## Misc
|
|
```bash
|
|
|
|
#list databases
|
|
show databases;
|
|
|
|
#use database;
|
|
use <DATABASE NAME>;
|
|
|
|
#list tables
|
|
show tables;
|
|
|
|
# list users
|
|
SELECT user, host FROM mysql.user;
|
|
|
|
# grant all permisions
|
|
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;
|
|
|
|
```
|
|
|
|
|