Import: find out number of rows before running actual import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Import: find out number of rows before running actual import

  1. #1
    Join Date
    Dec 2000
    Posts
    75
    I like to find out actual number of rows per table in an import dump before actually import the dump. Does SHOW option do this?
    goodhealth

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, it does not. The only way to find out the number of rows to be imported is to have the log file of the export that created the dump.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Posts
    3
    You can first do the import using INDEXFILE option, this will create the table schema as well as telling you the row count.

  4. #4
    Join Date
    Mar 2001
    Posts
    18
    if you wrote a script to do this.......... dont know if it would be worth it, how long it would take...........

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by rchang
    You can first do the import using INDEXFILE option, this will create the table schema as well as telling you the row count.
    Yes, you are totaly correct. In my reply I wasn't aware that INDEXFILE option also reports on the actual number of rows in the exported tables.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Whoa, kudos to RChang. Not many people can get a hit off Jurij and the rookie did it on his first time at bat .

    (sorry - feeling really punchy this week )

    - Chris

Posting Permissions

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



Click Here to Expand Forum to Full Width