Cum sa setezi o baza de date [Ascent] [Windows]

Tutoriale care va vor ajuta sa va creati propriul server WoW

Cum sa setezi o baza de date [Ascent] [Windows]

Postby Duster » 18 Sep 2007, 18:20

Pasul 1: Downloadarea fisierelor necesare


1. Downloadam MySQL Server v5.0.45 -- download
2. Downloadam Navicat -- download
3. Downloadam sursa ascent de pe svn://emupedia.com/svn/ascent ( Trebuie un client SVN, gen Tortoise )

Pasul 1: Instalarea MySQL Server

1. Deschidem fisierul mysql-essential-5.0.45-win32.msi
2. Next
3. Selectam Typical ( Common program features will be installed. Recommended for general use)
4. Install
5. Next -- Next
6. Lasam activata optiunea "Configure the MySQL server now" si selectam Finish
7. Ni se va deschide o alta fereastra, selectam Next
8. Alegem optiunea "Standard Configuration"
9. Lasam selectata optiunea "Install as Windows Service"
10. La service Name lasam MySQL si de asemenea lasam optiunea Launch the MySQL Server atuomatically selectata
11. Click Next
12. La Modify Security Settings introducem root pass si o confirmam
13. Apasam Next apoi Execute
14. Dupa ce termina de incarcat selectam Finish

Pasul 3: Instalarea Navicat

1. Instalam Navicat

Pasul 4: Configurarea Bazei de date


1. Deschidem Navicat
2. Mergem la File - New Connection
3. La "Connection Name" puneti ce vreti ( ex: wow.ultimate.ro )
4. La username lasam root si la "Password" punem parola root care am setat-o cand am configurat MySQL Server
5. Apasam OK
6. Mergem la wow.ultimate.ro si apasam click dreapta - Open connection
7. Apasam iar click dreapta - Create new database
8. La "Enter Database Name" scriem ascent si apasam OK
9. Apasam dublu click pe ascent si apoi Click Dreapta - Execute Batch File
10. Mergem in NCDB_-_Milestone_0.1\NCDB - Milestone 0.1 si incarcam database.sql (ATENTIE: trebuie mai intai s-o dezarhivati din fisierul database.rar )
11. Bifam Continue on Errors si apasam OK
12. Repetam aceeasi operatie cu fisierere *.sql din ascent\sql ( ATENTIE: fara fisierul clean_db.sql )

Pasul 5: Crearea unui cont de GM


1. Mergem in Navicat, baza de date ascent, deschidem tabelul accounts si il completam astfel

acct: 1 (sau alt numar atata timp cat nu mai exista )
login: nume_account
password: parola_account
gm: az ( punem flags pentru acess - az = full access)
flags: 8 ( ca Burning Crusade sa fie enabled pe cont)



Copyright DusTeR @ Ultimate.ro
©Ultimate Empire 2006-2007
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 15:32

unde gasesc? :(
10. Mergem in NCDB_-_Milestone_0.1\NCDB - Milestone 0.1 si incarcam database.sql (ATENTIE: trebuie mai intai s-o dezarhivati din fisierul database.rar )
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Duster » 07 Oct 2007, 15:34

ups, ia-o de aici ( e ultima versiune 0.2 ) - click me

editeaza Tool.bat cu setarile care le-ai pus tu si apoi ruleaza-l :) o sa-ti instaleze mult mai repede decat daca ar dura cu Navicat
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 15:42

bun....din Milestone_0.2 ce sa incarc? ca nu-mi apare database.sql
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Duster » 07 Oct 2007, 15:44

editeaza Tool.bat cu setarile care le-ai pus tu si apoi ruleaza-l :) o sa-ti instaleze mult mai repede decat daca ar dura cu Navicat


instaleaza atat character.sql, cat si world.sql ( /Milestone 0.2/Database)
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 15:47

:-) nu stiu ce vrei sa zic in legatura cu: "editeaza Tool.bat cu setarile care le-ai pus tu si apoi ruleaza-l o sa-ti instaleze mult mai repede decat daca ar dura cu Navicat"

acum face world in Navicat.
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Duster » 07 Oct 2007, 15:54

in /Milestone 0.2/Database era un fisier Tool.bat cu care puteai sa importi datele mult mai repede, cu navicat o sa dureze destul de mult, itzi recomand sa folosesti acest tool
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 15:58

asa imi apare asa:
"Please type the letter for the option:

w = Install NCDB World Database.
c = Instal NCDB Clean Character Database.

x - Exit

Enter Letter:"
renunt la Execute batch file?
ca a inceput deja sa il importeze si a facut cam 7%
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Duster » 07 Oct 2007, 16:01

dap renunti la Execute batch file, si instalezi pe rand NCDB World Database si NCDB Clean Character Database.
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 16:17

am editat tool.sh cu ce trebuia(pass...User...) dar nu merge
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby GhOSt » 07 Oct 2007, 16:21

am editat tool.sh cu ce trebuia(pass...User...) dar nu merge imi zice:
"[Importing] World database import Started...
ERROR 1045 <28000>: Access denied for user 'root'@;localhost' <using password: YES>
[Importing] Finished

Press any key to continue . . ."
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Mitzocul » 07 Oct 2007, 16:24

Julien wrote:am editat tool.sh cu ce trebuia(pass...User...) dar nu merge imi zice:
"[Importing] World database import Started...
ERROR 1045 <28000>: Access denied for user 'root'@;localhost' <using password: YES>
[Importing] Finished

Press any key to continue . . ."


asta inseamna ca userul sau parola sunt gresite :)
Mitzocul
[Ultimate Member]
[Ultimate Member]
 
Posts: 120
Joined: 06 Aug 2007, 14:52

Postby Duster » 07 Oct 2007, 16:31

si trebuie sa editezi si WorldDB si CharDB cu numele DB-ului care l-ai creat :)
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Postby GhOSt » 07 Oct 2007, 20:40

intr-un final am gata cu alea 2. acum inru in ascent\branches\1_6_stable\sql si le fac si pe alea?
GhOSt
[Ultimate User]
[Ultimate User]
 
Posts: 32
Joined: 06 Oct 2007, 16:57

Postby Duster » 08 Oct 2007, 07:27

dap inafara de ascent_realmserver_structure.sql si ascent_worldserver_structure.sql ( pentru ca le-ai introdus deja ). Nu cred ca e nevoie sa pui nici new_trainer_sruct.sql sau rev. 285 reputation tables.sql (pentru ca sunt deja versiuni mai noi si o sa-ti zica in consola ca nu sunt bune - asa am patit eu cel putin)
May the loot be with you!
User avatar
Duster
[Rocket Scientist]
[Rocket Scientist]
 
Posts: 4223
Joined: 06 Aug 2007, 13:55
Location: Who knows?...

Next

Return to Tutoriale

Who is online

Users browsing this forum: No registered users and 4 guests