ghanja |
11-16-2014 07:34 PM |
Quote:
Originally Posted by Toony
(Post 235593)
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:
Code:
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):
Code:
%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.
Code:
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).
|