Backup Failure: Consider setting the UseZip64WhenSaving
Posted: Sun 13 Feb 2011 17:59
I am attempting to backup a moderate sized MySQL database using zip file compression. The dbForge Studio is 4.5.311, the OS is MS Server 2008. At the completion of the backup the message "Export fail: Compressed or Uncompressed size, or offset exceeds the maximum value. Consider setting the UseZip64WhenSaving property on the ZipFile instance." is presented. The zip file created is ~5Gig. I am unable to open the zip filewith WinZIP 14.0.
Can anyone provide guidance on how to enable the UseZip64WhenSaving option identified in the error message?
Thanks in advance for assistance.
Below is the dbForge log and error message.
------ Database 'biodb2010' backup started ------
Output file: D:\biodb2010 20110211 2009.zip
Cannot describe an object. SELECT command denied to user 'biodb'@'isi-dev.draper.com' for table 'func'
SELECT command denied to user 'biodb'@'isi-dev.draper.com' for table 'func'
Exported Table: Enum
Exported Table: AttributeGrouping
Exported Table: BioSchema
Exported Table: ConfigProperty
Exported Table: EventType
Exported Table: FeatureGrouping
Exported Table: QuestionType
Exported Table: SeriesGrouping
Exported Table: Signal
Exported Table: SignalValue
Exported Table: Study
Exported Table: UserRole
Exported Table: Attribute
Exported Table: EnumValue
Exported Table: Feature
Exported Table: Protocol
Exported Table: User
Exported Table: FeatureSet
Exported Table: Participant
Exported Table: Question
Exported Table: Sensor
Exported Table: FeatureSetToFeature
Exported Table: ProtocolAttribute
Exported Table: SensorToSignal
Exported Table: Session
Exported Table: AttributeValue
Exported Table: Event
Exported Table: SensorSeries
Exported Table: SessionFile
Exported Table: FeatureSeries
Exported Table: SignalResource
Exported Table: FeatureValue
Exported data from table: Enum (455 rows)
Exported data from table: AttributeGrouping (22 rows)
Exported data from table: BioSchema (13 rows)
Exported data from table: ConfigProperty (1 rows)
Exported data from table: EventType (4 rows)
Exported data from table: FeatureGrouping (11 rows)
Exported data from table: QuestionType (6 rows)
Exported data from table: SeriesGrouping (10 rows)
Exported data from table: Signal (30 rows)
Exported data from table: SignalValue (946564932 rows)
Exported data from table: Study (3 rows)
Exported data from table: UserRole (1 rows)
Exported data from table: Attribute (782 rows)
Exported data from table: EnumValue (2137 rows)
Exported data from table: Feature (95 rows)
Exported data from table: Protocol (3 rows)
Exported data from table: User (1 rows)
Exported data from table: FeatureSet (4 rows)
Exported data from table: Participant (359 rows)
Exported data from table: Question (96 rows)
Exported data from table: Sensor (15 rows)
Exported data from table: FeatureSetToFeature (170 rows)
Exported data from table: ProtocolAttribute (1067 rows)
Exported data from table: SensorToSignal (43 rows)
Exported data from table: Session (359 rows)
Exported data from table: AttributeValue (94525 rows)
Exported data from table: Event (30282 rows)
Exported data from table: SensorSeries (1487 rows)
Exported data from table: FeatureSeries (720701 rows)
Exported data from table: FeatureValue (87206069 rows)
Objects processed: 32
Rows processed: 1034623683
------- Database 'biodb2010' backup finished -------
Export fail: Compressed or Uncompressed size, or offset exceeds the maximum value. Consider setting the UseZip64WhenSaving property on the ZipFile instance.
Can anyone provide guidance on how to enable the UseZip64WhenSaving option identified in the error message?
Thanks in advance for assistance.
Below is the dbForge log and error message.
------ Database 'biodb2010' backup started ------
Output file: D:\biodb2010 20110211 2009.zip
Cannot describe an object. SELECT command denied to user 'biodb'@'isi-dev.draper.com' for table 'func'
SELECT command denied to user 'biodb'@'isi-dev.draper.com' for table 'func'
Exported Table: Enum
Exported Table: AttributeGrouping
Exported Table: BioSchema
Exported Table: ConfigProperty
Exported Table: EventType
Exported Table: FeatureGrouping
Exported Table: QuestionType
Exported Table: SeriesGrouping
Exported Table: Signal
Exported Table: SignalValue
Exported Table: Study
Exported Table: UserRole
Exported Table: Attribute
Exported Table: EnumValue
Exported Table: Feature
Exported Table: Protocol
Exported Table: User
Exported Table: FeatureSet
Exported Table: Participant
Exported Table: Question
Exported Table: Sensor
Exported Table: FeatureSetToFeature
Exported Table: ProtocolAttribute
Exported Table: SensorToSignal
Exported Table: Session
Exported Table: AttributeValue
Exported Table: Event
Exported Table: SensorSeries
Exported Table: SessionFile
Exported Table: FeatureSeries
Exported Table: SignalResource
Exported Table: FeatureValue
Exported data from table: Enum (455 rows)
Exported data from table: AttributeGrouping (22 rows)
Exported data from table: BioSchema (13 rows)
Exported data from table: ConfigProperty (1 rows)
Exported data from table: EventType (4 rows)
Exported data from table: FeatureGrouping (11 rows)
Exported data from table: QuestionType (6 rows)
Exported data from table: SeriesGrouping (10 rows)
Exported data from table: Signal (30 rows)
Exported data from table: SignalValue (946564932 rows)
Exported data from table: Study (3 rows)
Exported data from table: UserRole (1 rows)
Exported data from table: Attribute (782 rows)
Exported data from table: EnumValue (2137 rows)
Exported data from table: Feature (95 rows)
Exported data from table: Protocol (3 rows)
Exported data from table: User (1 rows)
Exported data from table: FeatureSet (4 rows)
Exported data from table: Participant (359 rows)
Exported data from table: Question (96 rows)
Exported data from table: Sensor (15 rows)
Exported data from table: FeatureSetToFeature (170 rows)
Exported data from table: ProtocolAttribute (1067 rows)
Exported data from table: SensorToSignal (43 rows)
Exported data from table: Session (359 rows)
Exported data from table: AttributeValue (94525 rows)
Exported data from table: Event (30282 rows)
Exported data from table: SensorSeries (1487 rows)
Exported data from table: FeatureSeries (720701 rows)
Exported data from table: FeatureValue (87206069 rows)
Objects processed: 32
Rows processed: 1034623683
------- Database 'biodb2010' backup finished -------
Export fail: Compressed or Uncompressed size, or offset exceeds the maximum value. Consider setting the UseZip64WhenSaving property on the ZipFile instance.