I know how to do basic MySQL backups and have some scripts that I have used in the past. But I am having trouble with an old machine that I decided to setup as a server. None of the modern software I used to use works with the XP 32bit system. I hav elost my license for Navicat so I have been trying to find a way with MySQL GUI tools (the older versions of MySQL Workbench). I have tried to type out the manual commands for - mysqld but I am not getting expected results.
So I am in a bit of a situation because I want to format the HDD and take off Win 32 and put on a system that can operate with more than 4GB RAM and run overall better. Before I can do that I need an effective way to backup the entire L2GLS, L2JGS, L2GCS databases and make sure that I can dump each table in a separate file so I can then put them back into their respective folders when I want to run the default database installation file.
The Tables must be separate SQL files for two main reasons, the PC doesn't have the computing power or memory to process a full database dump of the Game Server and secondly as I mentioned above, it makes it easier to install the backed up files on the new Operating System. Please provide authentic solutions as I have read many articles but non clearly stipulate how to backup a database table by table for each database.