MuADMINS
Solutions
Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.
15 solutions for “delete” in Server setup · Clear
SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Confirmed by the topic starterTUServerMU · 2021-03-30Louis files: after testing the auction system no new auction starts (or it starts and ends at once).
1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...
✓ Confirmed by the topic starterCreandoMU · 2020-12-02How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them
The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...
✓ Confirmed by the topic starterTUServerMU · 2021-05-09Why 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 verifiedWritten by MuADMINSOpenMU: after a restart all my configuration and data were gone and the database was initialized again.
1. With Docker the Postgres data must live in a volume. 2. The provided docker-compose files persist it in volumes, so the data was lost because the volumes were deleted or the setup did...
✓ Confirmed in the issueGitHub (MUnique/OpenMU) · 2023-11-11After restoring an old backup, characters with the same name can be created on different accounts.
1. The name primary key was lost. 2. Delete the duplicated rows one by one. 3. Restore the primary key before allowing new characters.
✓ Confirmed by the topic starterImperyus Games Brasil · 2010-12-170.97d: every item (even shop items) gets serial 00000000.
1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...
✓ Confirmed by the topic starterImperyus Games Brasil · 2013-05-26DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed
The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...
✓ Confirmed by the topic starterDarksTeam · 2010-03-09After changing the client name in the main info and replacing Main.premium, the login box (ID and password) no longer appears (files with MHP)
The Mu Hack Protection server config still had the old customer name. 1. Open C:\MuServer\MHPServer\MHPServer.ini and set CustomerName to the new name, with the right ClientVersion and Cl...
✓ Confirmed by the topic starterTUServerMU · 2021-03-27DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)
1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...
✓ Confirmed by the topic starterRaGEZONE · 2018-04-09Two MuEmu S8 servers on one machine: the first works, the second disconnects at login although its ports (55902, 55920, 55961, 55971) are forwarded.
1. Open the router page and check that the forwarding rules for the second server ports are really enabled, not only created. 2. If a rule turns itself off again after a refresh, delete i...
✓ Confirmed by the topic starterTuServerMU · 2020-06-17MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?
1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...
✓ Confirmed by the topic starterTuServerMU · 2018-06-06Unicode (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 verifiedWritten by MuADMINSWhat is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedWritten by MuADMINSOpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?
1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION...
Videos on MUTube
HOW TO REMOVE FPS LAG IN MUONLINE - DEFINITIVE SOLUTION - TEST PHASE
Gui PvP · 8:52 · 2024
Mu Online Tutorial 26: How to remove the bonus option from a socket item?
NaQuEvEr · 7:52 · 2025
How to ELIMINATE the LAG in MU Online * Without Programs* #muonline #antilag #mmorpgs
JeongGuwonYT · 7:07 · 2020
Remove/change the Print Screen logo of the MuOnline emulator
Josue Ochoa · 22:36 · 2022