How to Backup a WordPress Site & Restore on Local Linux

# Replace db, user, password, host accordingly.
mysql> USE wordpress;
# Display tables within the active database.
mysql> SHOW TABLES;

# Store all table contents into an SQL dump (suppresses output).
# Paste your database username and password when prompted.
myql> mysqldump -uuser -pdbname > db_backup.sql
# Replace with real credentials:
# Enter password: [type it]
# This action will prompt for confirmation.

# Example: Backup site at /var/www/example.com,
# Send them to root@example.com, then compress.
scp -r * root@target-ip:/path/to/backup/
# Gzip the backup file after transfer (ensures data is compacted).
gzip -9 /var/temp/example.com.tar.gz

# Replace "newbackup" and "rootpassword" with your settings.
# The line below runs the command for database creation:
creato databases;

# Grant all permissions to this user on that table.
GRANT PRIVILEGES ON database.*;

# Restore the backup from earlier steps.
# Replace username/password/database_name as needed.

myql> mysql -u root -prootpassword mydb < db_backup.sql

# Standard WordPress settings for testing on localhost:
define('DB_NAME', 'newbackup');
define('DB_USER',  'rootpassword');
define('DB_PASSWORD', 'proper_password');
define('DB_HOST',   '127.0.0.1');  # Local server address.
define('DB_CHARSET',       'latin1');
# Adjust prefix as per your local environment.
$table_prefix = "migrate";