[Database] What would cause a DB to work on a pc and Fail on a vps? menu

User Tag List

Results 1 to 6 of 6
  1. #1
    apocalypticnrg's Avatar Private
    Reputation
    1
    Join Date
    Nov 2008
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Database] What would cause a DB to work on a pc and Fail on a vps?

    I've been working on a wow server for over a year now, and decided to actually place it on a VPS. I copied everything, decided I would just compile on a home pc, and just upload it. So far so good. I copy my databases over using sqlyog. No issues there. Installed VStudio, as some of the DLL's are required to run the logon and world exe's. Run the Logon.exe boots up fine. Run the World.exe, looks good, then crashes (during boot)....

    So the fun began from that first crash.

    I decided to try the base DB that came with arcemu's svn. Load that database, world.exe runs, *great*. I log in to the game, get to the character creation, notice the old accounts had no clothes on. *weird*. Hit login, bam "Login Failed".

    Okay, lets try updating all the databases... Same issue.

    So my question is, how can one instance of arcemu 3.3.2 run perfectly on one machine, and crash on the next one.

    * Same database
    * Same config, besides allowing for public access
    * Same maps, vmaps, dbc's.

    I just don't get it. Maybe someone knows a trick I don't know about converting this emulator to a 2k3 vps.

    EDIT:

    After reviewing my database after that last sqlyog copy, I noticed its crashing because nothing really exists. It said
    it completed successfully, but after checking just now, there were a lot of empty cells. Will keep posted if I discover
    a fix.

    UPDATE:

    Nope same thing. I'm at my wits end with this thing. Not really what I wanted to spend 2 days working on.
    ---Apoc.
    Last edited by apocalypticnrg; 04-30-2010 at 10:10 PM.

    These ads disappear when you log in.

  2. #2
    Kiev's Avatar Contributor
    Reputation
    286
    Join Date
    Nov 2007
    Posts
    1,816
    Thanks G/R
    0/2
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How did you copy it with SQLYog?

    Also ensure that your VPS has the latest .Net Framework, this is a definate need




  3. #3
    Kirth's Avatar Knight-Lieutenant
    Reputation
    58
    Join Date
    Nov 2007
    Posts
    274
    Thanks G/R
    2/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You should import your database using the SQL command line.
    Code:
    mysql -u'root' -p'ponies' world < world.sql;
    this is a definate need
    I see not the need for the .NET framework. Unless applications such as SQLYog (euw) need these.



  4. #4
    Kiev's Avatar Contributor
    Reputation
    286
    Join Date
    Nov 2007
    Posts
    1,816
    Thanks G/R
    0/2
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To run the arcemu applications it requires the latest .Net framework.




  5. #5
    apocalypticnrg's Avatar Private
    Reputation
    1
    Join Date
    Nov 2008
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The latest came with the VS2010, I'm wondering if 2010 has something to do with it. I believe its framework 4.5.

    Also copied the database using sqldump and sqlyog has a feature to actually copy the database to another connection. So it basically just copies the database from my pc, to my vps. And it says successful on both occasions. But when I go to run the world.exe file, it gets to a certain point and crashes. Its also tried to leave dump files but they are unreadable. No data.

    Also maybe the ftp was incorrect and the dbc's are causing the crash?

    Like I said I'm baffled lol.


    EDIT:

    Turns out the .net framework is 3.0 after running a script in my browser. I have 2.0 and 3.0 installed.

    Installing 3.5 now. I'm hoping this makes a difference.
    Last edited by apocalypticnrg; 05-01-2010 at 07:00 AM.

  6. #6
    Kiev's Avatar Contributor
    Reputation
    286
    Join Date
    Nov 2007
    Posts
    1,816
    Thanks G/R
    0/2
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It might not fix the problem, if it does not, then its quite possible its a database issue.

    What i would suggest:

    Dump your entire SQL, then set up the connection to your VPS's MySQL, and re execute, thats one of the main reasons for crashes.




Similar Threads

  1. Replies: 23
    Last Post: 11-06-2015, 12:26 PM
  2. Extendcost doesn't work. How can i diagnose what is causing the problem ?
    By Wheeze201 in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 08-13-2009, 09:49 AM
  3. What would be the Causes of a Slow Exucute Data file on Navicat?
    By Snailz in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 01-23-2008, 06:02 PM
  4. What would WoW be like in version 10.0?
    By Clocky in forum World of Warcraft General
    Replies: 21
    Last Post: 12-11-2006, 05:15 PM
  5. Replies: 36
    Last Post: 05-05-2006, 01:11 AM
All times are GMT -5. The time now is 04:13 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search