MariaDB Configuration for 870MB WordPress Database

I couldn’t transfer a client’s WordPress site onto my newly minted HestiaCP box due to SQL timeout errors. This server’s primary mission is WordPress hosting. I made a few changes to /etc/mysql/my.cnf, does anyone see issues with these adjustments, should I consider other changes:
innodb_buffer_pool_size = 128M
max_allowed_packet = 256M

I am using UpdraftPlus for the site transfer.

I would suggest to transfer the sql file using scp and mysql/mysqldump - easiest way, no fights with timeouts :slight_smile:.


To export:
mysqldump -u mysql_user -p DATABASE_NAME > backup.sql
mysqldump -u mysql_user -p DATABASE_NAME > /your/folder/here/backup.sql

Copy the files
Use scp or ftp or the file manager

unzip the database
in case it is compressed

To import:
mysql -u mysql_user -p DATABASE < backup.sql

Alternatively you may use to split the database into smaller chunks and then upload them one by one.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.