Page 1 of 1

Backup complete database and server

Posted: Mon Feb 06, 2023 8:26 pm
by douwe
I plan to make a total backup of the whole script is it enough to do a SQL export and a backup of the server? and if so should I be concerned about the chmod permissions of folders or files?, and if so which files or folders should I give permissions Regards Douwe.thanks in advance

Re: Backup complete database and server

Posted: Wed Mar 20, 2024 8:44 pm
by inoculator
Hi,
I am new to S9Y and was searching for some documents about backup and disaster recovery.
I have not found any clear saying sentences, but repeadingly the requirement of making a backup before upgrade, so I assume, there must be one.
Could some body point the TO and me to the correct corner of the manuals?
Thanks

Re: Backup complete database and server

Posted: Thu Mar 21, 2024 11:26 am
by erAck
Quoting from https://docs.s9y.org/docs/users/getting ... e-manually
Make a complete backup of your existing installation, we recommend saving every file to a backup folder on your local hard drive, and be sure to save a dump of your database as well. Using phpMyAdmin, select your database from the left side drop down, then click ‘export’ from the main navbar, select the options you need, then click ‘save as file’ and ‘Go’.
Instead of phpMyAdmin you could also use Adminer (though development stalled), its advantage is it's just one PHP file to copy and remove later if you don't have phpMyAdmin installed yet, or best use the mysqldump command line utility if you have access to it, see https://linuxize.com/post/how-to-back-u ... mysqldump/