skywise Posted October 3, 2014 Share Posted October 3, 2014 So, I have an old froxlor setup on ubuntu (10.x) that I'd like to update. Figure the best supported system that I'm used to managing would be debian based. Current froxlor version is 0.9.27 and mysql is 5.1.x What's the best way to move the database itself over? Link to comment Share on other sites More sharing options...
skywise Posted October 7, 2014 Author Share Posted October 7, 2014 New system just went live. Main steps were: 0. configure froxlor on new system (setup config files and so on) 1. mysqldump --password=securePassword --user=froxlor froxlor >froxx.out (on old system) 2. copy froxx.out to new system. 3. cat froxx.out | mysql --user=froxlor --password=newSecurePassword froxlor 4. cd /var;rsync customers newsysIP:/var/ 4a. When I logged into froxlor on the new system, it noticed that it had been upgraded and offered to update the DB for me. 5. cutover IPs of old and new. That's about it. There were a few glitches once I got going, (apache SSL, auth in SMTP, clamAV scanning) but these weren't major and just needed some config fiddling. Link to comment Share on other sites More sharing options...
skywise Posted October 7, 2014 Author Share Posted October 7, 2014 BTW, rainloop is a very nice webmail system, wasn't hard to install at all. (was using roundcube, decided to try rainloop with the new system) Link to comment Share on other sites More sharing options...
Shortie Posted October 7, 2014 Share Posted October 7, 2014 BTW, rainloop is a very nice webmail system, wasn't hard to install at all. (was using roundcube, decided to try rainloop with the new system) But with one limitation that prevent the use of it in a business environment: You are free to use RainLoop Webmail for your personal or non-profit projects. Link to comment Share on other sites More sharing options...
d00p Posted October 7, 2014 Share Posted October 7, 2014 Your steps are not complete...you're just dumping the froxlor-database. what about the customer-databases? What about the "mysql"-database which holds all the user/password of the customers? I told you about that earlier.... Link to comment Share on other sites More sharing options...
skywise Posted October 8, 2014 Author Share Posted October 8, 2014 But with one limitation that prevent the use of it in a business environment: You are free to use RainLoop Webmail for your personal or non-profit projects. Luckily, my little ISP in a box is hobby and I don't charge my friends for hosting their domains. But good point for others thinking to use it. Link to comment Share on other sites More sharing options...
skywise Posted October 8, 2014 Author Share Posted October 8, 2014 Your steps are not complete...you're just dumping the froxlor-database. what about the customer-databases? What about the "mysql"-database which holds all the user/password of the customers? I told you about that earlier.... For me, they are. My customers don't have databases, all I have is froxlor. I'm assuming the user/passwords you're referring to are for the customer databases (that I don't have ) Link to comment Share on other sites More sharing options...
d00p Posted October 9, 2014 Share Posted October 9, 2014 Well then...great. Link to comment Share on other sites More sharing options...
d00p Posted October 3, 2014 Share Posted October 3, 2014 Well, you not only have to transfer the customer- and froxlor-databases but also the "mysql" database as well, as it includes all the users, passwords and permissions of the databases. I only transfered from and to the same distro so i cannot tell you for sure if this is going to work. But you definetly need to run the "mysql_upgrade" command on the new system (there's a newer mysql-version for sure ). Updating froxlor itself is no big deal. It's just files and a few databases changes that froxlor does itself after copying the new files. But don't forget to backup! Link to comment Share on other sites More sharing options...
skywise Posted October 3, 2014 Author Share Posted October 3, 2014 Luckily these are all VMs so I can keep the old system alive/well until I'm sure I've gotten the new one right. The move of /var/customers should be pretty easy since I can keep everything alive until I get it right, just rsync them from time to time. My biggest worry is the mysql database, I'm not much of a DBA, know enough to get myself in trouble. Link to comment Share on other sites More sharing options...
d00p Posted October 3, 2014 Share Posted October 3, 2014 well, there are always people who like to assist you with your plans @ https://froxlor.support/ Link to comment Share on other sites More sharing options...
Question
skywise
So, I have an old froxlor setup on ubuntu (10.x) that I'd like to update.
Figure the best supported system that I'm used to managing would be debian based.
Current froxlor version is 0.9.27 and mysql is 5.1.x
What's the best way to move the database itself over?
Link to comment
Share on other sites
10 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.