SQLyog 导出导入 数据库

http://wowps.org/forum/t52-guide_setting_up_mangos_server.html

Now you have all the files you need to compile a Mangos server from scratch.

Configuration:-
Extract the core rar file into a folder called Mangos "or whatever you want to call your server folder"
Extract the Maps into your server folder "must be in a folder called maps"
Extract the dbc files into your server folder "must be in a folder called dbc"
Extract the Database Sql file "The main sql file which you build your mangos database with" to desktop, this makes it nice and easy to locate later.

Thats all for now.
Configurating Sqlyog:-
Run Sqlyog.
Click on New Button.
Call the new connection: Your server name, mines is RyusRealm.
In the Mysql Host Address: localhost
User name and Password: Remember earier on when I said to remember what pass word you use in Mysql setup?
Put in what you added to Mysql, example: User=root Password=blah.
Port leave as 3306.
Click on Test connection, if it says Mysql running fine, then your ready to go "If it says can't connect to localhost@user_blah" then you are using a different password/username than what you used with Mysql setup.
Once connection is tested and works, save and click on connect.

Now we setup the database:-
If you see an entry called "test" delete it, as it's not needed "right click/dump"
Now right click anywhere on the left handside and select "Create Database.."
Call your first one: realmd
Do this step again and call it: mangos
Now, right click on the realmd db and select: Restore from Sql Dump.
You will see a button with "...." click on it, and locate your server folder.
Once in your server folder, look for a folder called "sql".
Here you will see an sql file called: realmd.sql "this is the one ou want, so select it".
Once selected and back on the Sql dump box, click on execute.
Once done, click on close.
At this point I like to right click on the left hand side and select Refresh, it's not needed, but I always do it anyway. "doing this or not wont effect anything"
Now right click on mangos db, and again select Restore from Sql Dump.
Now select the database sql file "remmeber I said to save your new database to the desktop?" Use that.
Click on execute.
At this point it will start building the database.
Note: Different databases are built differently, some small and some large like silvers. The lenth of time will depend on your ram/cpu.

After it's done you are all set "Key marker: come to this section of guide for online server setup"

Now close down Sqlyog, and goto your server folder.
Inside your server folder will be 2 files: Mangod.conf and Realmd.conf
Both files is best opened with Wordpad and not notepad..
Open up Realmd.conf..
Realmd.conf Setup:-
The only line you need to change in here is:
LoginDatabaseInfo = "127.0.0.1;3306;USER;PASSWORD;realmd"
Always leave the IP to 127.0.0.1 even if hosting online.
Change the user and password to what your: Mysql/Sqlyog is.
Save and close down realmd.conf.
Now open up Mangosd.conf
Mangosd.conf Setup:-
This file can change quite alot of aspects of your server, so for the purpose of the guide, im only going to tell you what to change to have your server running
See this line: DataDir = "@MANGOSDATA@" remove the mangosdata part.
Should look like this: DataDir = "."
this will tell the server that the important files are all in the root folder.
Next Step:
LoginDatabaseInfo = "127.0.0.1;3306;USER;PASSWORD;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;USER;PASSWORD;mangos"
Change the USER/PASSWORD to match your Mysql/Sqlyog setup.
Leave IP's as 127.0.0.1 Even if hosting online, leave it.

Now all you have todo is simply run:-
realmd.exe
then
mangosd.exe

Congrats!! You have just compiled your server from scratch

There is more changing you can do with your server, but this will be covered in other guides, by myself or someone else

But wait!!
I hear you scream "Damnit Ryu, I want this online too!".
Simple..
You remember back in the guide I placed a key marker?
"Key marker: come to this section of guide for online server setup"
then Listen up, as this is real easy..

Close down realmd.exe and mangosd.exe.
Open up Sqlyog and click on connect.

On the left hand side you will see your:
======
mangos
realmd
======
Left click on the + Icon on the realmd database, this will drop down into entries.
Left click on: realmlist
Right click on realmlist and select: Insert/Update data for table.

On the right handside window you will see basicly the same line as your realmd.conf.
change the following:-
Name: Here you call your server what you want, in here I have Ryus Realm.
Address: Here is what we need to change to make it online.
Replace the IP thats in the address, and type in your external IP "Example: 86.***.***.***
Even if you have an no-ip address DO NOT put it in there.
Once done, click on the little floppy disk icon to save.
Close down Sqlyog.

转载于:https://www.cnblogs.com/cy163/archive/2010/01/29/1659541.html