Open a database 1sqlite> .open test.db Show tables 1sqlite>.table 2n Shows that there is only 1 table named n. Check table schema 1sqlite> .schema 2CREATE TABLE n (id INTEGER PRIMARY KEY,f TEXT,l TEXT); Check contents of a table It's just the usual sql query commands as expected 1sqlite> select * from n; …

1mysqldump -u<username> -p<password> --no-create-db myDB --ignore-table=myDB.table1 --ignore-table=myDB.table3-h localhost > mysql.backup See https://tecadmin.net/tutorial/mysql/skip-tables-in-mysqldump/

1wp-config.php

1mysqldump -u<username> -p<password> --no-create-db myDB -h localhost > mysql.backup That way, it would strip the original database name and NOT become a problem when importing to another database name. See …

In drupal root: 1drush sql-drop

From CLI, ssh to specific server and go to: 1/mnt/files/[site].[dev | test | prod]/backups/

1drush sqlc < database.sql