Tag: sql

How to change WordPress main URL to new one

1795  admin  
(last edited )

Using WP-CLI (preferred):

Enter folder where your WordPress is installed:

username@server1 [~]# cd ~/public_html

Create backup of your database:

username@server1 [~/public_html]# wp db export

The following command won’t do any change because of –dry-run key specified but show you tables and amount of replacement

username@server1 [~/public_html]# wp search-replace 'OLDdomain.com'
… Read the rest

How to create MySQL dump and get it on your email

1280  admin  
(last edited )

Definitely could be a mail sending problem if your SQL dump too large

mysqldump -ce my_db --user=my_user --password=mypass |gzip > ~/DBBackup.`date +\%F`.gzip; uuencode ~/DBBackup.`date +\%F`.gzip DBBackup.`date +\%F`.gzip |mail -s "my DB" [email protected]; rm -f ~/DBBackup.`date +\%F`.gzip
… Read the rest