Moving database MySql

Discussion in 'Databases' started by builtSEO, Mar 9, 2011.

  1. #1
    I wanted move database MySql - PhPmyAdmin from fatcow hosting.
    They don't allow ssh .

    Hence I have to download via PhpMyAdmin.

    I compressed version is 2.69MB.

    To import the database to a new server, the max. size is 2MB.
    So how to move ?
    I will have SSH login to the new host,
     
    builtSEO, Mar 9, 2011 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Try using something like navicat. You may need to decompress and run the sql file, but it shouldn't have any problem with file restrictions as long as you can allow remote access to the DB.

    They offer a free 30 day trial, and a lite version for personal / non-business usage at no charge.

    http://www.navicat.com/download/download.html

    By far the best database administration software anywhere.
     
    jestep, Mar 9, 2011 IP
  3. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #3
    chandan123, Mar 10, 2011 IP
  4. chrisceo

    chrisceo Peon

    Messages:
    107
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    May not be a bad idea to run a virtual private server to get away from foolish shared hosting limits on MySQL databases. It's not that hard and I do not know why people freak out at the idea of running a VPS. For $4 - 5 per month, you get 20 gigabytes of space and 1 TB of bandwidth - I have a site with 15,000 hits and it has a large background in the design. I haven't even exceeded 2 - 3gb of bandwidth!

    Oh wait.. shared hosting. Unlimited disk space.. unlimited bandwidth but a limit on MySQL database size? I'll pass!
     
    chrisceo, Mar 10, 2011 IP
  5. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #5
    On that topic, it makes no sense to have unlimited bandwidth when there are so many sites on the server that throughput it limited to a few Kbps. More than once I've been on an unlimited host and through testing we couldn't get better than 10Kbps... No thank you. Sure in theory we could push hundreds of Gb per month, but in reality the throughput limits us to a fraction of that even if running 100% 24/7.
     
    jestep, Mar 10, 2011 IP
  6. SSC

    SSC Active Member

    Messages:
    995
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    80
    #6
    I would prefer bigdump as stated above (its a free script and works successfully most of the time)
    It will insert each sql query one by one so, it doesn't matter how large the database file is or whatever the database size limitation is
    You would be able to successfully dump your data into your new sql database using this handy script

    I have tried it to import databases as big as 3.5GB and it worked well (however, that tool a lot of time and the server was about to crash :D )
     
    SSC, Mar 10, 2011 IP
  7. chrisceo

    chrisceo Peon

    Messages:
    107
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I love it when Wordpress tries to update on 1and1 shared hosting and it fails. I guess that's why so many people run old copies of WP on shared hosting or one click installing it but have PHP memory limitation so it fails. That was the final straw for me. If I had the money, I would transfer the 100+ domains I have on 1and1 to another provider. I think when I get a good lump sum coming in, I'll transfer them little by little after I sell a few.
     
    chrisceo, Mar 10, 2011 IP
  8. Yuri_Orlov

    Yuri_Orlov Peon

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    ............................
     
    Yuri_Orlov, Mar 10, 2011 IP