[Cialug] MySQLDump - What DB contains a table?

[Josh More]

An inefficient way to do it is to do a mysqldump on all databases and then
grep the resulting SQL file.

It will, however, avoid any "max allowed" problems.

-Josh

On Thu, Jul 20, 2017 at 10:56 AM, L. V. Lammert <lvl at omnitec.net> wrote:

> 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
>