I have a MySQL containing 12 databases, one which has 3 tables. I’ve looked in the docs to determine how to re-index and run maintenance on my databases and it leaves me cold.
Anyway I login at the console and:
show databases; ==>> DB showsuse <>; ==>> DB selectsshow tables; ==>> Tables showselect * from <>; ==>> No such tabledrop table <>; ==>> Table does not existdrop database <>; ==>> DB not empty drop tables tbl1, tbl2, tbl3
Need to run maintenance on the DB that either restores the DBs and Tables or purges the DB so I can rebuild my DB as several apps work from this table.