MySQL question

Discussion in 'MySQL' started by htmlindex, Dec 29, 2006.

Thread Status:
Not open for further replies.
0
  1. #1
    I need to import a .sql file into a database. The problem is that .sql file is about 10mb, but PHPMyAdmin only can import databases of 2mb max. How do I import this file?
     
    htmlindex, Dec 29, 2006 IP
  2. Thermit

    Thermit Peon

    Messages:
    164
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What I would do is upload the file to my server, then use the mysql command line tool to import it directly into mysql.

    If that option isn't available to you, you could try manually breaking the file into about 5 or 6 pieces and load into phpMyAdmin.
     
    Thermit, Dec 29, 2006 IP
  3. JEET

    JEET Notable Member

    Messages:
    3,832
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #3
    Do a google search for "Big Dump". Sorry I don't have a link handy right now...
    I used this to import a very large 47MB database once.
    Bye :)
     
    JEET, Dec 29, 2006 IP
Thread Status:
Not open for further replies.