I'm using Moodle 3.5.2 and I just looked at Admin>Server>Environment and saw my database is still Antelope instead of Barracuda. I know how to convert it via myPHPadmin because I did it during installation with another site but I'm worried I could screw up my data if I converted it on my live site(a few thousand student records over a few years that I added this past week via restoring courses from a very out-of-date 2.6 site ).
Is there any risk the format conversion could have a negative impact on the data?
I am no expert on Antelope vs Barracuda but there is always a risk when you start modifying databases.
I worked as a lead developer creating database scripts and stored procedures. Our standard method was:
- Any change I made to a database was a script which I checked on my development machine.
- The analyst then checked and passed the script independently on another copy of our database
- I made the change using the script on the clients test database and it was signed off by the client as correct
- I then applied the script to the client's production server. Usually at 6 am after the nightly backup was verified as complete to give the client a couple of hours to lock the system and check my work before the staff were able to start processing. Any problems would result in a rollback to the backup.