Server Backup and General Newbie Thread

[Akkadius]

- Server Backup
Navigated to C Drive -> EQ - AKKA'S PEQ REPACK -> EQEMU SERVER -> t_backup_server_database.bat. This produces a 0 byte peq<date>.sql file. I don't know what to do with this file ICE and I also feel like 0 Bytes is a red flag.

Need to make sure MariaDB database install is in your Windows PATH variable, this is a known issue with the repack. It causes backup scripts to not work because they rely on knowing where to find binaries such as 'mysqdump'

It appears like the only difference between v421 and v460 for me is that v460 wont generate a spell file for me, it errors out. Does my DB auto update somehow and it happens behind the scenes?

460 now generates a spellfile, this was an issue server side with write permissions.

As far as updating, making sure your windows PATH variable is set for MariaDB (MySQL) and the eqemu update script will take care of it if you get a hold of new windows binaries. Some other folks can help you answer that question as I need to go.

As well as other questions I'll let others pick those up.

[utbbop]

Originally Posted by Akkadius

- Server Backup
Navigated to C Drive -> EQ - AKKA'S PEQ REPACK -> EQEMU SERVER -> t_backup_server_database.bat. This produces a 0 byte peq<date>.sql file. I don't know what to do with this file ICE and I also feel like 0 Bytes is a red flag.

Need to make sure MariaDB database install is in your Windows PATH variable, this is a known issue with the repack. It causes backup scripts to not work because they rely on knowing where to find binaries such as 'mysqdump'

It appears like the only difference between v421 and v460 for me is that v460 wont generate a spell file for me, it errors out. Does my DB auto update somehow and it happens behind the scenes?

460 now generates a spellfile, this was an issue server side with write permissions.

As far as updating, making sure your windows PATH variable is set for MariaDB (MySQL) and the eqemu update script will take care of it if you get a hold of new windows binaries. Some other folks can help you answer that question as I need to go.

As well as other questions I'll let others pick those up.

Thanks for the info Akka.
I did some google-fu and came across this post:
http://www.eqemulator.org/forums/pri...6&pp=15&page=9

Followed the following instructions and the backup.bat now created a 22.5 MB zip/rar file:
Windows 8

Drag the Mouse pointer to the Right bottom corner of the screen
Click on the Search icon and type: Control Panel
Click on -> Control Panel -> System -> Advanced
Click on Environment Variables, under System Variables, find PATH, and click on it.
In the Edit windows, modify PATH by adding the location of the MariaDB binaries (i.e. C:\Program Files\MariaDB 10.0\bin) to the value for PATH.
Close the window.

[utbbop]

Thanks again for the feedback akka.

Anyone able to assist with my other questions related to:
- Server Upkeep and Performance

Thanks all!

[provocating]

Originally Posted by utbbop

Thanks again for the feedback akka.

Anyone able to assist with my other questions related to:
- Server Upkeep and Performance

Thanks all!

Really need more information to even be able to answer that question. Are you wanting to host it from home? Do you have a static i.p. address available to you? Do you have the funds available to you for paying for hosting? How many players are your end goal? Are you planning on making an elaborate website, you will need more bandwidth for that?

[Akkadius]

http://wiki.eqemulator.org/p?Tuning_Server_Performance

[utbbop]

Originally Posted by Akkadius

http://wiki.eqemulator.org/p?Tuning_Server_Performance

Thanks a ton Akka, great place to get me started and thinking in the right direction.

[utbbop]

Originally Posted by provocating

Really need more information to even be able to answer that question. Are you wanting to host it from home? Do you have a static i.p. address available to you? Do you have the funds available to you for paying for hosting? How many players are your end goal? Are you planning on making an elaborate website, you will need more bandwidth for that?

Thanks for the follow up Provo.

Are you wanting to host it from home?
Not against this, my determination would be based on the server needs and my available internet speeds through Time Warner.

Do you have a static i.p. address available to you?
Not entirely sure, probably something I would need to research with Time Warner?

Do you have the funds available to you for paying for hosting? How many players are your end goal?
Not entirely sure as I dont have any clue as to cost here. I anticipate a server that attracts less than 100 connections at any time. Probably more like 20-50 connections is more realistic...

If my options are to host at home or pay for hosting I think my preference would be to pay for hosting...assuming the cost isnt ridiculous. I really just have zero education on hosting a server with a third party. In my head, i picture paying someone to access a virtual machine of sorts where I can access my "AKKAS PEQ REPACK" folder to start/end/backup my server, etc. I would then re-establish connections to the EOC using the "virtual machines" IP's and stuff...

Are you planning on making an elaborate website, you will need more bandwidth for that?
Not planning anything elaborate. Just a simple site with a forums and landing/news page.


Thanks Provo, let me know if you want more info.

[provocating]

I would start out slow, maybe host it yourself with a dynamic dns service for the time being. See how many players you attract to begin with. Also see how you like it as far as being the GM. I can tell you now it is a challenge when you have things coming at you from all different directions, many fires to put out. I would not go full blown until you get the hang of it and know for sure this is what you want to do.

And something I always preach......backup......backup.......backup

[utbbop]

Originally Posted by provocating

I would start out slow, maybe host it yourself with a dynamic dns service for the time being. See how many players you attract to begin with. Also see how you like it as far as being the GM. I can tell you now it is a challenge when you have things coming at you from all different directions, many fires to put out. I would not go full blown until you get the hang of it and know for sure this is what you want to do.

And something I always preach......backup......backup.......backup

Thanks and I am in agreement.

In terms of backup. The tool provided with Akka's Repack should suffice, correct? Or is there an additional level of backup needed?
(Aka does Akka's backup solution backup all server related items such as quests and the DB or does it only do the DB and I should be backing up quests separately?)