NearBeach 0.30 has restructured it's database. This is to counter many problems with both the structure and the code.
Backup your database
Always backup your database. We will be migrating from this database to another database.
The source database won't be edited. Setting up 0.30 on the original database will be too hard and complicated due to the multiple moving parts. It is easier to create a new database to migrate too.
Create a new blank database (we'll call this the destination database). Either apply the old user to this database or create a new one.
Once the database has been created - run the following SQL within it. It will create the schema for NearBeach. Please note - it will delete stuff inside the database.
Copy the code below and modify the parameters with the appropriate values. This file will be stored next to the python file. The passwords will be referenced and used to log into the source and destination database.
The source database is the old database of version 0.29
The destination database in the new database of 0.30. This database has the latest structure
https://virtualenv.pypa.io/en/latest/user_guide.html <- create a virtual environment, and source into it
Install the following python libraries using pip
Download the script below and run it.
Update your NearBeach instance to 0.30, and change the database to the new database. Everything should connect as before. If you have any issues, please visit our discord server.