1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Moving mysql database help?

Discussion in 'General Business' started by lorien1973, Apr 4, 2005.

0
  1. #1
    Anyone good in MySQL? I am trying to move a database from one host to another today and having major issues (meaning I'm an idiot I think).

    Anyone have time for a quick installation of a SQL dump into the new database? I'll pay for time/services, of course.

    I'd kill to get this done today. Thanks!
     
    lorien1973, Apr 4, 2005 IP
  2. mopacfan

    mopacfan Peon

    Messages:
    3,273
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Unless you're using full relational tables, all you have to do is copy the data files from the data directory from one computer to the other. I've done it many, many times.
     
    mopacfan, Apr 4, 2005 IP
  3. Juls

    Juls Well-Known Member

    Messages:
    1,867
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    170
    #3
    ya i think he is. lorien1973 i can help you out. :) let me know I will pm ya.

    I can move it over for you.

    :)
     
    Juls, Apr 4, 2005 IP
  4. sheelgohe

    sheelgohe Peon

    Messages:
    380
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Generate a script of your database and run that script in your new host phpMyAdmin mySQL Database Engine.

    Regards
    Sheel
     
    sheelgohe, Apr 9, 2005 IP
  5. fryman

    fryman Kiss my rep

    Messages:
    9,604
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    370
    #5
    can't you just backup the data from cpanel and then restore it on the other account?
     
    fryman, Apr 9, 2005 IP
  6. anton-io!

    anton-io! Active Member

    Messages:
    540
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #6
    exactly fryman!
    cpanel should have the required tools to backup & restore
    ... as long as they're using cpanel
     
    anton-io!, Apr 9, 2005 IP