I was trying to import a 115MB database via Local WP’s Adminer tool, and I kept getting the following error:
Error in query (1153): Got a packet bigger than 'max_allowed_packet' bytesAfter a lot of trial and error, the solution was to:
- Update the “max_allowed_packet” variable in Local Sites->[site name]->conf->mysql->my.cnf.hbs to max_allowed_packet = 1000M
- Add/update the “max_allowed_packet” variable in Local Sites->[site name]->conf->php->php.ini.hbs to max_allowed_packet = 1000M
- In Local WP, click “Stop Site” then “Start Site”
That’s it!
From Toby’s Blog
- Fortify Your WordPress Site: Essential Security StepsSecuring your WordPress site is a critical component of maintaining your online presence and safeguarding your data. Security is no longer a luxury, it has become a necessity in today’s digital world, where threats are lurking at every corner. This piece dives deep into WordPress security basics, giving you a comprehensive understanding of common vulnerabilities…
- Master Your Site: Customizing WordPress ThemesJust as a house is more than bricks and mortar, a WordPress site is much more than simple code. It’s a cohesive structure built with various layers such as PHP, HTML, CSS, and other key elements. Customizing WordPress themes involves gaining an in-depth understanding of this structure, learning to inspect and adjust design elements with…
- Mastering WordPress Basics for Beginners within HoursWelcome to the world of WordPress, a widely used Content Management System (CMS) that powers millions of websites worldwide. Being immensely flexible and user-friendly, WordPress offers an endless scope to create, manage, and customize your website according to your needs and preferences. In this segment, we attempt to introduce you to the basics of WordPress,…
More posts from themightymo.com
How to optimize your Google Crawl Budget using SEM Rush Log File Analyzer and Rank Math SEO
Today I ran the SEM Rush Log File Analyzer tool, and it showed some interesting things that are a complete waste of our Google Crawl Budget. Specifically, I learned that Google is wasting some of our crawl budget on the /wp-includes/ directory, certain plugin directories, and cache directories. I also noticed random files being crawled…
Where is the Google Analytics Measurement ID?
In the vast, evolving world of web development and analytics, keeping up with terminologies and tools can sometimes feel like trying to chase a mischievous cat in a maze. You think you’ve got a grip, only for it to slip right through your fingers! Enter the mysterious “Measurement ID” from Google Analytics 4 (GA4), a…
How to Convert .aiff to .mp3 files via Command Line
Yesterday I ran into an issue where I needed to convert .aiff files to .mp3. DBPowerAmp was recommended to me as a paid GUI tool. But I wanted something more lightweight, since this is a task I rarely need to do (most of the time, I’m already in Logic Pro, and exporting is simple there).…
From Toby’s Blog
- Fortify Your WordPress Site: Essential Security StepsSecuring your WordPress site is a critical component of maintaining your online presence and safeguarding your data. Security is no longer a luxury, it has become a necessity in today’s digital world, where threats are lurking at every corner. This piece dives deep into WordPress security basics, giving you a comprehensive understanding of common vulnerabilities…
- Master Your Site: Customizing WordPress ThemesJust as a house is more than bricks and mortar, a WordPress site is much more than simple code. It’s a cohesive structure built with various layers such as PHP, HTML, CSS, and other key elements. Customizing WordPress themes involves gaining an in-depth understanding of this structure, learning to inspect and adjust design elements with…
- Mastering WordPress Basics for Beginners within HoursWelcome to the world of WordPress, a widely used Content Management System (CMS) that powers millions of websites worldwide. Being immensely flexible and user-friendly, WordPress offers an endless scope to create, manage, and customize your website according to your needs and preferences. In this segment, we attempt to introduce you to the basics of WordPress,…