Hi,
I am trying to switch our email server from our old 10.2 server to the new FreeBSD11.1 and I need a few pointer please..
I have ran the following command from our old server to copy the messages:
So I now have all the email file sync correctly.
In term of databases, I we use 2 databases..
mysql56-server
postgresql93-server
Could you please tell me how to create the database dump for postgresql as I have never used it before.
Also for mysql, will the following command do the job ?
or do I need more option like
Please advise on the best syntax to use for extracting both mysql and postgresql data.
Thank you in advance
I am trying to switch our email server from our old 10.2 server to the new FreeBSD11.1 and I need a few pointer please..
I have ran the following command from our old server to copy the messages:
rsync -avz /usr/local/vhosts/ [EMAIL='root@194.12.13.195%3A/usr/local/vhosts/']root@194.12.xxx.xxx:/usr/local/vhosts/[/EMAIL]
So I now have all the email file sync correctly.
In term of databases, I we use 2 databases..
mysql56-server
postgresql93-server
Could you please tell me how to create the database dump for postgresql as I have never used it before.
Also for mysql, will the following command do the job ?
mysqldump -h localhost --all-databases > mail_databases.sql
or do I need more option like
mysqldump --single-transaction --routines --triggers --all-databases > mail_databases.sql
Please advise on the best syntax to use for extracting both mysql and postgresql data.
Thank you in advance