Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones

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

Escrito por MuADMINS a partir de la fuenteNot 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.

Escrito por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.