All Commands

Step #1 : Export Db to current server first. (I mean je server per DB che tya pahela aapde export kari ne sql file banavisu)

Step #2 : Will perform file transfer in between 2 servers. (Have e Sql file ne aapde new server par transfer karisu. SSH command thi)

Step #3 : Create DB and its user using phpmyadmin. (Import karva mate DB name and users create karva pade)

Step #4 : Import DB using ssh command. 

Step #5 : Change Base url and other options using direct DB update. (PHPmyadmin thi base url change karvani)

Step #6 : Update Wordpress config file where DB details are saved.

Step #7 : Clear all cache and session files.


All command here:

Move file from source to destination, please note need to logged in destination site.

=> scp -P22 -r user@host:/entire_source_path/filename /destination_path



Import database command:

mysql -u username -p databsename < wpgeekoracle_inscape3_live24.sql
for example:
mysql -u admin_live -p inscape_live2016 < wpgeekoracle_inscape3_live24.sql

export database:

mysqldump  -u username -p databsename > wpgeekoracle_platinum_live29.sql

for example:\
mysqldump  -u geekoracle_dev -p wpgeekoracle_dev_inscape3 > wpgeekoracle_inscape3_live25.sql

mysqldump  -u geekoracle_dev -p wpgeekoracle_dev_inscape3 > wpgeekoracle_inscape3_live25.sql




Now how to move DB from one server to another server ?
please note that you need to logged in destination.

DB: scp -P53210 -r root@mt2.geekoracle.com:/var/www/vhosts/geekoracle.com/dev.geekoracle.com/inscape3/wpgeekoracle_inscape3_live25.sql /var/www/vhosts/inscapesolutions.com/inscapesolutions.com

Zip command
zip -r zipfilename.zip source_dir

unzip: 

cd //var/www/html/eyecare/wp-content/plugins

then run command:
unzip contact-form-7.5.0.1.zip






unzip wordpress.zip -d/var/www/html/elevenelevan

Delete folder or zip file:
rm -r -f /var/www/html/wp-theme/woocommerce/logicrayswp.zip

zip -r bkp_24/wp-content.zip wp-content
zip -r bkp_24/wp-includes.zip wp-includes
zip -r bkp_24/styles.zip styles
zip -r bkp_24/pdf.zip pdf
zip -r bkp_24/wp-admin.zip wp-admin
zip -r bkp_24/howto.zip howto
zip -r bkp_24/contract.zip contract
zip -r bkp_24/un.zip un
zip -r bkp_24/video.zip video



rm -rf wp-content
rm -rf wp-includes
rm -rf styles
rm -rf pdf
rm -rf wp-admin
rm -rf howto
rm -rf contract
rm -rf un
rm -rf video



cd /var/www/vhosts/launch.platinumnaturals.com/httpdocs/wp-content

chmod -R 777 uploads/

cd /var/www/html/eyecare/wp-content/uploads/


Source path: /var/www/vhosts/geekoracle.com/dev.geekoracle.com/inscape3
zip -r inscape3_live_24_10.zip /var/www/vhosts/geekoracle.com/dev.geekoracle.com/inscape3

zip -r eyecaremyzip.zip /var/www/html/eyecare


Tar file extract:

tar -xvzf backup-10.12.2017_14-23-56_kampprogram.tar.gz
tar -xvzf filename.tar.gz
Chnage URL:

https://rudrastyh.com/tools/sql-queries-generator