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
wait_timeout=600

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:.

3 Likes

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 https://sqldumpsplitter.net/ to split the database into smaller chunks and then upload them one by one.

1 Like