[Cialug] MySQLDump - What DB contains a table?

[David Champion]

Google search your error...

https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes

-dc


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

> On Thu, 20 Jul 2017 khamil8686 at gmail.com wrote:
>
> > 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
> >
> Command line is not that simple when there are 50 databases on the
> machine <g>!!, ... turns out the simplest way is to locate the filename
> for that table! (That particular database is ancient.)
>
> Unfortunately, after removing that database directory (which actually
> works really well, btw), .. I find another error in a database that is in
> use now:
>
> -- Retrieving table structure for table schema_info...
> -- Sending SELECT query...
> -- Retrieving rows...
> -- Retrieving table structure for table zip_codes...
> -- Sending SELECT query...
> -- Retrieving rows...
> mysqldump: Got error: 1153: Got a packet bigger than 'max_allowed_packet'
> bytes when using LOCK TABLES
>
> Interestingly enough, looking at the table directly shows no errors:
>
> mysql> describe zip_codes;
> +----------+--------------+------+-----+---------+----------------+
> | Field    | Type         | Null | Key | Default | Extra          |
> +----------+--------------+------+-----+---------+----------------+
> | id       | int(11)      | NO   | PRI | NULL    | auto_increment |
> | zip_code | varchar(255) | YES  |     | NULL    |                |
> +----------+--------------+------+-----+---------+----------------+
> 2 rows in set (0.01 sec)
>
> select * from zip_codes shows 540 zip codes.
>
> Seems like something else is happening, .. ??
>
>         Thanks!
>
>         Lee
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
>