1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[How to] Import SQL DataBase Bigger than 100MB

Discussion in 'Blogging' started by Mr.Profit, Sep 29, 2011.

  1. Mr.Profit

    Mr.Profit Regular Member

    Joined:
    Dec 22, 2009
    Messages:
    219
    Likes Received:
    471
    Occupation:
    Marketer and SEO
    Location:
    Internet
    Home Page:
    Hello BHW,

    Just few minutes ago I had to move one of my blogs from one hosting to another (both shared) and it turned out that the maximum import limit of SQL DB is 100MBs which was a problem for me, because my DB was bigger than that.

    I didn't want to chop the DB (mainly because I have never done this before), and I didn't want to contact support either, because the support of the hosting I've moved the blog to is ... not that good at least to say.


    So I began for searching for other solution and after few minutes I stumbled upon this script:
    Code:
    http://www.ozerov.de/bigdump/
    Direct Download:
    Code:
    http://www.ozerov.de/bigdump.zip
    This script automatically chops and uploads your DB to the new hosting without you doing anything besides changing some settings for the script to be able to .

    So, although it's self explanatory script here are the steps you need to take:

    1) Download your DB and files form the OLD hosting (Preferably via BACKUP)
    2) Upload all your files to the new hosting (Don't forget to change DNS records for the domain too)
    2.1) Upload your SQL DB file to the same directory you've uploaded your files on the NEW Hosting
    3) Download Big Dump
    4) Edit bigdump.php as required using your favorite PHP Editor (hint Notepad++ will do), e.g:

    PHP:
    ......
    // Database configuration

    $db_server   'localhost'//unless you use remote DB connection don't change this
    $db_name     ''//The name of your DB on the NEW hosting
    $db_username ''//The username to access the DB on your NEW hosting
    $db_password '';  //Password for the DB on the NEW Hosting

    // Other settings (optional)

    $filename           '';     // Specify the dump filename to suppress the file selection dialog;  
    //THE ABOVE IS THE FULL FILE NAME of your SQL DB dump file!!!
    ...........
    5) Upload bigdump.php TO THE SAME FOLDER as the SQL DB Dump FILE!!!!

    6) Access bigdump.php on your domain from any Web Browser, e.g.
    Code:
    http://my-domain-name.com/bigdump.php
    You will be presented with the following picture (or similar):
    [​IMG]

    7) Click on Start Import

    8) If everything is done correctly your blog should be up and running in few minutes (for me it was like 20 seconds, but it depends on your SQL DB size)


    There's an explanation how to use the bigdump.php file in the file itself, but I hope this tutorial will help less experienced users.

    Happy moving everyone!

    Kind Regards,
    Mr.Profit
     
    • Thanks Thanks x 2
    Last edited: Sep 29, 2011
  2. Dshah

    Dshah Newbie

    Joined:
    Dec 2, 2009
    Messages:
    46
    Likes Received:
    35
    or you can use mysqldumper http://www.mysqldumper.net/
     
  3. Mr.Profit

    Mr.Profit Regular Member

    Joined:
    Dec 22, 2009
    Messages:
    219
    Likes Received:
    471
    Occupation:
    Marketer and SEO
    Location:
    Internet
    Home Page:
    Maybe you could, BUT this is not the purpose of this tutorial thread.

    MySQLDumper is used to backup and restore your SQL DBs, and could be used for moving, but that's not the main purpose of the tool.

    On the other hand MySQLDumper has a feature to SPLIT the DBs to smaller files, and that's why it's irrelevant to this thread.

    What I tried to do is to give a solution to somone who didn't use this tool you are speaking nor has spitted the DB when he should have.

    Thanks for your reply though.

    Regards,
    Mr.Profit
     
  4. RoiBox

    RoiBox Registered Member

    Joined:
    Apr 4, 2009
    Messages:
    50
    Likes Received:
    79
    Occupation:
    Internet Entrepreneur
    Location:
    Gothenburg | Sweden
  5. jolt3500

    jolt3500 Junior Member

    Joined:
    Jun 16, 2009
    Messages:
    112
    Likes Received:
    2
    Occupation:
    8 Day Work Weeks
    Location:
    Native to Planet Earth
    Had this issue when I change servers. Thanks for the link. Think I will do a backup right now, just cus.
     
  6. lazyfrog

    lazyfrog Junior Member

    Joined:
    Jan 19, 2009
    Messages:
    103
    Likes Received:
    29
    Bookmarked, that will help next time I might change my hosting.
     
  7. Mr.Profit

    Mr.Profit Regular Member

    Joined:
    Dec 22, 2009
    Messages:
    219
    Likes Received:
    471
    Occupation:
    Marketer and SEO
    Location:
    Internet
    Home Page:
    You are welcome guys! It really is pain to move one hosting to other, and when you have even more roadblocks it can get ugly pretty quickly.

    I'm glad that this thread was not just a waste of web space ;)

    Regards,
    Mr.Profit
     
  8. Florist88

    Florist88 Newbie

    Joined:
    Jul 24, 2009
    Messages:
    43
    Likes Received:
    7
    Yep, also used bigdump before, it was a great help. Thanks for the reminder