SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    NJ
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    dealing with a large database dump

    i have a very large text file containing several mysql databases and tons and tons of records. it's over 200 megabytes. how do i go about dealing with this volume of data? phpmyadmin can't handle it. how would you guys suggest i go about importing a database?

  2. #2
    SitePoint Enthusiast
    Join Date
    Dec 2005
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use a script called mysqltool. Basically it will insert your sql by small portions automatically till its done. I will see if I can find it for you on my comp.
    Need any video services done? PM me
    Watermarking, Thumbnails, Video Content Submission,
    Encoding videos including Flash (.flv).

  3. #3
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use mysqlhotcopy

  4. #4
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    NJ
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysqlhotcopy looks like it is for copying an active database, not for importing one currently stored in a text file.

    i found the mysqltool website in google. i'll give it a try.

  5. #5
    SitePoint Enthusiast
    Join Date
    Dec 2005
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have used mysqltool on large db's before. All my files were around 200mb .sql files. Good Luck
    Need any video services done? PM me
    Watermarking, Thumbnails, Video Content Submission,
    Encoding videos including Flash (.flv).

  6. #6
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    NJ
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i have installed mysqltool, but how do i execute a large .sql file? i can only find the "Execute SQL Statement" screen that just has a text box in it.

  7. #7
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    NJ
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sometimes simplicity is best:
    mysql -u USER -p DATABASE < file.sql

  8. #8
    SitePoint Zealot swiftone's Avatar
    Join Date
    Mar 2005
    Location
    Sunny Florida
    Posts
    145
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you have Webmin installed on the server it does a nice job importing large sql files into MySQL.
    Happy Coding,
    Swiftone

    Unique Web Sites


Bookmarks

Posting Permissions

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