topic Re: Restoring projects from cli? in Expedition Discussions

Restoring projects from cli?

ScottHammond — Wed, 04 Mar 2020 19:26:38 GMT

So my expedition GUI died and I couldnt get it back. I copied the projects directory out and into the same directory on the new one. But the GUI isnt seeing the projects that were imported via cli.

Is there hope?

Re: Restoring projects from cli?

dgildelaig — Thu, 05 Mar 2020 09:59:33 GMT

You are on the right direction.

Besides the projects being copied in the correct path /home/userSpace, you would also have to do a backup of the databases and restore them in your new Expedition.

You can use mysqldump CLI command to create a file that contains all the databases that you have in your expedition.

Even we use MariaDB, this information would work for your case:

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html

Re: Restoring projects from cli?

ScottHammond — Thu, 05 Mar 2020 14:11:17 GMT

Makes sense. Is there a particular argument for a password?

root@Expedition:~# mysqldump --all-databases > dump.sql
mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect

Re: Restoring projects from cli?

dgildelaig — Thu, 05 Mar 2020 18:00:48 GMT

You would have to provide the valid password for the sql connection.

The default password is "paloalto"

Re: Restoring projects from cli?

ScottHammond — Mon, 09 Mar 2020 13:36:42 GMT

yeah it doesn't work. Running it as root even....its some other password internal down in the weeds password. I tried every default.

Neither here nor there, I gave up and rebuilt the projects from scratch. Wasn't all that far into them.

Re: Restoring projects from cli?

dgildelaig — Mon, 09 Mar 2020 13:57:25 GMT

I am confident that, unless you changed the password, "paloalto" should work:

mysqldump -uroot -ppaloalto --all-databases > dump.sql