What is the best way to move a flarum to another server

MikeJones

I am essentially stuck trying to upgrade my Ubuntu server and I am thinking of spinning up a new aws instance on the latest version and moving my flarum to there. What is the simplest/quickest way to do this?

tankerkiller125

MikeJones Dump your MySQL database, import it to your new servers, copy ALL of your forum files except for the vendor folder. Run composer install in the new server. And from there you just need to update the config.php to be correct for your new host and then your basically done (other than DNS changes)

Don't forget to copy your nginx/apache config as well since that will probably make life easier, along with any SSL certs from your existing server.

MikeJones

tankerkiller125 And from there you just need to update the config.php to be correct for your new host and then your basically done (other than DNS changes)

If I am using aws and an elastic IP I shouldn't have to make changes here right? IP and dns would change just have to point the elastic IP at the new aws instance I think.

tankerkiller125

MikeJones That sounds correct yes

[deleted]

MikeJones the elastic IP bound to the network interface of the AWS instance. If this is the case, you'll need to remove it from the current machine to be able to reuse it.

cmwetherell

Amazon Lightsail provides an option to take a "snapshot". It takes a backup of everything, including databases, and allows you to create a new instance with all the data. I think you already got good advice but that was a super easy process for me when I wanted to upgrade my server.

MikeJones

[deleted] yea I would just spin up a new ec2 I stance on latest ubuntu get my flarum back up and running on it and point the elastic IP to the new instance.

MikeJones

tankerkiller125 So I set up an entirely new server last night on aws. But I am having issues dumping my database:

mysqldump -u root -p Flarum_seekadventurenet > database.sql

I just get this:

-bash: database.sql: Permission denied

I then tried with my username I use in my flarum config file instead of root and also tried both with sudo infront of the mysqldump command...

Any Ideas?

clarkwinkelmann

MikeJones this is not a database error, this is a filesystem error. Your current bash user is unable to write to a file named database.sql.

You might want to connect as a different bash user, or write the file to a different location.

MikeJones

clarkwinkelmann sudo wouldn't give me permission to write there? I can create files and directories there with sudo... I am a little confused.

clarkwinkelmann

MikeJones you might want to try sudo mysqldump [...] if you're trying to run the command as the root BASH user.

Right now you're dumping as the current BASH user, but fetching the data as the root MySQL user.

MikeJones

clarkwinkelmann Yea I think I wasnt explaining myself right this is what I did try:

sudo mysqldump -u root -p Flarum_seekadventurenet > database.sql -bash: database.sql: Permission denied

really odd.

MikeJones

So I found out I could get the command to run if I was in my /home/ubuntu directory....

I had some issue trying to dump, but was able to get it to work with mysqldump --no-tablespaces -u dbUserName -p dbName > db_backup_file.sql

Do you think I will have issue with the no tablespaces command when trying to get my database in my new aws instance?

clarkwinkelmann

MikeJones I don't know enough about tablespaces. I don't know whether Flarum uses them 😅

Summoning @tankerkiller125

tankerkiller125

clarkwinkelmann I have no idea on table spaces either.... I don't think we have an issue with that though?