MySQL db Standalone

[Khar00f]

Hi Fellas, i've been playing with repacks for the past couple of weeks, and now i've decided to compile my own, it's a learning process for me since i had never used mysql and never compiled anything before recently.

now i've read some guides and some have been quite helpfull, there's just one thing i can't seem to figure out.

Now i've compiled my emu, and created my DB, the only thing left is importing some sql files, but i don't know how to make my compile behave like a repack (i dunno what files i need to include in the bin folder of mysql (on my compiled folder)

If someone can clarify this up for me, it'd be very much apreciated.
Thank you.

P.S.: i tried googling without much more success.
I have MySQL 5.0.1 (latest)

[AngelSandy]

What do you mean "Act Like A Repack"?
Its basically the Repack that "Acts" Like the self-compiled stuff :b

Basically a repack is a compiled emulator made for you in advance, with the disadvantage of not being able to configure the core.

[Abstraction]

MySQL 6.0 is the latest btw.

[Khar00f]

I apreciate you correcting me, but you both completely missed the point

the advantage of a repack is that it doesn't need mysql installed or anything else, it's self contained and run standalone (that's what i meant by like a repack)

So now i'm compiling my own build, but i want it to be standalone also, so this way if i want to give the folder to my bro run it off his pc, it'll work regardless of software installed cause everything would be in the compiled folder i gave him.

So the questions is, what files or steps do i need to take to make the pack run as is.

Thank you.

[AngelSandy]

I would say Stoneharry would know some of this.
He made that "World of Roarcraft" repack, and others have made repacks aswell. If you are lucky someone who made a repack might answer to this post :b

[stoneharry]

Well for the SQL database theres two ways to transfer it - Via dumping it then restoring it or just sending the whole server.

In sqlyog (not explaining navicat sorry) just right click on each database you want to send to a different computer, check as a sql file, check the boxes you want such as create database - structure and data etc then hit export.
Send it to the other computer (memory card - upload download etc)
On the other computer open up sqlyog, right click, create database, right click on new database, restore from sql dump, hit the file, your database is on there.
Theres only one error you can get from that - and thats if you have not configured it to let you execute a file that big. Google the error and see if you can work it out - if not contact me at [email protected] the fix varies depending on what you use. It's easier to talk than say like 20 different ways in here
The other way to transfer is if your using Xampp and not MySQL Server because with this you can simple drag the folder from computer to computer - with mysqlserver you have to install it. Consider using Xampp in future for transfering databases - it's what people use in repacks when they use there full database one click startup. If you understand.

For the actual server it's self you only need the .dll's and .lib's, the .exe's, .configs, and folders. All the export library's bla bla bla you can simple delete. Test your server before sending to the other computer to make sure you didn't delete any vital files. The DBC's you should upload with your repack but the maps you can leave out and make the other person extract because there something stupid like 3gig.

Hope this helps a bit - Good luck

Edit: There are no guides for this yet - Somone should make one with pics

[Khar00f]

Hi there stoneharry

That last part of your post is exactly (full database one click startup) what I'm looking for, but I'm just not 100% i understand

"...The other way to transfer is if your using Xampp and not MySQL Server because with this you can simple drag the folder from computer to computer - with mysqlserver you have to install it. Consider using Xampp in future for transferring databases - it's what people use in repacks when they use there full database one click startup. If you understand."

I'm using xampp and sqlyog

Is there a way(and how) to export the database as a folder, or I just have to copy and paste it inside my compile?

and as for the last part:

"...For the actual server it's self you only need the .dll's and .lib's, the .exe's, .configs, and folders. All the export library's bla bla bla you can simple delete."

How do i know which exe/dll/lib's are required for the database to be independent?

The only file one I know that is required is "mysqld.exe", any other I have no idea(tried googling that, not much help there).

I know some of these questions sound maybe stupid but I'm just starting up with the whole SQL thing, so I'm learning as it goes and trying to read as much as possible.

I appreciate the time you're putting in giving me a hand,

Thank you.

[stoneharry]

It's not stupid at all - As I said nobody has made any guides for this yet as far as I know. It took me days to work out how to do it.
In your server folder where you have "Arcemu-world.exe" and such like that. This is the core. Anything that ends in .lib - .exe - .dll - .cnf - .lua and folders you need. The rest can be deleted. If you have Visual C++ installed (as you should) it will tell you what each bit is hopefully. Again if you don't understand say, I'm not good at explaining this
For the database, you say your using xampp. Well you can either try and show off by editing the cnf file (this is in mysql - bin) or you can leave all the file names how they are etc. On the mysql-start.exe/.bat right click and click edit (you should be able to) here you can change some of the text (echo's) to what you want it to say. Anyway you basically need to go to the actual folder "xampp" what everything is in. This is what the player will need. The problem here is that the player has to install it to EXACTLY the same directory as you did. For example C:\Xampp
Right click on the folder - Add to archive, and save it as a rar, zip or exe file. If you want to save as a exe google "rar exe" or something. It's quite simple - I found it on there
Once thats complete, you can send that to whoever and they will have your database. Do the same with the core.
If you have any questions ask - I'm not great at explaining and my grammer is pretty poor

[Khar00f]

ok so if i got you correctly

the part about the server exe's that's fine, i've compiled and moved the files

it's just the database i'm having problems with

so just to make sure i understood,

I head over to the xampp folder, and copy the mysql folder, it'll have the database and all necessary exe's included.

then i must edit the my.ini to hold relative paths instead of full paths, this way they can run it from wherever they extract the folder to.

then i can run xampp, flush the databse and start a new one if i need to.


haha don't worry for your grammar, cant be worst than mine
Thank the Forum gods for auto correct

Thanks again, will try it out and let you know how it goes

[stoneharry]

no no no, you misunderstood me.
The mysql\bin folder is what you need to edit if you want to change folder names etc but I wouldn't recomend doing it because it's quite anoying to setup.
All you need to do is to send the database, make sure mysql and apache etc is stopped then compile the xampp folder into a zip/rar/exe and send. Simple as that

[Khar00f]

ohh, well, before you replied, i tried what i wrote

Copy the mysql folder from inside xampp and it worked, i just edited the paths in the my.ini file

[stoneharry]

ah 0_o well... as long as it works I suppose thats good Still a bit confused on what you did but ah well. Good luck - I'll check back here tommorow if your having more problems.

[AngelSandy]

See ^^
I told you Harry was the man :3

[Khar00f]

I'll try and clarify what i did

inside the xampp folder there's many folders (basically one for each service, php, apache, mysql, filezilla, etc...

so all i did was copy only the mysql folder inside my ArcEmu folder, then i went inside Arcemu/mysql/bin opened the my.ini file and changed the paths to be relative the bin folder instead of absolute

my tree looks like this

ARCEMU
|__configs
|__dbc
|__maps
|__mysql
|......|__bin
|............|__my.ini
|............|__all the .exe files are here also
|__script_bin
|__scripts
|__vmaps
arcemu-logonserver.exe
arcemu-world.exe
collision.dll
Mysql.bat
Mysql_Stop.bat


and inside my.ini

i changed the following paths

[client]
socket = "D:/Apps/Xampp/mysql/mysql.sock"
to
socket = "./mysql/mysql.sock"

[mysqld]
socket= "D:/Apps/Xampp/mysql/mysql.sock"
basedir="D:/Apps/Xampp/mysql"
tmpdir="D:/Apps/Xampp/tmp"
datadir="D:/Apps/Xampp/mysql/data"
to
socket= "./mysql/mysql.sock"
basedir="./mysql"
tmpdir="./mysql/tmp"
datadir="./mysql/data"

changed
#skip-innodb
to
skip-innodb

the rest is left on default

So now no matter where the person puts "ArcEmu" folder, there won't be any need to change modify the my.ini file to fix the paths, it'll always work, as long as the folders inside "ArcEmu" stay the same


P.S.: can someone tell me how to insert spaces when writing a message? i had to put ....... in my tree otherwise it would squeeze everything together.