News:

Yahoo Groups closing on Dec 14th 2019

Main Menu

Size of DB3 Database

Started by casstk, October 21, 2019, 03:05:50 AM

Previous topic - Next topic

casstk

As we start archiving more and more mailing lists, the db3 database is expanding. Any tips on how to  whittle it down? If we export a few mailing lists to mySQL and then remove the Groups from our List will that reduce the size? And how can we later use PGOffline to read it again?

Wilson Logan

To make the database smaller you can split your groups into a database per group.

Do File -> Export to folder for each group.

Now you have a .pg4 archive file for each group.

Do File -> New database. Add Master Login details.

Exit program, make copies of new database, one per group. Name them appropriately.

Start PGO, do File -> Open database.  Choose "List", add your group.

Do File -> Import from folder for the appropriate group archive.

Rince, repeat.

casstk

Wilson, a volunteer did not export her Groups and her DB3 is now 8GB and she's struggling to get it open. Any tips?

casstk

Another Database question:

Does the PGO database contain the files, photos, attachments, links?  I know when we export the PG4 files it only has messages and we have to include files, photos, attachments, links from the respective group folders when sharing.

Wilson Logan

The database contains attachments as blob fields.

So if someone attaches a 2Gb video... its now in your database.

I've never come across an 8GB database.

Maybe split it in four by exporting 25% of messages into four PG4 files and then import them into four new groups.

if you can't get it open consider using SQLite Studio.

SMF spam blocked by CleanTalk