Server Backup and General Newbie Thread

[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.