Migrate flarum to another server

matunixe

Hey,

I taked many times to find how migrate our nice Flarum install. That's how we do it:

Backup your DB on the ancient host:

mysqldump --lock-tables -h [server] -u [user] -p[password] [database] > flarum-sqlbkp_`date +"%Y%m%d"`.bak

Backup your data on the ancient host:

rsync -Aax flarum/ flarum-dirbkp_`date +"%Y%m%d"`/

Download all of this on your new host:

scp -r user@host.lol:flarum-* .

Create new DB:

mysql -u root -p
CREATE DATABASE flarum;
exit

Restore old DB on da new:

mysql -h [server] -u [username] -p[password] [db_name] < flarum-sqlbkp.bak

Do a fresh install of flarum as described here: http://flarum.org/docs/installation/

Restore some of the old data on your new installation:

cd flarum-dirbkp/
cp -Rv config.php storage/ assets/ /var/www/fresh-new-flarum/

Reinstall your extensions and it's done !

Hope this little tutorial will help some folks.
Cheers,

jordanjay29

matunixe Don't forget to update the URL and database credentials for your new server if they have changed.

justshipit

matunixe thanks for this!

Could you explain:

"on the ancient host:" - means I run this on the old server's terminal or my local machine terminal?
I understand I don't use square brackets [] where server, user, password, database is?
In [server] I put IP of the old server where DB is?
[user] is DB user or server user?
[password] is password to DB or server?
Is there no space between -p and [password] in -p[password]on purpose?

So many questions, perhaps you could edit your post to include it ?

justshipit

matunixe I am getting:

mysqldump: Got error: 2003: Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (61) when trying to connect

bertaveira

matunixe When you do the fresh install do you use the restored database or do you create a new one? I am trying to use the restored one and I get this error:
error

I am not sure it is because of the database not being empty but it looks like it...

EDIT: you have to create a new database and then go to config.php and change the database by hand... then when you access the website again you will be prompt to insert the password for the database again and it will restore the old database.

jacko

to avoid downtime during DNS propagation, you may also point the old website to the new database

I did that and it worked.

7h3ev1l

justshipit 6. no space ? but better dont enter the password in command line it will ask you to enter.

Actually much easy is to zip the root directory of your site, and just to export the db. Then unzip the root directory of your flarum on the new host and import the new database. Change urls if need and database details and you are done.

justshipit

7h3ev1l what will be easier way to save old DB so later I can import to new Flarum? I am switching droplets on Digital Ocean and that's why I need to migrate DB.

7h3ev1l

justshipit Well you cant connect to the server ? Use phpmyadmin if you cant operate with command line.