Go Back   EQEmulator Home > EQEmulator Forums > General > General::News

General::News EQemu news posts.

Reply
 
Thread Tools Display Modes
  #121  
Old 11-16-2014, 07:01 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Toony View Post
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?
Are you sure its 0 bytes and you haven't refreshed? Do you see the backup bat displaying errors?
Reply With Quote
  #122  
Old 11-16-2014, 07:34 PM
ghanja's Avatar
ghanja
Dragon
 
Join Date: Aug 2012
Location: Hershey, PA
Posts: 499
Default

Quote:
Originally Posted by Toony View Post
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).
Reply With Quote
  #123  
Old 11-16-2014, 09:27 PM
Toony's Avatar
Toony
Sarnak
 
Join Date: Jul 2009
Location: USA
Posts: 85
Default

Ok, I got farther that time..

Code:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>CD "\EQ - AKKA'S PEQ REPACK\EQEMU SERVER"

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>t_backup_server_database.bat

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>echo "Backing up database to Backups folder..."
"Backing up database to Backups folder..."

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>perl DB_Dumper.pl compress loc="Backups"


Todays Date: 11-16-2014
Compression SET
Backup Directory: Backups
Directory currently exists... Adding files to it...

Backing up Database peq...

--- CMD ---
mysqldump -uroot -p"**************" peq > "Backups\peq 11-16-2014.sql"
---------------------------------------

'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

Error occurred... exiting...
Reply With Quote
  #124  
Old 11-16-2014, 09:30 PM
Toony's Avatar
Toony
Sarnak
 
Join Date: Jul 2009
Location: USA
Posts: 85
Default

Quote:
Originally Posted by Akkadius View Post
Are you sure its 0 bytes and you haven't refreshed? Do you see the backup bat displaying errors?
They are 0 bytes, but the window was closing before I could read any error message. I was able to get a little farther once I used the cmd prompt below.
Reply With Quote
  #125  
Old 11-16-2014, 09:34 PM
ghanja's Avatar
ghanja
Dragon
 
Join Date: Aug 2012
Location: Hershey, PA
Posts: 499
Default

Did you add the proper path of where Maria DB 10.0 is installed?

To my knowledge, the repack installs on the boot drive (which is in most if not all cases the C: drive).

Verify that MariaDB 10.0 is here:

Code:
C:\Program Files\MariaDB 10.0\
If so, then you either did not add to the environment value correctly, or you did not exit from a command prompt you already had opened and then open a new one. That is to say, changes to the environment variable (Path) will not take effect until a new command prompt is open.
Reply With Quote
  #126  
Old 11-16-2014, 09:38 PM
ghanja's Avatar
ghanja
Dragon
 
Join Date: Aug 2012
Location: Hershey, PA
Posts: 499
Default

Here, just do this instead (if it creates a duplicate path it isn't a big deal):

Perform this in an elevated (i.e. "Run as Administrator") cmd.exe (aka dos prompt):
Code:
setx path "%PATH%;C:\Program Files\MariaDB 10.0\bin"
Reply With Quote
  #127  
Old 11-16-2014, 11:26 PM
Toony's Avatar
Toony
Sarnak
 
Join Date: Jul 2009
Location: USA
Posts: 85
Default

Quote:
Originally Posted by ghanja View Post
Here, just do this instead (if it creates a duplicate path it isn't a big deal):

Perform this in an elevated (i.e. "Run as Administrator") cmd.exe (aka dos prompt):
Code:
setx path "%PATH%;C:\Program Files\MariaDB 10.0\bin"
It ran and generated a compressed backup in the folder, it was like 24 megs vs. the 230 the DB is? but seems like it ran fine.

Thanks
Reply With Quote
  #128  
Old 11-17-2014, 12:04 AM
Khaldore
Fire Beetle
 
Join Date: Jun 2007
Location: Montana
Posts: 6
Default

I had to manually add MariaDB's bin folder to the PATH variable as well... for some reason, I was expecting the repack installer to do it. *shrug*

Having said that, this repack is fantastic, lot of respect to Akkadius for putting it together. I haven't tried tinkering with my own server since I last owned a working PC, so having something quick and easy to drop into a VM is wonderful for testing.
Reply With Quote
  #129  
Old 11-17-2014, 12:07 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

When I went through the first 5-6 tries of getting the installer to cleanly do its thing. I had the PATH added there, it was the one thing that was missed in the final build :P
Reply With Quote
  #130  
Old 11-17-2014, 01:46 PM
Zudz
Fire Beetle
 
Join Date: Nov 2014
Posts: 2
Default

Heyo. I got this set up, and I've been wandering around Steamfont (thanks so much for that!), but it seems like things don't aggro me. They'll fight me if I pull them, but otherwise everything is indifferent towards me. Is there something I can/should do to correct that?
Reply With Quote
  #131  
Old 11-17-2014, 02:01 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

Quote:
Originally Posted by Zudz View Post
Heyo. I got this set up, and I've been wandering around Steamfont (thanks so much for that!), but it seems like things don't aggro me. They'll fight me if I pull them, but otherwise everything is indifferent towards me. Is there something I can/should do to correct that?
You might need to clarify if you went to old steamfont or new one.
Reply With Quote
  #132  
Old 11-17-2014, 02:50 PM
Zudz
Fire Beetle
 
Join Date: Nov 2014
Posts: 2
Default

Quote:
Originally Posted by joligario View Post
You might need to clarify if you went to old steamfont or new one.
That's an interesting question. Given the mobs I see, and how nice the mills look, I'm assuming new Steamfont.

I created a character, turned off the tutorial, and loaded into Ak'anon (because I'm a gnome). Then I walked out of the city and ... yeah. That's pretty much it. I haven't left Steamfont yet (except to Gate back to Ak'anon), so I don't know if anything else is affected. Should I check? Or are some zones just aggro free depending on old/new status?
Reply With Quote
  #133  
Old 11-17-2014, 03:28 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

New/revamp zones haven't been fully developed yet on the PEQ database (the base of this repack). Most likely the zone settings are set to no-combat.
Reply With Quote
  #134  
Old 11-17-2014, 04:01 PM
Toony's Avatar
Toony
Sarnak
 
Join Date: Jul 2009
Location: USA
Posts: 85
Default

Quote:
Originally Posted by joligario View Post
New/revamp zones haven't been fully developed yet on the PEQ database (the base of this repack). Most likely the zone settings are set to no-combat.
That would explain why I couldn't get in combat in innothule swamp and commonlands I guess.
Reply With Quote
  #135  
Old 11-19-2014, 02:41 PM
Luccian
Sarnak
 
Join Date: Sep 2009
Posts: 32
Default

Wow Akkadius, this is amazing. Haven't really spoke with you since Blood of the Akkadian, but it looks like you're doing great and wonderful things still.

Thanks for this!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

   

All times are GMT -4. The time now is 06:53 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3