Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon

What breaks a MU server database? Safe SQL checklist before you run a query

Isinulat ng MuADMINS mula sa sourceNot verified

What breaks MU databases most often, and what the pack files themselves show:

  1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scripts: "Take server offline before proceeding").
  2. No WHERE: UPDATE Character SET ... without WHERE changes every character. Always SELECT with the same WHERE first.
  3. Running a full creation script on a live database: IGCN CreateDatabase.sql has @DropExistingDatabases = 1 (drops MuOnline, Me_MuOnline, Events, Ranking, BattleCore); full MuOnline scripts create the tables again. On a live server use only the update scripts, in version order (IGCN: BattleCore before MuOnline of the same version).
  4. Password form not matching the server setting (IGCN PasswordEncryptType, MuEmu MD5Encryption) or the website setting (WebEngine none / wzmd5 / phpmd5 / sha256).
  5. Missing procedures after a website install: DmN setup drops and replaces WZ_CONNECT_MEMB / WZ_DISCONNECT_MEMB.
  6. Dropping primary keys (some Unicode migration scripts do it and never put them back): duplicates and slow queries follow.
  7. Collation: keep it case insensitive (IGCN documentation); all databases of one server on the same collation.
  8. Version: a backup never restores on an older SQL Server than the one that made it.

Always:

BACKUP DATABASE [MuOnline] TO DISK = N'C:\MUBackup\MuOnline_before_fix.bak' WITH INIT;

and try risky changes on a copy (RESTORE ... WITH MOVE into MuOnline_test).

Source: IGCN CreateDatabase.sql and Maintenance Scripts, IGCN 2. Update Scripts/README.txt, DmN CMS 1.2.3 setup, WebEngine 1.2.7 install/definitions.php; Microsoft RESTORE documentation (version rule) as noted in the MuADMINS SQL guide research.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.