Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen
← Alle Lösungen

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

Von MuADMINS anhand der Quelle geschriebenNot 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.

Von MuADMINS geschrieben
Hat das geholfen?

Kommst du immer noch nicht weiter? MuGPS durchsuchen Frag den MU-Assistenten

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.