=== ShipInfo Import Script ===
Start time: 2026-01-24 07:00:59

File found: /home/nmhdzhvc/public_html/parser/byStation/shipplotter_logs/shipinfo.txt
File size: 230,203 bytes

Database connected successfully

Starting import...
--------------------------------------------------------------------------------
Line 2: INSERT - MMSI: 304521000, Name: EIDER, Type: 79
Line 3: SKIP - MMSI exists (MMSI: 993686005, Name: ML)
Line 4: INSERT - MMSI: 366978440, Name: MISSOURI, Type: 52
Line 5: SKIP - MMSI exists (MMSI: 367313340, Name: VALERIE B)
Line 6: INSERT - MMSI: 538006351, Name: FEDERAL BEAUFORT, Type: 70
Line 7: SKIP - MMSI exists (MMSI: 316036228, Name: ALGOMA BUFFALO)
Line 8: INSERT - MMSI: 366971370, Name: EDWIN H. GOTT, Type: 70
Line 9: INSERT - MMSI: 368317320, Name: SHIRLEY ANN, Type: 52
Line 10: SKIP - MMSI exists (MMSI: 993683016, Name: RI)
Line 11: INSERT - MMSI: 366999529, Name: CGC BUCKTHORN, Type: 99
Line 12: SKIP - MMSI exists (MMSI: 367073840, Name: JAMES J. VERSLUIS)
Line 13: SKIP - MMSI exists (MMSI: 993672226, Name: DHBT)
Line 14: INSERT - MMSI: 366905890, Name: JAMES R BARKER, Type: 70
Line 15: INSERT - MMSI: 338888000, Name: CLYDE S. VANENKEVORT, Type: 31
Line 16: INSERT - MMSI: 993682306, Name: 4, Type: 125
Line 17: INSERT - MMSI: 366906610, Name: WALTER J MCCARTHY, Type: 70
Line 22: SKIP - MMSI exists (MMSI: 993682097, Name: BH)
Line 24: SKIP - MMSI exists (MMSI: 993682096, Name: CH)
Line 25: SKIP - MMSI exists (MMSI: 316013946, Name: LEO A.MCARTHUR)
Line 28: SKIP - MMSI exists (MMSI: 368039870, Name: ODYSSEY CHICAGO_IVER)
Line 44: SKIP - Navigation aid (MMSI: 338926283, Type: 0, Name: )
Line 65: SKIP - Navigation aid (MMSI: 368134280, Type: 0, Name: ELYSE NOELLE)
Line 72: SKIP - Navigation aid (MMSI: 367063240, Type: 0, Name: SUGAR ISLANDER II)
Line 117: SKIP - Navigation aid (MMSI: 316004055, Type: 0, Name: WILFRED M. COHEN)
Line 147: SKIP - Navigation aid (MMSI: 338010315, Type: 0, Name: NANCY D)
Progress: 100 records inserted...
Line 188: SKIP - Navigation aid (MMSI: 366999402, Type: 0, Name: BILLMAIER)
Line 215: SKIP - Navigation aid (MMSI: 316011684, Type: 0, Name: COVE ISLE)
Line 248: SKIP - Navigation aid (MMSI: 367121010, Type: 0, Name: AMERICAN CENTURY)
Line 264: SKIP - Navigation aid (MMSI: 369494413, Type: 0, Name: CG49413)
Line 292: SKIP - Navigation aid (MMSI: 367396130, Type: 0, Name: WILLIAM C)
Progress: 200 records inserted...
Progress: 300 records inserted...
Progress: 400 records inserted...
Progress: 500 records inserted...
Progress: 600 records inserted...
Progress: 700 records inserted...
Progress: 800 records inserted...
Progress: 900 records inserted...
Progress: 1000 records inserted...
Progress: 1100 records inserted...
Progress: 1200 records inserted...
Progress: 1300 records inserted...
Progress: 1400 records inserted...
Line 1710: WARNING - Invalid format (expected 10-11 fields, got 2) - Skipping malformed line
Progress: 1500 records inserted...
Progress: 1600 records inserted...
Progress: 1700 records inserted...
Progress: 1800 records inserted...
Progress: 1900 records inserted...
Progress: 2000 records inserted...
Progress: 2100 records inserted...
Progress: 2200 records inserted...
Progress: 2300 records inserted...
Progress: 2400 records inserted...
Progress: 2500 records inserted...
Progress: 2600 records inserted...
Progress: 2700 records inserted...
Progress: 2800 records inserted...
--------------------------------------------------------------------------------

=== Import Complete ===
End time: 2026-01-24 07:01:03

Summary:
  Total lines processed:     3,195
  Records inserted:          2,813
  Skipped (already exists):  249
  Skipped (navigation aids): 132
  Errors:                    1

Note: Only first 10 'already exists' messages shown
Note: Only first 10 'navigation aid' messages shown
Note: Only first 10 insert messages shown

Done!