Passbolt CE Migration database import issue

Installation Issues
1

Checklist
I have read intro post: https://community.passbolt.com/t/about-the-installation-issues-category/12
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue

Hi Community,

I am trying to migrate a passbolt CE 4.12.1 server running on ubuntu 24.04 to another ubuntu 24.04 server. Following the migration guide found here

I am currently trying to migrate between cloud providers and as a part moving the passbolt server.

I am facing issue when import the backup data base file into the new database.
I get this error

ERROR at line 1: Unknown command '\-'."

After this error it looks like the data was successfully imported and the passbolt healthcheck reports 34 tables found, but all of the tables are empty with no content in them.

Backup was taken as per the backup guide.

My old passbolt instance is hosted on DigitalOcean and used the preconfigured ubuntu passbolt image.

Apon looking around a bit I could see that passbolt package installed MySQL server for the DB although my previous DigitalOcean instance used MariaDB.

For now I have switched back to the DigitalOcean instance, I dont want to manaully export passwords and bring them into the new instance, as there are multiple users.

2

Hello @2Face !
I had a similar error a few days ago and fixed it by changing the encoding to UTF-8 using Notepad++ in the database backup before importing.
Could you try this and let us know if it worked?

1 Like
3

Thank you @Termindiego25,
I tried by converting the backup file using Sublime Text but still get the same error and I cannot login using my user as I get this error,

image
image582×489 19.4 KB

4

Update

Just testing on a local Debian 12.9x VM I setup Passbolt as per the migration guide for Debian, the DB was correctly imported without any errors, from the latest automated backup. I have setup ansible to do this automatically with Github workflows to do this every 24 hours.
I confirmed that this and the last backup I used were all fine and didn’t have any errors with them.

I couldn’t full test the instance as the local VM with no public IP and DNS issues. I might just migrate to Debian from Ubuntu, although I would have liked to keep Ubuntu as I use Landscape for automatic updates.

Will test on a Debian VM in the cloud and update.

1 Like
5

Update 2

Successfully migrated the instance onto Debian 12 cloud instance. Don’t know why Ubuntu 24.04 had this issue.

Thank you @Termindiego25 your advice came in handy.

2 Likes