z[Deprecated] Upgrading from DockerBox to Pilothouse - Pilothouse-App/Pilothouse GitHub Wiki
Note: This information is no longer relevant, and will soon be removed.
Due to the name change from DockerBox to Pilothouse (#30, #44) a number of things have changed that will require action on your part to keep from losing data. Of most concern is the MySQL data, which will be lost due to the container name changing. Follow the following steps to backup your MySQL databases, upgrade to Pilothouse, and import the backed up data.
-
Make sure you are using Docker 1.13 or higher, and that you are on a commit prior to the one in which I renamed everything. Running
git checkout a0f282bfdb0ff3fe8d07771baf792a4a04697590
will put you where you want to be. -
Start DockerBox if it's not already running
dockerbox up
-
Export all databases to one file,
mysql.sql
, stored in the DockerBox root directory. Change to the Dockerbox root directory and run the following command:
dockerbox compose exec mysql /usr/bin/mysqldump -u root -proot --all-databases > mysql.sql
-
Shut down DockerBox
dockerbox down
-
Pull the latest changes from GitHub
git checkout master && git pull --ff
-
If you have a
dockerbox.ini
file, rename itpilothouse.ini
-
Start up Pilothouse
pilothouse up
-
Copy the mysql backup file into the mysql container
docker cp mysql.sql pilothouse_mysql_1:/mysql.sql
-
SSH into the mysql container
pilothouse compose exec mysql /bin/sh
-
Inside the container, import the database backup
mysql -u root --password=root < /mysql.sql
-
Verify through Sequel Pro or something that the databases have been imported successfully.
-
Delete the mysql backup from the container (it will still exist on the host)
rm /mysql.sql
-
Exit the mysql container
exit
-
Clean up the old docker containers from your system
docker system prune
[answer y] -
Rename the
dockerbox
directory topilothouse
and update your shell include path. -
Update the Xdebug IDE key in your projects to
pilothouse
-
Once you have verified that all the database data has been migrated and everything is well, delete (or save for a long-term backup) the mysql.sql file from the pilothouse directory.