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.

Importing 18 MB sql file

Discussion in 'Databases' started by Alvin, Jul 30, 2006.

  1. #1
    Hello friends,
    SEMrush
    I am moving one of my sites to dreamhost from another host.

    I have database around 18 MB, can anyone help me how can i move my database to dreamhost? They allow only 10 MB max at one time.. can anyone please guide me..

    Thanks
    Alvin
     
    Alvin, Jul 30, 2006 IP
    SEMrush
  2. instyle

    instyle Guest

    Messages:
    314
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can copy the structure first. Then copy the data in two steps. 9MB+9MB.
     
    instyle, Jul 30, 2006 IP
  3. Alvin

    Alvin Notable Member

    Messages:
    2,075
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #3
    can you please give me more deatils.. this is my first time am moving my site..

    I will appreciate it..

    thanks
     
    Alvin, Jul 30, 2006 IP
  4. Cheater

    Cheater Peon

    Messages:
    54
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You should get a 18mb SQL file and then import it in ssh.
     
    Cheater, Jul 30, 2006 IP
    Alvin likes this.
  5. anandg

    anandg Active Member

    Messages:
    193
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    90
    #5
    At the present host do you have access to phpmyadmin ? It can help you export data efficiently.

    If you do not have phpmyadmin on your host, it will be a good idea to download it and set it up.

    Choose Export -> Select the export format (SQL), Choose Save as File and select gzipped format.

    This will compress the database in gzip format. I am sure a 18MB db will be around / less than 10MB when compressed. It should solve your problem.

    While importing in dreamhost you can specify the gzipped file and import it there through phpmyadmin.
     
    anandg, Jul 31, 2006 IP
    Alvin likes this.
  6. kajsng

    kajsng Peon

    Messages:
    74
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Or you can open the file and break it up in to (in your case) two smaller files. Just go about half way down, and take from there below and put it in a new file. Use phpMyAdmin to import the two files.
     
    kajsng, Jul 31, 2006 IP
    Alvin likes this.
  7. Alvin

    Alvin Notable Member

    Messages:
    2,075
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #7
    got it done by bigdump.
    anyway thanks for your suggestions.

    Will keep them for future.
     
    Alvin, Jul 31, 2006 IP
  8. Serpatinas

    Serpatinas Well-Known Member

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    121
    #8
    With a desktop program with http tunnel you won’t have problem with timeout or max file size.

    I’m using SQLyog: http://www.webyog.com/

    The best out there, very satisfied :)
     
    Serpatinas, Jul 31, 2006 IP