SHOW DATABASES; 
SHOW {DATABASES | SCHEMAS}
    [LIKE 'pattern' | WHERE expr]

SHOW [EXTENDED] [FULL] TABLES
    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz] 

Простейший скрипт backup.sh

 $ ./backup.sh [название базы]

#!/bin/bash
 
if [ -z "$1" ]
  then
    echo "No argument supplied"
    exit 1
fi
mysqldump -u root -pDS5A-ws36-Y3cs $1 | gzip > $1.sql.gz

For Import:

gunzip < [compressed_filename.sql.gz]  | mysql -u [user] -p[password] [databasename] 

Note: There is no space between the keyword '-p' and your password.

use mysql; source pnagaev-db.sql show databases select * from databases; use liv2ryde1256 ; update user set authentication_string=PASSWORD(890-908–P3pa") where User='root'; flush privileges; SHOW GLOBAL STATUS LIKE 'Qcache%';