#48 ✓resolved
Xin Yin

bug: could not import the database!

Reported by Xin Yin | April 19th, 2013 @ 08:57 AM

Hi Marubinotto,

I tried to export and restore the database today. The exporting generates a pig file (~7.9M). But if I import it with "Restore" menu, I got an error "The data file is invalid".

I tried another smaller database I just created for testing (export file is about 2.8M), and it works well. Does the import and export functions have size limitation? This worried me a lot as my database is starting growing fast!

FYI, I am using the latest version v6.10 of piggydb (piggydb-all-in-one-6.10.zip).

Kind regards,
Xin Yin

Comments and changes to this ticket

  • marubinotto

    marubinotto April 21st, 2013 @ 10:19 AM

    Hi Xin Yin,

    Thank you for your report.

    What happens if you import the file with the standalone edition? If the same error happens again, please check out the log file 'piggydb.log'.

    Does the import and export functions have size limitation?

    I'm not sure, but there might be limitations on upload size by the web browser's setting or your network environment, and this kind of limitation can't be controlled from an application. A safer way is to back up the database files directly if your database grows larger.

    Best regards,

  • marubinotto

    marubinotto April 21st, 2013 @ 10:21 AM

    • State changed from “new” to “open”
  • Xin Yin

    Xin Yin May 2nd, 2013 @ 11:06 AM

    Hi Daisuke,

    I finally got time to try it with standalone edition and the problem remained. I also built a fake database with a lot of attachments (so the database is big) and the export/import went fine. Have no clue what is the problem!

    I am backing up the database regularly. I think the export/import functionality will be more meaningful if it can export/import several selected fragments. This is useful if I would like to share part of my database to others.

    Kind regards,

  • marubinotto

    marubinotto May 4th, 2013 @ 11:30 AM

    Are there any messages in piggydb.log?

  • Elyser

    Elyser June 15th, 2013 @ 03:37 AM

    Hi Marubinotto.

    I'm using the war version (6.10) and i have the same problem with the import/export. Just today i did not get to import my database. The message "The data file is invalid" appears in the final step of the upload process.

    You say it is possible to back up the database files directly, but what must I do with the file "rdb-dump.xml" ????

    Besides: Where the piggydb.log is generated when using Tomcat and piggydb.war ????

    Thanks a lot.

  • marubinotto

    marubinotto June 16th, 2013 @ 01:10 PM

    Hi Elyser,

    The war package won't output piggydb.log by default (or maybe the logs are in tomcat's logs directory depending on your settings), so could you try to import the file with the standalone package and let me know the content of piggydb.log?

    Best regards,

  • marubinotto

    marubinotto March 19th, 2014 @ 09:30 AM

    • State changed from “open” to “resolved”

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Piggydb is a Web notebook application that provides you with a platform to build your knowledge personally or collaboratively.

Shared Ticket Bins

People watching this ticket