# для доступа по ftp
sudo apt-get install vsftpd
define('FS_METHOD', 'direct'); # либо это в wp-config.php
define( 'WP_POST_REVISIONS', 2);

ini_set('display_errors','Off');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_DISPLAY', false);

define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');

Option 3 - Edit wp-config.php - It is possible to set the site URL manually in the wp-config.php file. Add these two lines to your wp-config.php, where "example.com" is the correct location of your site.

 

 

Рабочий пример рез копирования БД

# в 3 ночи делать бекап БД 
0 3 * * * mysqldump -u vh227182_ser -pgthdsq vh227182_boot > /var/www/vh227182/data/mysql_backups/vh227182_boot.sql
# backup history & clean once a week
5 3 * * * zip `date +/var/www/vh227182/data/mysql_backups/%d-%m-%y.zip` *.sql 
0 3 * * 0 rm -f /var/www/vh227182/data/mysql_backups/*.zip

 

5. development

UPDATE wp_options SET option_value = REPLACE(option_value, 'OLD_ADDR', 'NEW_ADDR') WHERE option_name = 'home' OR option_name = 'siteurl' ;

UPDATE wp_posts SET post_content = REPLACE (post_content, 'OLD_ADDR', 'NEW_ADDR');
UPDATE wp_posts SET guid = REPLACE (guid, 'OLD_ADDR', 'NEW_ADDR') WHERE post_type = 'attachment';

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'OLD_ADDR','NEW_ADDR');

UPDATE wp_comments SET comment_content = REPLACE (comment_content, 'OLD_ADDR', 'NEW_ADDR');
UPDATE wp_comments SET comment_author_url = REPLACE (comment_author_url, 'OLD_ADDR', 'NEW_ADDR');

 

# обновим тег src
UPDATE wp_posts SET post_content = replace(post_content, '<img src="/', '<img src="https://games.mail.ru/') where id >=2009 and id <2022;