[Cialug] MySQLDump - What DB contains a table?

[David Champion]

You can also peruse your mysql files, usually /var/lib/mysql and find what
folder (database) that table is in.

-dc


On Thu, Jul 20, 2017 at 11:02 AM, Josh More <jmore at starmind.org> wrote:

> 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
> >
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>