MySQL: backup and restore
Backup
_$: mysqldump -u <user> -p <database> -h <hostname> > <backup>
_$: mysqldump -u <user> -p<password> <database> -h <hostname> > <backup>
If we are in a Windows server, we must convert the backup file to UTF-8:
_$: iconv -f latin1 -t utf-8 <backup> > <backup-utf8>
Restore
_$: mysql -u <user> -p <database> < <backup>
_$: mysql -u <user> -p<password> <database> < <backup>