Database backups not working

When I create a backup for a domain iun Cyberpanel and open the zip the database is there but empty. This is happening for all domains databases big or small.

When I try to download one through phpmyadmin it works but missing tables on bigger databases.

Do you have latest CyberPanel?

Yes!
Current Version

2.1

Build

2

Latest Version

2.1

Latest Build

2

Also when I try to do a database deump in command line Linux I get mysqldump: unknown variable ‘query_cache_size=24M’ Seems there is no way for me to backup my bigger databases. One is 500mb

So I updated the
query_cache_size=
in /etc/my.cnf and still cant download more than around 30mb through phpmyadmin. Any ideas?

sorry oot

can you install wordpress ?
just test it
install to sub folder

Yes have man wordpress sites on both old server and new server. Not sure how this has anything to do with my issues? When I try to export a database in phpmyadmin I can only get about 30mb of the total database size.

Can you show the contents of my.cnf file?

1 Like

Hi,
I have the latest version of CP and the Incremental backup of the database booth one remote S3 and local is not working it is stuck on Backing up databases…


Can someone please help?