SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    Internet Consumist Kayn's Avatar
    Join Date
    Feb 2001
    Location
    Missouri
    Posts
    209
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Data migration from local machine to server. Help, help, help!

    I've got my vBulletin database running on my machine. It's a long story about how I tried to upgrade to 4.0, didn't work out, got it working on my machine, need to migrate to server, blah blah blah, I won't bore you.

    Point is: I have a 150-ish meg .sql file. Compressed it's about 52 megs. Way too big for phpmyadmin to accept through a browser.

    I need to get this file, compressed or uncompressed, onto my server. It's a Linux machine running cPanel/WHM. I can FTP it to my server, but I have no clue where to put it on there in order to run it.

    I also have no idea how to run it. I was raised on Windows; thanks mom! :P

    Now I'm on a Mac. I'm very unfamiliar with command line stuff. I can change directories and... uhh, paste in commands.

    So to put it plainly:

    1. Where do I upload my sql file to?
    2. How do I execute it?

    I have attempted to figure out how to remotely connect to my server via MySQL Administrator. I've granted access to my IP. I don't even know what to put into the server hostname; tried my domain name and my server's IP address. Ugh. I'd like to know how to make this happen as well.

    I can't seem to find a simple solution to these problems. I've scoured the 'net, but there is no simple step-by-step solution tutorial that I could find.

    Please help me! Share your wisdom! I must learn!
    Sing in a band called Psychostick, Alfredo Afro.

  2. #2
    Visible Ninja bronze trophy
    JeffWalden's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,709
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    I don't have all the answers for you but something is better than nothing...

    http://forums.devshed.com/postgresql...pt-407999.html

    This thread talks about running a .sql file from command prompt. That being said, you'll need to get logged into the MySQL server via command prompt. Do you have shell access to the server? If it's a VPS then you might but probably not if you're in a shared environment.

    In regards to the MySQL Admin, is your database server located on the same machine as your web server? If so, then I would imagine that your dedicated IP address or domain name should do the trick. However, I know that some hosts don't allow direct MySQL access regardless. Not sure how they are able to block this but you might want to check with your host.

    Simply put, your first challenge is gaining direct access via shell to the database server.
    TAKE A WALK OUTSIDE YOUR MIND.

  3. #3
    Internet Consumist Kayn's Avatar
    Join Date
    Feb 2001
    Location
    Missouri
    Posts
    209
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, getting closer. I have shell access; but I don't know how to connect via shell. Remember, I'm a dunce when it comes to command line anything.

    And something else just happened. My mysql.sock vanished after I restarted my mysql services on my Mac. It's gone. How do I get it back or get another one configured??
    Sing in a band called Psychostick, Alfredo Afro.

  4. #4
    Visible Ninja bronze trophy
    JeffWalden's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,709
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    http://www.cyberciti.biz/faq/how-to-...-line-and-php/

    That should explain to you how to connect with shell but I'm lost on the mysql.sock file. Sorry.
    TAKE A WALK OUTSIDE YOUR MIND.

  5. #5
    Internet Consumist Kayn's Avatar
    Join Date
    Feb 2001
    Location
    Missouri
    Posts
    209
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Help? Mysql sock? anyone?
    Sing in a band called Psychostick, Alfredo Afro.

  6. #6
    SitePoint Member
    Join Date
    Feb 2010
    Location
    Jacksonville, FL
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The general steps for this would be to:
    1. upload the sql file
    2. create the database
    3. import the sql file
    4. check/repair tables


    If you are getting errors about mysql.sock, that is a socket file used by MySQL and may signify that your MySQL server is not running or is mis-configured.


Bookmarks

Posting Permissions

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