Jump to content

Ephestion

Members
  • Posts

    8
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About Ephestion

Profile Information

  • Gender
    Not Telling

Ephestion's Achievements

Newbie

Newbie (1/16)

0

Reputation

  1. Well I exported the entire database as an sql which I could not read back into the server if i needed to restore the database. So I was lucky that the new OS and the installation accepted the backup SQL's. Everything is running better except some script issues. But my initial question remains unanswered and from a technical point of view would like to know if the only way is to develop some kind of custom script to perform the backup.
  2. My game server has a 5 min approx. I had to even increase the timeout parameters for many things including the java timeout parameters. Also it has only 4GB Ram and Celeron CPU but win xp is seeing 3.4GB RAM. It's slow and when I used regular SQL dump it puts everything in one file (eventually). But when so much data is in one file it causes it load into memory and that is when the PC hangs. I can't import large SQL's on this system. Which is why I need to find a thinner system that can optimise more memory. Those links don't help me: shell> mysqldump [options] db_name [tbl_name ...] Need to manually know the name of every table and run it individually for each table shell> mysqldump [options] --databases db_name ... dumps entire database in one SQL shell> mysqldump [options] --all-databases ..... dumps each database into a single SQL is there are command for example C:\mysql\bin mysqld uname psswrd dbase "tables" and auto dump for each table in database?
  3. 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.
  4. I require information and tools needed to patch H5 system folder. I mainly need to change some settings to allow H5 to connect to Private test server. Best way to achieve this and how? I have tried to use old tools like Lige and L2encdec but without success. I have in the past used game guard emulator but it doesn't work anymore. So if you mention a tool could you also direct me to a brief and accurate tutorial explaining the process. Thankyou.
  5. Freya-HiFive L2J Server Error on: D:\MyL2JServer\game\data\scripts\custom\555_NPCBUFFER\__init__.py.error.log Line: -1 - Column: -1 Traceback (innermost last): File "__init__.py", line 4, in ? ImportError: no module named net Line 1 Column 1 = import sys Line 4 = from net.sf.l2j import Config Anyone know what changes to make?
×
×
  • Create New...