[Cialug] MySQLDump - What DB contains a table?

L. V. Lammert lvl at omnitec.net
Thu Jul 20 15:56:58 UTC 2017


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


More information about the Cialug mailing list