Pinned Loading

1. DUMP WordPress SQL DB DUMP WordPress SQL DB

   1

   <?php

   2

   include 'wp-config.php';

   3

   4

   $DBUSER = DB_USER;

   5

   $DBPASSWD = DB_PASSWORD;

2. Create WordPress Admin User from SQL... Create WordPress Admin User from SQL (PHPMYADMIN)

   1

   SET @user_login='john_doe';

   2

   SET @user_pass=MD5('YOUR_HARD_PASSWORD');

   3

   SET @user_nicename=@user_login;

   4

   SET @user_email='[email protected]';

   5

   SET @user_url='http://example.com/';

3. change-url.sql change-url.sql

   1

   SET @old_url='old.domain';

   2

   SET @new_url='new.domain';

   3

   UPDATE wp_options SET option_value = replace(option_value, @old_url, @new_url) WHERE option_name = 'home' OR option_name = 'siteurl'

   4

   UPDATE wp_posts SET guid = replace(guid, @old_url, @new_url)

   5

   UPDATE wp_posts SET post_content = replace(post_content, @old_url, @new_url)

4. Change WordPress URL with mysqli & php Change WordPress URL with mysqli & php

   1

   <?php

   2

   include 'wp-config.php';

   3

   4

   $servername = DB_HOST;

   5

   $username = DB_USER;