How to Backup MySQL or PostgreSQL

From ReduxWiki

[edit] Backup

# MySQL
mysqldump user_dbame > user_dbname.sql

# Modified Charset
mysqldump --default-character-set=latin5 user_db > /home/user/user_db.sql

# PostgreSQL
pg_dump user_dbname > user_dbname.sql

[edit] Transfer

# Move (local)
mv user_dbname.sql /home/user/folder

# Transfer (remote)
scp user_dbname.sql user@location:/home/user/

[edit] Restore

# Create the Database
createdb user_database

# MySQL
mysql user_dbname < /home/user/user_dbname.sql

# PostgreSQL
psql user_dbname < /home/user/user_dbname.sql