For a little background, we’ve had this server up for about 8 years, and it has grown to close to 400 GB. We’re on version 3.15 now and want to move to the latest version. The latest version requires several prerequisite updates that we don’t currently have like PHP, mysql, a new database table format, etc.
These are both linux implementations using mysql databases.
We had several issues updating these prerequisites and decided it would be best to stand up a new server and migrate database and moodledata folder over.
The site loaded the data, proper site name, and acts like it was running successfully, but we couldn’t login. At that point we began to speculate that the change in the database table format, so we dropped the database, created a blank one and did a fresh install of the moodle server. We re-ran the mysql backup using the switches
--no-create-info --no-create-db to make a backup of the data without it recreating the database and tables. On first attempt to import this we received an error that the adodb_logs table didn’t exist. Manually created the table with proper colums and tried the import again and received another error that another table was missing. The missing table looked like it was for one of the plugins so we added the -f switch to the import to have it skip the errors and keep importing data. After importing this into the new database we logged in with the local administrator account. We were able to see data such as the user accounts but it looks like other data was missing such as the classes did not pull over and none of the formatting or anything else. What might we be missing?