Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 10 of 10
  1. #1
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts

    Question Importing Large Backups

    Hi


    I have a 600 MB .sql dump which I got from someone.

    I need to import that .sql file to my database. PHPmyadmin does not allow that big files to import. The desktop based mysql client (SQLYog) which I am using to manage MySQL databases, also crashes while importing.

    I am on a windows system. Could you please suggest me a better and effective way to import it?


    Thanx in advance.

  • #2
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by cancer10 View Post
    Hi


    I have a 600 MB .sql dump which I got from someone.

    I need to import that .sql file to my database. PHPmyadmin does not allow that big files to import. The desktop based mysql client (SQLYog) which I am using to manage MySQL databases, also crashes while importing.

    I am on a windows system. Could you please suggest me a better and effective way to import it?


    Thanx in advance.
    if you have access to a mysql client you can use something like that:
    Code:
    > use mydatabase;
    > source mydumpfile;
    mydatabase and mydumpfile are the name of the database and name of the dump file( not compressed).
    you must drop and create the database before if already exists.

    best regards

  • #3
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by oesxyl View Post
    if you have access to a mysql client you can use something like that:
    Code:
    > use mydatabase;
    > source mydumpfile;
    mydatabase and mydumpfile are the name of the database and name of the dump file( not compressed).
    you must drop and create the database before if already exists.

    best regards
    hi

    This works fine but after a 1000 lines of importing, I get this error and this occurs everytime i try to import it.

    Plz see the attachment screenshot.
    Attached Thumbnails Attached Thumbnails Importing Large Backups-error.jpg  

  • #4
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by cancer10 View Post
    hi

    This works fine but after a 1000 lines of importing, I get this error and this occurs everytime i try to import it.

    Plz see the attachment screenshot.
    usualy dump file is a text file with mysql command like insert, create and so on.
    try to open the file with a editor and see what command is on the line with that error.

    best regards

  • #5
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts
    Do u know any windows based text editor that could open a file with 25,000 lines?

  • #6
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by cancer10 View Post
    Do u know any windows based text editor that could open a file with 25,000 lines?
    I'm sorry, I don't use windows, I hope that somebody else will help you with that.
    Some years ago, when I used windows, I use emacs to edit file, and I remember it work with files up to 8 M.

    best regards

  • #7
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts
    oh! but its 600 mb in my case

  • #8
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by cancer10 View Post
    oh! but its 600 mb in my case
    there is a program, split which can split the file into pieces with a given size but is for linux. I'm sure there is something like that for windows.

    Edit: find this on the net but I don't know if work, or how:

    http://www.pc-tools.net/win32/filesplit/

    best regards
    Last edited by oesxyl; 02-26-2009 at 10:34 AM.

  • #9
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,994
    Thanks
    120
    Thanked 76 Times in 76 Posts
    ....Unlimited file size and line length. Unlimited undo and redo, even after saving.
    http://editpad-pro.jgsoft-just-great...ware4free.com/

  • #10
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    Quote Originally Posted by cancer10 View Post
    Do u know any windows based text editor that could open a file with 25,000 lines?
    http://www.vim.org/download.php#pc vim can handle it without breaking a sweat. I've used it to edit 40GB text files before.
    OracleGuy


  •  

    Posting Permissions

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