Windows Server Repack (EQEmu Akka's PEQ Repack)

[ghanja]

Originally Posted by Toony

Up and running a few weeks now, but I noticed running the backup DB .bat gives a 0 byte sql file in the backup folder; am I looking in the wrong place?

I'm going to go out on a limb and assume your Maria DB (specifically the location of mysql.exe, mysqldump.exe, etc.) is not within your Environment Path.

Follow these instructions for your applicable version of Windows:

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.


Windows 7

    Select Computer from the Start menu
    Choose System Properties from the context menu
    Click Advanced system settings > Advanced tab
    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.


Windows XP

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


Windows Vista

    Right click My Computer icon
    Choose Properties from the context menu
    Click Advanced tab (Advanced system settings link in Vista)
    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.

If there is NOT a trailing semi-colon at the end of the existing "Variable value" for "Variable Name" of PATH, then you need to put a semi-colon before adding C:\Program Files\MariaDB 10.0\bin

An example of what the value of variable Path may look like (and this assumes your AKKA REPACK was installed in C: drive of course):

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\system32\wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0;c:\Program Files\WIDCOMM\Bluetooth Software;c:\Program Files\WIDCOMM\Bluetooth Software\syswow64;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\DTS\Binn;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\Autodesk Shared\;C:\Program Files (x86)\Autodesk\Backburner\;C:\Microchip\MPLAB C32 Suite\bin;C:\FPC\2.6.2\bin\i386-Win32;C:\Program Files\MariaDB 10.0\bin;

Also, run the t_backup_server_database.bat from an elevated command prompt.

Left click Windows/Start
Type in search: cmd
cmd.exe should show up, right click that
Left click "Run as administrator"
Click "Yes" (if running UAC, if not it will go straight to a dos prompt)
C:
CD "\EQ - AKKA'S PEQ REPACK\EQEMU SERVER"
t_backup_server_database.bat

You'll be able to copy/paste any errors from the command prompt (just highlight whatever text you want copied, there is no right clicking to it in a dos prompt).

Then just left click in a post/reply here to paste the error(s).