Usually when I read about common issues like these, just by coincidence, many seem to mention the use of VM's and/or windows 10.
I don't use either. I stick to windows 7 on a dedicated box with straight MySQL and I never have problems with installing or
running the necessary apps to compile or run the server, along with 3rd party database editing tools. I don't need to run an extra
database for development, I just edit the one I am playing on and frequently run a backup from a batch file I made and put it in
the folder where I want the backups to go. I just call it Dump.bat with this in it:
mysqldump --routines -u root -p***** peq > peq_backup.sql (I usually rename that output file with date added after)
Most database edits can be applied on the fly without restarting the server, by running shared_memory or using ingame #commands.
|