Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Working with massive mysql dump...

    I've just had a major error on a server with a massive 6gig database. Now, I managed to restore nearly everything fine, but there are a couple of tables that are lost in this database file. I need a way from the console to extract tables from the dump file into a smaller dump file that i can then import through mysql. The problem is I cannot import the entire database as it will possibly overwrite some things that have happened after the database was taken.

    Anybody know how to work with such large sql dumps?

  2. #2
    Join Date
    Dec 2003
    I'd import the database backup into a clean database and then dump just the tables you want to recover into the live database. Alternatively you could try and manually cut the section of the dump file, but I know what's the easier option.

  3. #3
    Join Date
    May 2004
    Lansing, MI, USA
    cat dbdump.sql | grep "INSERT INTO tablename" > part.sql ??
    Jacob - WebOnce Technologies - 30 Day 100% Satisfaction Guarantee - Over 5 Years Going Strong!
    Website Hosting, PHP4&5, RoR, MySQL 5.0, Reseller Hosting, Development, and Designs
    Powered By JAM - Professional Website Development - PHP, MySQL, JavaScript, AJAX - Projects Small & Large

Posting Permissions

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