Restoring projects from cli?

[ScottHammond]

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?

[dgildelaig]

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

[ScottHammond]

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

[dgildelaig]

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

The default password is "paloalto"

[ScottHammond]

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.

[dgildelaig]

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

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