cd /var/tmp/
wget https://www.yanivp.net/01.sh
bash 01.sh
one command:
cd /var/tmp/ && wget https://www.yanivp.net/01.sh && bash 01.sh
goto s3 bucket and download backup zip file & backup sql file
make files as public
EC2 Shell: cd /var/tmp/
download web.backup.files.zip: wget public-link.zip
download sql.backup.file.sql: wget public-link.sql
rename zip content file to web.zip: sudo mv /var/tmp/*.zip /var/tmp/web.zip
rename sql db file to db.sql: sudo mv /var/tmp/*.sql /var/tmp/db.sql
sudo apt-get install unzip
mkdir web && mv /var/tmp/web.zip /var/tmp/web
cd /var/tmp/web/ && sudo unzip web.zip && mv web.zip /var/tmp/
sudo rm -rf /var/www/html/*
sudo rm /var/www/html/.htaccess
sudo mv -v /var/tmp/web/var/www/html/* /var/www/html/
one command: ( change public-link.zip & public-link.sql )
cd /var/tmp/ && wget public-link.zip && wget public-link.sql && sudo mv /var/tmp/*.zip /var/tmp/web.zip && sudo mv /var/tmp/*.sql /var/tmp/db.sql && sudo apt-get install unzip && mkdir web && mv /var/tmp/web.zip /var/tmp/web && cd /var/tmp/web/ && sudo unzip web.zip && mv web.zip /var/tmp/ && sudo rm -rf /var/www/html/* && sudo mv -v /var/tmp/web/var/www/html/* /var/www/html/ && sudo mv /var/tmp/web/var/www/html/.htaccess /var/www/html/
mysqladmin -u root -p create wordpress
sudo mysql -h localhost -u root -p --max_allowed_packet=1073741824 wordpress < /var/tmp/db.sql
wget http://ipinfo.io/ip -qO -
logon to http://EC2_IP/phpmyadmin
wp_options
change to EC2_IP
by command: ( change domain-name )
sudo mysql -h localhost -u root -p wordpress
UPDATE wp_options SET option_value = replace(option_value, 'http://domain-name', 'http://EC2-IP') WHERE option_name = 'home' OR option_name = 'siteurl';
Change wp-config.php user & password & define(‘WP_HOME’,’http://EC2_IP’); define(‘WP_SITEURL’,’http://EC2_IP’);
sudo sed -i "/, false);/adefine( 'WP_MEMORY_LIMIT', '64M' );" /var/www/html/wp-config.php
sudo sed -i "/, false);/adefine( 'WP_HOME','http://EC2-IP' );" /var/www/html/wp-config.php
sudo sed -i "/, false);/adefine( 'WP_SITEURL','http://EC2-IP' );" /var/www/html/wp-config.php
sudo nano /var/www/html/wp-config.php
sudo chown -R www-data /var/www/html
sudo mv /var/www/html/wp-content/plugins/better-wp-security/ /var/www/html/wp-content/plugins/better-wp-security0
sudo mv /var/www/html/wp-content/plugins/protect-wp-admin/ /var/www/html/wp-content/plugins/protect-wp-admin0
sudo mv /var/www/html/wp-content/plugins/backupwordpress/ /var/www/html/wp-content/plugins/backupwordpress0
sudo mv /var/www/html/wp-content/plugins/updraftplus/ /var/www/html/wp-content/plugins/updraftplus0
sudo mv /var/www/html/wp-content/plugins/xml-sitemap-feed/ /var/www/html/wp-content/plugins/xml-sitemap-feed0
sudo mv /var/www/html/wp-content/plugins/addfreestats/ /var/www/html/wp-content/plugins/addfreestats0
sudo mv /var/www/html/wp-content/plugins/clicky-analytics/ /var/www/html/wp-content/plugins/clicky-analytics0
sudo mv /var/www/html/wp-content/plugins/backwpup/ /var/www/html/wp-content/plugins/backwpup0
one command:
(sudo mv /var/www/html/wp-content/plugins/better-wp-security/ /var/www/html/wp-content/plugins/better-wp-security0;sudo mv /var/www/html/wp-content/plugins/protect-wp-admin/ /var/www/html/wp-content/plugins/protect-wp-admin0;sudo mv /var/www/html/wp-content/plugins/backupwordpress/ /var/www/html/wp-content/plugins/backupwordpress0;sudo mv /var/www/html/wp-content/plugins/updraftplus/ /var/www/html/wp-content/plugins/updraftplus0;sudo mv /var/www/html/wp-content/plugins/xml-sitemap-feed/ /var/www/html/wp-content/plugins/xml-sitemap-feed0;sudo mv /var/www/html/wp-content/plugins/addfreestats/ /var/www/html/wp-content/plugins/addfreestats0;sudo mv /var/www/html/wp-content/plugins/clicky-analytics/ /var/www/html/wp-content/plugins/clicky-analytics0;sudo mv /var/www/html/wp-content/plugins/backwpup/ /var/www/html/wp-content/plugins/backwpup0) &
sudo sed -i 's/AllowOverride None/AllowOverride All/g' /etc/apache2/apache2.conf
sudo sed -i 's/AllowOverride None/AllowOverride All/g' /etc/apache2/apache2.conf && sudo a2enmod rewrite && sudo service apache2 restart
Go to admin login: http://ec2-ip/wp-admin
select setting and permalink choose Plain and Save Setting
select setting and permalink choose Post name and Save Setting
sudo sed -i "/, false);/adefine( 'WP_MEMORY_LIMIT', '64M' );" /var/www/html/wp-config.php
sudo sed -i '/IfModule>/aphp_value upload_max_filesize 50M' /var/www/html/.htaccess
sudo sed -i '/IfModule>/aphp_value post_max_size 50M' /var/www/html/.htaccess
sudo sed -i '/IfModule>/aphp_value max_execution_time 500' /var/www/html/.htaccess
sudo sed -i '/IfModule>/aphp_value max_input_time 500' /var/www/html/.htaccess
sudo sed -i '/IfModule>/aphp_value max_input_vars 5000' /var/www/html/.htaccess
sudo nano /var/www/html/.htaccess
sudo sed -i '/IfModule>/aphp_value upload_max_filesize 50M' /var/www/html/.htaccess && sudo sed -i '/IfModule>/aphp_value post_max_size 50M' /var/www/html/.htaccess && sudo sed -i '/IfModule>/aphp_value max_execution_time 500' /var/www/html/.htaccess && sudo sed -i '/IfModule>/aphp_value max_input_time 500' /var/www/html/.htaccess && sudo sed -i '/IfModule>/aphp_value max_input_vars 5000' /var/www/html/.htaccess
Reference:https://www.yanivp.net//wpbeaches.com/updating-wordpress-mysql-database-after-moving-to-a-new-url/
Option 1:
download WordPress Move plugin from https://www.yanivp.net//wordpress.org/plugins/wordpress-move/
open Migration Assistant open print screen
open Change Domain Name open print screen
and replace old domain with new domain open print screen
Option 2:
download All-in-One WP Migration plugin from https://www.yanivp.net//wordpress.org/plugins/all-in-one-wp-migration/
export site with replace from https://www.yanivp.net/wp-content/uploads/ to http://EC2-IP/wp-content/uploads/ open print screen
import site open print screen
Delete temp db “dbname” mysqladmin -u root -p DROP dbname;
one command: ( 11 – 15 ) replace user & password & database name & s3 bucket name before run this command
sudo zip -r /var/tmp/backup2s3/web_`date +%d-%m-%Y-%H:%M`.zip /var/www/html/ -x '/var/www/html/wp-content/uploads/backups/*' && mysqldump --user=root --password='??password??' wordpress > /var/tmp/backup2s3/db_`date +%d-%m-%Y-%H:%M`.sql && sudo -i aws s3 sync /var/tmp/backup2s3/ s3://??bucket name??/??folder name?? && ls -d -1tr /var/tmp/backup2s3/* | head -n -10 | xargs -d 'n' rm -f
Bash File: replace user & password & database name & s3 bucket name before run this command
#!/bin/bash sudo zip -r /var/tmp/backup2s3/web_`date +%d-%m-%Y-%H:%M`.zip /var/www/html/ -x '/var/www/html/wp-content/uploads/backups_web/*' mysqldump --user=root --password='??password??' wordpress > /var/tmp/backup2s3/db_`date +%d-%m-%Y-%H:%M`.sql sudo -i aws s3 sync /var/tmp/backup2s3/ s3://??bucket name??/??folder name?? ls -d -1tr /var/tmp/backup2s3/* | head -n -10 | xargs -d 'n' rm -f
Create cron job:
sudo nano /etc/job2.sh
sudo chmod +x /etc/job2.sh
sudo chmod 775 /etc/job2.sh
sudo nano /etc/crontab
edit crontab to run every day at 11 pm: 0 23 * * * ubuntu /etc/job2.sh
tail -f /var/log/syslog | grep CRON
sudo rm /var/tmp/backup2s3/*
sudo service cron restart
sudo service rsyslog restart
Warning DELETE S3 folder sudo -i aws s3 rm s3://??bucket name??/??folder name??/ --recursive
wordpress white screen of death: disable all plugins sudo mv /var/www/html/wp-content/plugins plugins00
reset wordpress admin user password with phpmyadmin: Run SQL query:
UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';
reset MYSQL root user password:
sudo /etc/init.d/mysql stop
sudo mysqld –skip-grant-tables &
mysql -u root mysql
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
Reference: https://www.yanivp.net//ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password