Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2005
    Posts
    94

    * Moving MySQL DB Help... Please :(

    Hello again folks.

    I have a problem... basically Im in the process of moving all my sites from 1 server to another. The enviroments that the site(s) are moving to/from are pretty much identicle.

    OS: Windows 2003

    Now... basically the problem Im having is moving the sites running from a MySQL database. I need to know howto move the database(s) over from the old server to the new server.

    Please dont think im coming here as an easy option as I have looked into this but cant find a solution that works for me as I cant use phpmyadmin - Nor am I using cPanel.

    Is there anyway I can just move the directory storing the db files onto the new server? Basically Im open to pretty much all and any options providing theyre not using a control panel backup feature nor using phpmyadmin or similar.

    Thanks for your time.
    Turn My Text - ¡spuǝıɹɟ ʞooqǝɔɐɟ ɹnoʎ ǝzɐɯɐ puɐ ǝsnɟuoɔ

    Computer Game Cheats & Codes

  2. #2
    Join Date
    Jul 2003
    Location
    Missouri
    Posts
    30
    http://www.ozarkhost.com/forum/viewtopic.php?t=15

    This was a linux howto but should apply to windows server as well.

  3. #3
    Join Date
    Mar 2005
    Posts
    94
    So are they commands I need to put in the DOS prompt?
    Turn My Text - ¡spuǝıɹɟ ʞooqǝɔɐɟ ɹnoʎ ǝzɐɯɐ puɐ ǝsnɟuoɔ

    Computer Game Cheats & Codes

  4. #4
    Join Date
    Jan 2005
    Location
    Scotland, UK
    Posts
    2,681
    Hello,

    Yes, I created this guide. http://www.hostgeekz.com/guides/Othe...l_database.htm

    The majority of it will work with dos prompt with some slight changes.
    Server Management - AdminGeekZ.com
    Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
    WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
    Check our wordpress varnish plugin. Contact us for quote: sales@admingeekz.com

  5. #5
    Join Date
    Sep 2004
    Location
    Chicago, IL
    Posts
    214
    Is this a live site; regardless of how, there will be some downtime involved to prevent data loss.
    Ben Lenard, MS, MBA
    TechMinds 4 Hire, Inc - (866) 214-1285 x 2001
    http://www.tm4h.com

  6. #6
    Join Date
    Mar 2005
    Posts
    94
    Downtime isnt really a problem, im fine with that - its just the moving DB's over.

    HostGeekZ - what changes would be needed?
    Turn My Text - ¡spuǝıɹɟ ʞooqǝɔɐɟ ɹnoʎ ǝzɐɯɐ puɐ ǝsnɟuoɔ

    Computer Game Cheats & Codes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •