MySQL

Backup the DB

Perform backup of DB: mysqldump -u username -p dbname > backup-name-2021-02-25-1200.sql

Import the DB

Import the DB: mysql -u dbusername -p dbname < wordpress-migrate-vers3.sql

Useful SQL Queries for WP

Powerful SQL queries for working with WordPress.

Warning! Expect experimental results! Alway perform a full backup before using any of the below

Update password using SQL

UPDATE wp_users SET user_pass = MD5( '[new_password]' ) WHERE user_login = '[username]';

Transfer posts to a new author

UPDATE  wp_posts SET  post_author = (SELECT ID FROM wp_users WHERE user_login = '[new_author_login]') WHERE post_author = (SELECT ID FROM wp_users WHERE user_login = '[old_author_login]');

Update links when you move to a new domain

UPDATE wp_posts SET post_content = REPLACE (post_content, '[old_domain]', '[new_domain]');

Change your WordPress Posts into Pages

UPDATE wp_posts SET post_type = 'page' WHERE post_type = 'post';

Change your Pages into Posts

UPDATE wp_posts SET post_type = 'post' WHERE post_type = 'page';

Update your username

UPDATE wp_users SET user_login = 'newusername' WHERE user_login = 'oldusername';

Want more? Check out (opens new window)