How to restore a saved Database

Started by Paffman, May 25, 2020, 12:11:15 PM

Previous topic - Next topic

Paffman

#20
Quote from: a10 on May 25, 2020, 05:53:30 PM
Good job! About backups:

Attachments, avatars, all forum related files > FTP program (if using Filezilla, first set transfer type to binary !!!)
Start with a complete backup of the entire forum directory.
Later (regularly) complement it with newer files (new attachments etc).
IMO, do fresh backup of forum files before forum updates, late night experiments, mod installations.


Hey,

I understand and have done DB backups via phpMyAdmin. But how do I make a backup of the forum directory? In cpanel I have the option of partial or complete, complete is everything on my server space for moving hosts. The partial is for Home Dir, mySQL DB or email forwarders/filters.

Can I not go to cpanel> file manager and just copy the forum folder?

a10

QuoteBut how do I make a backup of the forum directory?
Can I not go to cpanel> file manager and just copy the forum folder?
Yes. But:
Quote from: a10 on May 25, 2020, 05:53:30 PM
Attachments, avatars, all forum related files > FTP program (if using Filezilla, first set transfer type to binary !!!)
Start with a complete backup of the entire forum directory.
Later (regularly) complement it with newer files (new attachments etc).
IMO, do fresh backup of forum files before forum updates, late night experiments, mod installations.

Get started using FTP, very useful 'double' file manager, shows both your computer content & the server content, drag, drop, transfer, delete, rename etc files. Watch transfer queues etc. Configure ftp setup, features and views to suit one's needs.

May look complicated in the beginning, then it quickly becomes THE tool.
https://filezilla-project.org/client_screenshots.php

Your host supplies username & password for ftp.
Personally I never ever opened or visited the host's cp file manager (in 15 years!), ftp is so much better as a tool.
2.0.19, php 8.0.23, MariaDB 10.5.15. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Sir Osis of Liver

Don't think you can download directories with cpanel file manager, just single files, but you can zip the entire forum or just the /attachments directory and download the zip.  FileZilla is much better and faster for managing files.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Paffman

I have used FTP.

So if I download a complete server space worth, abt 7GB, I could then pick a folder to upload say, packages if it all goes wrong?

Shame I can't just download the forum folder with out all the other stuff.

Sir Osis of Liver

Well, yes you can, either with filemanager or ftp.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

a10

^^^ Click on the forum folder, drag it over to your chosen location on pc.
1 second of work from your part, ftp will do the rest.
2.0.19, php 8.0.23, MariaDB 10.5.15. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Paffman


Advertisement: