[Cialug] MySQLDump - What DB contains a table?

[khamil8686 at gmail.com]

Connect to it with MySQL workbench and you have a gui that’s easier to search. Otherwise you can ssh in and do ‘show databases’, ‘use <database name>’ and ‘show tables’ commands

From: L. V. Lammert
Sent: Thursday, July 20, 2017 10:57 AM
To: Central Iowa Linux Users Group
Subject: [Cialug] MySQLDump - What DB contains a table?

Having a problem with a backup, .. but mysqldump only shows the table
name - how does one find the database that contains "siteber"?

-- Retrieving table structure for table sitebar_visit...
-- Sending SELECT query...
-- Retrieving rows...
mysqldump: Got error: 1153: Got a packet bigger than 'max_allowed_packet'
bytes when using LOCK TABLES

(Tried increasing max_allowd_packet to 128M, but still get the error, so I
just need to skip that database for now.)

	Lee
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug