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.?