Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon
Server setupIGCNS16, S17, S18

Why did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?

Isinulat ng MuADMINS mula sa sourceNot verified

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, Ranking and BattleCore before creating them again.
  • DECLARE @Create_Me_MuOnlineDB INT = 1: creates Me_MuOnline, used "for purpose of Shared Accounts system".

Before running it:

  1. Never run it on a server that already has players. Back up every database first:
BACKUP DATABASE [MuOnline] TO DISK = N'C:\MUBackup\MuOnline.bak' WITH INIT;

(the same for Me_MuOnline, Events, Ranking, BattleCore).

  1. Set @DropExistingDatabases to 0 unless you really want empty databases.
  2. Every FILENAME line contains the placeholder <INSTANCE_NAME> (for example C:\Program Files (x86)\Microsoft SQL Server\<INSTANCE_NAME>\MSSQL\DATA\Me_MuOnline_Data.MDF): replace it with your real data folder or CREATE DATABASE fails with "Directory lookup for the file ... failed".
  3. The script creates each database with COLLATE SQL_Latin1_General_CP1_CI_AS. Change it here, before any table exists, if you need another code page (see the collation solution).

Source: IGCN Season 16, 17 and 18 Database/1. Full Scripts/CreateDatabase.sql (same 3408 byte file in the three packs).

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.