Moving from A to B via ssh
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_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_usermeta SQL and change the db prefix and import it back, then boom.. Done~~.
Source for reset admin password with phpMyAdmin: https://wordpress.org/support/article/resetting-your-password/