SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Database Backup

Started by gdavison, March 29, 2024, 05:41:57 AM

Previous topic - Next topic


Had a search but could not find the answer, Am I right in thinking that the old Database backup function from within the Admin Forum Maintenance page has gone and that the recommended method of doing a database backup is now MyPHPAdmin ?

Many Thanks

Aleksi "Lex" Kilpinen

Yes, the built in backup function was never recommended, it was there to be used as a last resort basically. If you want a reliable backup of any larger database, you need purpose built tools.
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF


Many thanks for quick response

Doug Heffernan

Quote from: gdavison on March 29, 2024, 05:41:57 AMand that the recommended method of doing a database backup is now MyPHPAdmin

Most hosts have file size restictions in place for phpmyadmins on their servers. And for that reason I wouldn't recomend phpmyadmin for making medium to large database backups as it will result in incomplete/corrupt files. If you have cPanel, as mentioned above by Lex, it's best to use purpose built tools such as the Backups directory. And even then, always check the backup file to make sure that it has been done properly.


I have successfully used Akeeba Solo for backup, and to make a copy of the forums for testing major changes.
Also I use their Kickstart tool for the restore, especially to move from one server to another.
Stefan Bartelski
Webmaster for the Cadillac LaSalle Discussion forums