Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
Article Goal: Adjust the size of the MySQL data storage.
In this article we are going to adjust the size of the MySQL data storage for queuing / downloading reports in WebReports.
Where Do You Adjust the MySQL Data Storage?
Launch the MySQL Command line and login using the root password that was created during the MySQL setup process.
Steps to Adjust the MySQL Data Storage.
1. Launch the MySQL Command Line Client.
2. Enter the rootpassword that was created in the Install MySQL article (step X), then press enter.
Note: To paste copied passwords into the client, click in the title bar of the client and then right click on the password.
3. Once successfully logged in, copy the commands below and paste them into the client, then press Enter.
Note: If the data storage needs to be larger, add some zeros.
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;