สำรองข้อมูล WordPress

ssh  username@Ip Address

mkdir -p /backup/wordpress

tar -czf /backup/wordpress-`date '+%m%d%y'`.tar.gz   /var/www/knupan

mysqldump -u your_username -p your_database_name > your_database_name-$(date +%F).sql

mysql -u [username] -p newdatabase < [database name].sql

sudo cp -a /backup/wordpress/. /var/www/wordpress

sudo chown -R www-data:www-data /var/www/knupan
sudo find /var/www/knupan/ -type d -exec chmod 750 {} \;
sudo find /var/www/knupan/ -type f -exec chmod 640 {} \;
sudo systemctl restart apache2

ssh  username@Ip Address

ssh  root@125.252.255.12

mkdir -p /backup/wordpress

mkdir -p /backup/

tar -czf /backup/wordpress-`date '+%m%d%y'`.tar.gz   /var/www/knupan

tar -czf /backup/knupan-`date '+%m%d%y'`.tar.gz   /var/www/knupan

mysqldump -u [username] -p [database name] > [database name].sql

mysqldump -u your_username -p your_database_name > your_database_name-$(date +%F).sql

mysqldump -u root  -p  drupal > drupal-$(date +%F).sql

 # mysql -u root -p

CREATE DATABASE database_name; exit

mysql -u [username] -p newdatabase < [database name].sql

tar xzvf knupan-071323.tar.gz

sudo cp -a /backup/wordpress/. /var/www/wordpress

sudo cp -a /backup/var/www/knupan/. /var/www/knupan

sudo chown -R www-data:www-data /var/www/knupan
sudo find /var/www/knupan/ -type d -exec chmod 750 {} \;
sudo find /var/www/knupan/ -type f -exec chmod 640 {} \;
sudo systemctl restart apache2

/etc/init.d/mysql stop

sudo mysqld_safe --skip-grant-tables &

mysql -u root mysql

update user set password=PASSWORD("newpassword") where User='root';

FLUSH PRIVILEGES;

sudo -i

wget https://raw.githubusercontent.com/clusterednetworks/rsync-offsite-backup/master/rsync.server.ssh.key.sh

#!/bin/sh
#  Copyright (C) 2021 Ron Billings                                         #
#  info@clusterednetworks.com                                                        #
#                                                                              #
#  This program is free software; you can redistribute it and/or modify        #
#  it under the terms of the GNU General Public License as published by        #
#  the Free Software Foundation; either version 2 of the License, or           #
#  (at your option) any later version.                                         #
#                                                                              #
#  This program is distributed in the hope that it will be useful,             #
#  but WITHOUT ANY WARRANTY; without even the implied warranty of              #
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               #
#  GNU General Public License for more details.                                #
#
#----------------------------------------
# OPTIONS
#----------------------------------------
# connection info
REMOTE_HOST=yourserver.yourdomain.com
REMOTE_USER=your-login-user
REMOTE_PORT=22

# path to private key
KEY=/home/??/

# path to backup to files to
LOCAL_PATH=/home/backup/backuptest

# path to pull the files from
REMOTE_PATH=/home/backup/backuptest

#----------------------------------------
echo "Copying files from $REMOTE_HOST to backup server ........"

/usr/bin/rsync -rsh -e "ssh -i $KEY" $REMOTE_USER@$REMOTE_HOST:$REMOTE_PATH $LOCAL_PATH

echo "Done"

wget https://raw.githubusercontent.com/clusterednetworks/rsync-offsite-backup/master/rsync.server.ssh.password.sh

#!/bin/sh
#                                                                              #
#  Copyright (C) 2021 Ron Billings                                         #
#  info@clusterednetworks.com                                                        #
#                                                                              #
#  This program is free software; you can redistribute it and/or modify        #
#  it under the terms of the GNU General Public License as published by        #
#  the Free Software Foundation; either version 2 of the License, or           #
#  (at your option) any later version.                                         #
#                                                                              #
#  This program is distributed in the hope that it will be useful,             #
#  but WITHOUT ANY WARRANTY; without even the implied warranty of              #
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               #
#  GNU General Public License for more details.                                #
#
#----------------------------------------
# OPTIONS
#----------------------------------------
# connection info
REMOTE_HOST=yourserver.yourdomain.com
REMOTE_USER=username
REMOTE_PASSWORD=user1234
REMOTE_PORT=22

# local path to download the files to
LOCAL_PATH=/home/backup/backuptest

# remote path to get the files from
REMOTE_PATH=/home/backup/serverbackup
#----------------------------------------

echo "Copying files from $REMOTE_HOST to Backup Server ........"

sshpass -p $REMOTE_PASSWORD /usr/bin/rsync -rsh -e ssh $REMOTE_USER@$REMOTE_HOST:$REMOTE_PATH $LOCAL_PATH

echo "Done"

# connection info
REMOTE_HOST=yourserver.yourdomain.com
REMOTE_USER=your-login-user
REMOTE_PORT=22

# path to private key
KEY=/root/.ssh/id_rsa

# path to backup to files to
LOCAL_PATH=/root/backup

# path to pull the files from
REMOTE_PATH=/var/www/knupan

chmod +x rsync.server.ssh.key.sh

./rsync.server.ssh.key.sh

5 1   * * * /etc/rsync.server.ssh.key.sh >/dev/null 2>&1