View Single Post
Old 10-03-2017, 02:57 PM  
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
So...
I have taken a look and tried to understand everything.

To restore I understood, because I had to use the command line to load those damn corrupted databases, otherwise via phpMyAdmin I could not import them.

For backup I have a few questions:
Can I create a single file to use in crontab?
Eg. .sh executable... (I do not know what they are called or what they are, but I happened to make someone on my PC...) to create a single file with all the commands in order to backup all the databases and use it in a cronjob?

And launch this file once a week or once a month via crontab?
It depends on how many resources it consumes by launching all backups together.

I did not know SCP, but I like it... So much, I have a little raspberry PI attached to my router that spends the day making backups of my data between my PCs, the mobile phone, the tablet and some cloud services.

So if I can take SCP backups of the databases on my raspberry, he save them anywhere...

The backup files in order to be "taken" with SCP must be in home/user/?
Also if ssh logs in as root?






------------------------------------------------------------------
Other little thing out of topic but it came a minute ago...

Doing
Code:
sudo apt-get update
sudo apt-get upgrade
In 14.04 the server says this:
Code:
Processing triggers for libapache2-mod-php5.6 (5.6.31-6+ubuntu14.04.1+deb.sury.org+1) ...
Processing triggers for php5.6-fpm (5.6.31-6+ubuntu14.04.1+deb.sury.org+1) ...
php5.6-fpm stop/waiting
php5.6-fpm start/running, process 26417
NOTICE: Not enabling PHP 5.6 FPM by default.
NOTICE: To enable PHP 5.6 FPM in Apache2 do:
NOTICE: a2enmod proxy_fcgi setenvif
NOTICE: a2enconf php5.6-fpm
NOTICE: You are seeing this message because you have apache2 package installed.
php5.6-fpm stop/waiting
php5.6-fpm start/running, process 26465
Should I do that?
I installed PHP 5.5 along with the lamp, then PHP 5.6 later, but I don't remember ever asking for FPM...
Better to use FPM on the 14.04? Is fpm now obsolete? If I enable it I have to remake hp.ini configuration, re-enable opcache, etc etc etc.?
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote