1 Topic by xvktr

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Topic: backup mail account and upgrade

I'd like make a backup of accounts (config password etc) from my server  (0.5.1) to a new server with 0.7.1.
How is the best way to make a backup of files and databases?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

try this...
your new server is running openldap or mysql backend?

http://www.iredmail.org/forum/topic1255 … nldap.html

3 Reply by xvktr

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

hata_ph wrote:

try this...
your new server is running openldap or mysql backend?

http://www.iredmail.org/forum/topic1255 … nldap.html

mysql

4 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

you can try this http://www.iredmail.org/forum/topic577- … abase.html but i think there is some new changes on 0.7.1 compare to 0.5.1.

5 Reply by xvktr

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

I use the script and make a backup of /var/vmail, but the list of users doesn't are transfered.
how i can do that?
Thanks

6 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

U need to backup the mysql database and restore it to your new server...

7 Reply by xvktr

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

I did it with the script, but doesn't work.  I tried reboot the server, but doesn't work to.
the old server is 0.5.1 and the new is 0.7.1, both without LDAP.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: backup mail account and upgrade

xvktr wrote:

the old server is 0.5.1 and the new is 0.7.1, both without LDAP.

There're something difference between 0.5.1 and 0.7.1 in SQL structure, it's better to export necessary columns then import into 0.7.1.

9 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

Better you list down step by step what is your backup/restore procedure...

10 Reply by xvktr (edited by xvktr 2011-05-30 21:50:05)

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

On the "old" server
-download, edited the backup script (password), and run it.
-backup the vmail database.
-backup the /var/vmail dir

on the "new" server:
-make a basic  install of debian 6
-install ssh
-install iredmail 0.7.1
-restore backup :

mysqldump  -u root -p123 --databases iredadmin < 2011.05.27.08.49.53-iredadmin.sql
mysqldump  -u root -p123 --databases mysql < 2011.05.27.08.49.53-mysql.sql
mysqldump  -u root -p123 --databases postfixpolicyd  < 2011.05.27.08.49.53-postfixpolicyd.sql
mysqldump  -u root -p123 --databases roundcubemail < 2011.05.27.08.49.53-roundcubemail.sql
mysqldump  -u root -p123 --databases vmail < vmail.sql

-restore the /var/vmail dir
-reboot server.

11 Reply by xvktr (edited by xvktr 2011-05-30 22:11:30)

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

the vmail databases don't restore.
the result of command ar e attached

Post's attachments

a 18.72 kb, 6 downloads since 2011-05-30 

You don't have the permssions to download the attachments of this post.

12 Reply by carlkyo

  • carlkyo
  • Member
  • Offline
  • Registered: 2010-06-30
  • Posts: 24

Re: backup mail account and upgrade

xvktr wrote:

On the "old" server
-download, edited the backup script (password), and run it.
-backup the vmail database.
-backup the /var/vmail dir

on the "new" server:
-make a basic  install of debian 6
-install ssh
-install iredmail 0.7.1
-restore backup :

mysqldump  -u root -p123 --databases iredadmin < 2011.05.27.08.49.53-iredadmin.sql
mysqldump  -u root -p123 --databases mysql < 2011.05.27.08.49.53-mysql.sql
mysqldump  -u root -p123 --databases postfixpolicyd  < 2011.05.27.08.49.53-postfixpolicyd.sql
mysqldump  -u root -p123 --databases roundcubemail < 2011.05.27.08.49.53-roundcubemail.sql
mysqldump  -u root -p123 --databases vmail < vmail.sql

-restore the /var/vmail dir
-reboot server.

hello xvktr
I 'd like to know how to set the permission of all mailbox
many thanks

13 Reply by xvktr

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

Hello!
I1m formated the server and try again , but installing the 0.5.1, and work.
But.....
When I try login on Roundcube or use pop3 client, return message of bad login or password, I tried change whith postfixadmin, but doesn't work.
I try create a new account and this works.
I make backup of /var/vmail/
and this databases:
mysql -u root -p123 -h localhost vmail < vmail.sql
mysql -u root -p123 -h localhost roundcubemail < roundcubemail.sql
mysql -u root -p123 -h localhost postfixpolicyd < postfixpolicyd.sql
mysql -u root -p123 -h localhost mysql < mysql.sql

14 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

xvktr wrote:

Hello!
I1m formated the server and try again , but installing the 0.5.1, and work.
But.....
When I try login on Roundcube or use pop3 client, return message of bad login or password, I tried change whith postfixadmin, but doesn't work.
I try create a new account and this works.
I make backup of /var/vmail/
and this databases:
mysql -u root -p123 -h localhost vmail < vmail.sql
mysql -u root -p123 -h localhost roundcubemail < roundcubemail.sql
mysql -u root -p123 -h localhost postfixpolicyd < postfixpolicyd.sql
mysql -u root -p123 -h localhost mysql < mysql.sql

Did you restore the mysql related file for roundcubemail?

15 Reply by hata_ph

  • hata_ph
  • Member
  • Offline
  • Registered: 2010-01-13
  • Posts: 226

Re: backup mail account and upgrade

carlkyo wrote:
xvktr wrote:

On the "old" server
-download, edited the backup script (password), and run it.
-backup the vmail database.
-backup the /var/vmail dir

on the "new" server:
-make a basic  install of debian 6
-install ssh
-install iredmail 0.7.1
-restore backup :

mysqldump  -u root -p123 --databases iredadmin < 2011.05.27.08.49.53-iredadmin.sql
mysqldump  -u root -p123 --databases mysql < 2011.05.27.08.49.53-mysql.sql
mysqldump  -u root -p123 --databases postfixpolicyd  < 2011.05.27.08.49.53-postfixpolicyd.sql
mysqldump  -u root -p123 --databases roundcubemail < 2011.05.27.08.49.53-roundcubemail.sql
mysqldump  -u root -p123 --databases vmail < vmail.sql

-restore the /var/vmail dir
-reboot server.

hello xvktr
I 'd like to know how to set the permission of all mailbox
many thanks

try chown vmail:vmail /var/vmail/

16 Reply by xvktr (edited by xvktr 2011-06-10 02:17:54)

  • xvktr
  • Member
  • Offline
  • Registered: 2010-05-12
  • Posts: 13

Re: backup mail account and upgrade

I format the server again and made the umgrade from 0.5.1 to 0.7.0.
I'm making some tests, I tinkk thats work now.
some times is more easy and faster format and restart than find and solve the problem.
(Don't punch  in a knife)

thanks to everybody  !