Banco De Dados
All content about Banco De Dados — 31 results.
Banco De Dados
How to migrate characters between accounts in MU Online
Learn how to transfer characters from one account to another on your MU Online server through the database, preserving items, guild, and data integrity.
How to diagnose a specific slow SQL query in your MU Online server's database
Find and fix the specific query that's choking your MU Online server's database, using execution plans, indexes, and SQL Server's Profiler/Extended Events.
How to Implement a Strong Password Policy for MU Online Players
Implement a strong password policy on your MU Online server's account registration, with complexity rules, secure hashing in the database, and two-factor authentication to reduce account theft.
How to generate automated economy reports for your MU Online server
Build an automated reporting pipeline that monitors Zen in circulation, item inflation, jewel drops, and the overall health of your MU Online server's economy, with ready-to-use SQL queries and configurable alerts.
How to restore a character and items from backup in MU Online
Learn to restore lost characters and items from a backup in MU Online surgically — without overwriting the whole server, without creating dupes and without breaking the economy.
Useful bulk Game Master scripts for your MU Online server
Automate repetitive Game Master tasks on your MU Online server with bulk scripts: item distribution, bans, mass resets, inactive account cleanup, and scheduled announcements.
How to recover an account with a lost password on your MU Online server
Set up and run a secure password recovery process for your MU Online server's players, including identity verification, web panel reset, and direct database reset when needed.
How to restore an item lost to a bug in MU Online: support and database restoration guide
Learn the complete process for investigating and restoring items lost to bugs in MU Online, from ticket triage to safe database restoration, without opening the door to fraud.
How to automate your MU Online server's backup to Google Drive
Set up an automatic pipeline that dumps the database and critical files of your MU Online server and uploads them to Google Drive via rclone, with rotation, encryption, and failure alerts.
How to implement an admin action audit log on your MU Online server
Set up a complete audit log system for GM commands and administrative actions on your MU Online server, covering the database, log files, and retention best practices.
How to resolve character duplication after a crash on your MU Online server
Diagnose and fix character, inventory, and Zen duplication caused by a GameServer crash or a dropped connection in MU Online, including database queries, safe rollback, and prevention via asynchronous saves.
How to scale the database (replicas and hot backup) in MU Online
Learn to scale your MU Online server's database with read replicas and hot backup to handle more players without losing items or accounts.
MySQL tuning for MU Online servers: the complete performance guide
Tune MySQL parameters to support high concurrency on MU Online servers: buffer pool, indexes, connection pool, slow query log, and maintenance routines.
Security incident response for MU Online servers: a complete guide for administrators
A security incident response plan for MU Online private servers, covering intrusion detection, containment, compromised database analysis, community communication, and recurrence prevention.
How to recover a MU Online server after a hack
A complete action plan for recovering a MU Online server after a hack: contain the attack, identify the vector, restore backups, reset credentials, and communicate with the community without causing panic.
Incremental vs. full backup for MU Online servers: which to choose
Understand the differences between full, incremental, and differential backups for MU Online servers, with script examples, retention rotation, and a testable disaster recovery plan.
MySQL Master-Slave replication for MU Online servers
Set up MySQL Master-Slave replication step by step for your MU Online server's database, with GTID, lag monitoring, and a procedure for promoting the slave in case of master failure.
How to fix special character encoding errors on your MU Online site and server
Diagnose and fix encoding issues (accents and special characters showing up as garbled symbols) on your MU Online server's site, database, and game client, covering UTF-8, Latin1/ANSI, and the client's legacy encoding.
How to migrate MU Online emulators without losing the database
Switch MU Online emulators (IGCN, MuEMU, X-Team, Season 6 → a new season) while preserving accounts, characters, inventory, and Warehouse: SQL Server backup, table mapping, schema adjustment, and testing before opening to players.
How to manage guilds and alliances through the database in MU Online
Learn to administer guilds, ranks, members and alliances directly through your MU Online server's database tables, with safe SQL and good backup practices.
Database redundancy for MU Online servers
Implement database redundancy on your MU Online server using replication, automatic failover, and multi-layered backups to avoid lost progress and prolonged downtime.
Partial vs total wipe in MU Online: how to do it right
Understand the difference between a partial and a total wipe in MU Online and carry each one out safely, preserving accounts, rankings and the economy when needed.
How to migrate your MU Online server from a VPS to a dedicated server
Plan and execute the migration of your MU Online server from a shared VPS to a dedicated server, with a hardware checklist, DNS cutover, database migration, and a maintenance window with zero data loss.
How to Fix a Corrupted Database Error on Your MU Online Server
Diagnose corrupted tables in your MU Online server's MySQL/MariaDB, safely recover character and item data, and implement a backup routine to prevent permanent progress loss.
How to test your MU Online server's disaster recovery plan
Learn to build, and above all actually test, a disaster recovery plan (DRP) for your MU Online server, with simulations of database failure, host failure, and data corruption, plus RTO and RPO metrics.
How to optimize SQL Server for many players in MU Online
Tune memory, tempdb, recovery model and SQL Server settings so the MuOnline database can handle hundreds of simultaneous players without stalling login or character saves.
How to Fix Time Desync Between MU Online Servers
Diagnose and fix time synchronization issues between GameServer, ConnectServer, JoinServer, and the database in MU Online, avoiding events firing at the wrong time and authentication failures.
Migrating legacy password encryption to a modern scheme on your MU Online server
Understand the risks of legacy password schemes (raw MD5, unsalted SHA1) used on old MU Online servers and learn how to migrate to modern hashing (bcrypt/Argon2) without forcing every player to reset their password at once.
How to create a plugin for your MU Online server's WebEngine
Learn how to structure, code, and publish your own plugin for your MU Online server's WebEngine (web panel), integrating rankings, voting, the shop, and commands with the game database.
How to segregate your MU Online server's database network
Isolate the accounts, characters, and items database of your MU Online server into its own network, with IP-restricted access, least-privilege service accounts, and encryption in transit.
How to prevent SQL Injection in legacy forms on your MU Online server's website
Identify and fix SQL Injection vulnerabilities in legacy PHP panels for MU Online servers — from login and ranking forms to donation pages — using prepared statements, input validation, and hands-on testing.