Overwrite posts/pages via import

A good way around this I’ve found is to modify your local wp-config.php to access the remote database directly. You often have to enable remote sql in CPANEL. Then you enter the remote host URL in the define(‘DB_HOST’, ‘yoursite.com’); part of the config.

UTF8 Encoding problems when exporting posts

The file is likely correct, but the program that you’re viewing it in is probably interpreting it with ISO-8859-1 / latin1 encoding. The é pairing is something I have often seen when viewing a UTF-8 encoded é in latin1. Be sure that the program you are viewing the file in is set to view in … Read more

WordPress Local And Live Site

My best practice to run a production system and keep a development version with a simple and easy configuration. Notice: This works super awesome on small wordpress websites. Create production and development configuration files: wp-config-dev.php (contains local database configuration, site url and debugging) _wp-config-live.php (contains production database config., live site url and disabled debugging configuration) … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)