SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Jun 2004
    Location
    Washington, DC
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    500 mb txt backup of my database

    i have a 500 mb .sql file from my old site's database
    and i want to retrieve 1 table from it which is probably only 5mb
    i tried importing into my database on my computer but my cpu freezes
    from what i can see
    my only option would be to upload the entire 500mb file
    then import it to my site via shell access

    i was just curious
    is there any program i could download
    that would just search that file and retrieve that one table?
    it's far fetched...but maybe i'll get lucky

  2. #2
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I guess you were trying to import the sql file to your database using phpMyAdmin? As far as I know it supports only 2 mb files. (I can be wrong though )

    Use the following command to import the sql file to your DB:
    /usr/local/bin/mysql -u USERNAME -p PASSWORD DATABASE < backup.sql
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!

  3. #3
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As a quick follow-up -- FAR manager can search through that big files:

    http://www.rarsoft.com/far_manager.htm

    Also, you can write a PERL script to search through the file.
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!

  4. #4
    SitePoint Zealot
    Join Date
    Jun 2004
    Location
    Washington, DC
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    that's exactly something i was looking for
    problem is, i can't figure out how to use that program

    is it possible to telnet to the localhost on my cpu
    and import my database like that?

  5. #5
    SitePoint Wizard Lats's Avatar
    Join Date
    Jun 2003
    Location
    Melbourne, AU
    Posts
    1,142
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could use the command line Ilya suggested above with mysql.exe in the bin directory, or you could open up the .sql file in a text editor and strip out the table your require.
    Lats...


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
  •