How to make a copy of list with filenames from database?

Skodette

• November 21, 2019 02:33

Hi all, I run a photography website. In CPanel / File Manager, I can find the list with the file names of all the images (1000+) I have uploaded to my website database. I would like to make a copy (or print) of this list, for the worst case scenario when the website and its backup file should crash. So that I know which selected images I have to upload again from my collection on my iMac. Is this a good idea? And how can I make a copy of the list?

• 

  cPanelLauren

  • November 21, 2019 20:11

  Hi @Skodette Making a list of 1000+ photos to upload manually sounds like an extremely time-intensive task (not just the list but the thought of re-uploading all of those!) What might be a better bet is to keep regular backups of your site and database, that way, in the event of a catastrophic issue you'll have a copy of the site that will be restorable in minutes without the worry that you may or may not forget a file. You can make backups directly within cPanel by going to cPanel>>Files>>Backup Wizard and download them locally or send them to a remote destination using FTP or SCP. If this feature isn't available within your cPanel UI I'd suggest discussing your options with your hosting provider further.

  0
• 

  sbutler

  • November 22, 2019 16:24

  If you wanted a catalog of the photo names in a file you can create a php file. Create file photolist.php and put the code below in the file and save into a folder you want to get a text list of all the files in the folder. This will only work in the current directory and only files will be listed with no directories. This will open a save file window. Just place the file in the directory where your photos are and open the url to file, Example:
  

  0

Please sign in to leave a comment.