By mouse77e on 
SQL query:

-- -- Dumping data for table `cache_views` -- INSERT INTO `cache_views` (`cid`, `data`, `expire`, `created`, `headers`) VALUES ('views_tables:en', 0x613a343a7b733a363a227461 [...]

MySQL said: Documentation
#1153 - Got a packet bigger than 'max_allowed_packet' bytes

Hi, I am getting around to upgrading a D5 site to D6 - (don't ask) but when i try to import the DB into MAMP/PHPMyAdmin I get this message.

So can i trim the table in some way?

I have dried dropping the table, emptying it, and I then end up with a local site that says it is in Maintainance mode but cannot be logged into either the /user way or by tweaking the DB…

Any isedas?

⋅ Categories: Drupal 6.x

Comments

Anonymous’s picture

Anonymous (not verified) commented

you might want to empty all caching tables and or watchdog table, then optimize your database tables, before exporting your database.

this can reduce your DB site significant

sreyas’s picture

sreyas commented

cache tables in drupal database has many junk variables. Its difficult to import when these tables has data. Better you clear these tables, so that when you export the database, its a lot more smaller. I would suggest two things prior to exporting

1. Clear drupal cache from admin/settings/performance.
2. Truncate all the tables starting with cache TRUNCATE `cache_views`;

Please give it a try and let us know.

Regards
Ciril
Sreyas IT Solutions
Drupal Server Administration

------------------
Ciril Sreedhar
Sreyas IT Solutions
Server Administration | Web Designing | Web Programming

mouse77e’s picture

mouse77e commented

Despite having Cleared the cache before downloading the DB to the local host - using your method worked wonders - many thanks!