Transfer WP from subdomain to main domain

After copying to the main-directory change the values in then wp-config.php and .htaccess files for the new localtion. Then you have to change the values in the database. You need 3 SQL-Statements, which you can execute with phpMyAdmin for example. First change the options-Table UPDATE wp_options SET option_value = replace(option_value, ‘http://www.example.com/subdir’, ‘http://www.example.com’) WHERE option_name=”home” OR … Read more

Server ip to Domain

I always run queries in phpmyadmin http://www.phpmyadmin.net or adminer http://www.adminer.org/: UPDATE wp_options SET option_value = replace(option_value, ‘http://www.olddomain.com/’, ‘http://www.newdomain.com/’) WHERE option_name=”home” OR option_name=”siteurl”; UPDATE wp_posts SET guid = replace(guid, ‘http://www.olddomain.com/’,’http://www.newdomain.com/’); UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.olddomain.com/’, ‘http://www.newdomain.com/’); Yes, some will say to never change the GUID, but changing the domain gives you no choice. Your … Read more

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