MuADMINS
Soluciones
Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.
13 soluciones para “drop database” · Limpiar
Why did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedEscrito por MuADMINSI cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?
1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...
✓ Confirmado por el autor del temaTuServerMU · 2018-01-06MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1
1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...
✓ Confirmado por el autor del temaRaGEZONE · 2014-02-11OpenMU crashes on startup after a failed data import left the database tables without a GameConfiguration.
1. Older builds crashed when the tables existed but no GameConfiguration row did. 2. Update to a build containing PR #910 (September 2026): the server then starts and the admin panel offe...
✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-08-27What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedEscrito por MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedEscrito por MuADMINSWhat breaks a MU server database? Safe SQL checklist before you run a query
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 scrip...
Not verifiedEscrito por MuADMINSOpenMU admin panel: the Setup page says 'Can't connect to the database, probably not created yet' or 'Update required'
1. Open Setup (/setup). It shows the state of the database. 2. *Can't connect to the database, probably not created yet* or *Not created*: click Create, pick the game version (Season 6 Ep...
Louis (MuEmu) server ran out of item serials: every new item gets serial FFFFFFFF and is flagged as a dupe.
1. Serials come from the stored procedure WZ_GetItemSerial, which increments ItemCount in table GameServerInfo for every created item (drops, bags, commands). 2. Edit that existing proced...
✓ Confirmado por el autor del temaRaGEZONE · 2024-08-02OpenMU: which start parameters and environment variables exist (-autostart, -reinit, -demo, DB_HOST) and when do I need them?
1. Most of these settings are easier to change in the admin panel under Configuration, System; parameters are for special cases. 2. -autostart initializes the game servers and starts all...
OpenMU starts with -demo but -reinit fails: Postgres says column ExcellentItemDropLevelDelta of GameConfiguration does not exist.
1. Two recent EF migrations were not picked up during a Postgres reinit, so the table was created without the new column. 2. Update your OpenMU checkout or image to a build that contains...
✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-04-11Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedEscrito por MuADMINSOpenMU: after an update a game server stays stopped or the admin panel shows pending updates. How do I apply configuration updates?
1. New versions bring changes to the game configuration data (monster stats, drop groups, plugin configurations, quests). They are not applied to your existing database by the software up...