Appears tables are missing from database backup (difference between Flex 4 and 5)

Follow

Norm Schaeffer

• December 27, 2021 17:58

I was reviewing how to design custom reports from the FAQ. I am running MySQL 5.7. I downloaded one of our backups from Flex 4 backup history and dumped it into the MySQL instance running on my local machine.

The FAQ mentions (and shows in a figure) an st_ivt_inventory_item table and st_ivt_serial_number table. Neither of these tables are shown in the schema I am viewing in the MySQL workbench or Jaspersoft. Are these tables (and other tables) available that I can run a query against?

0

• 

  Norm Schaeffer

  • December 27, 2021 18:17

  Additional info.... I output a logfile while unpacking the archive. There are many statements such as ERROR 1146 (42S02): Table 'company_name.st_ivt_inventory_item' doesn't exist,

  ERROR 1215 (HY000): Cannot add foreign key constraint
  Query OK, 0 rows affected (0.00 sec),

  ERROR 2006 (HY000): MySQL server has gone away
  No connection. Trying to reconnect...
  Connection id: 614
  Current database: company_name_reports

  ERROR 2006 (HY000): MySQL server has gone away
  No connection. Trying to reconnect...
  Connection id: 615
  Current database: company_name_reports

   

  0

  Comment actions Permalink
• 

  Norm Schaeffer

  • December 27, 2021 23:53

  ISSUE RESOLVED:

  Unpacking problem was with MySQL configuration. Needed to set:

  max_allowed_packet=64M

  default of 4M is inadequate for db of this size.

   

  0

  Comment actions Permalink

Please sign in to leave a comment.