Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions

SQL query to delete only characters and guilds but keep the accounts and their warehouse

✓ Confirmed by the topic starter
  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. MEMB_INFO (accounts) and warehouse stay as they are. Check your files for other character tables that point to deleted names and test login before opening.

The topic starter confirmed that this worked.

Original words (Portuguese)

“Muito obrigado”

The topic starter, 2021-03-30 (original words)
TUServerMU · 2021-03-30
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.