How I relocated WordPress site to New server

Moving from A to B via ssh

I use tar and pipe to move from server A to server B

// install PV (for progress bar)
apt install pv

cd /data/wwwroot
tar zcf - . | pv | ssh [email protected] "cat > /root/wwwroot.tgz"

WordPress is missing wp_users and wp_usermeta SQL table

I accidentally found out that I missed these 2 table and break my site when I do the backup.

Solution will be export other WordPress wp_users and wp_usermeta SQL and change the db prefix and import it back, then boom.. Done~~.

Source for reset admin password with phpMyAdmin: