tables

Dump MySQL Database but Skip Some Table(s)

2019-11-24 · 1 min read · mysql mariadb tables dump cli mysqldump database ·

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/

Count Number of Tables in a MySQL Database

2018-10-15 · 1 min read · mysql mariadb tables count ·

Share on:

1mysql> select distinct(TABLE_SCHEMA) from information_schema.tables; 2+--------------------+ 3| TABLE_SCHEMA | 4+--------------------+ 5| information_schema | 6| drcongo | 7| mysql | 8| performance_schema | 9| pseademo | 10| pseairaq | 11| sys | 12+--------------------+ 1314mysql> select count(*) from …

Drush: Drop Mysql Tables Without Deleting Database

2018-04-09 · 1 min read · drupal drush tables mysql database sql ·

Share on:

In drupal root: 1drush sql-drop