Thread

I was just trying to make a backup of my EE-database and noticed it just kept downloading and downloading and… I went into the ACP to check it out and just before I optimized my database, it seemed to be 128MB. After I optimized the tables they were still 125 MB.

I was wondering what your stats are and if there’s something that I can do to make this a bit less. After all, it’s just text. I assume size doesn’t really matter for speed-issues, but I just want to know for sure that it’s ok, to have a 1GB database in a year or so..

My database:
Size: 125 MB
Entries: 3000
Relationships: 2700 (which are responsible for 93MB!)

How about you?

Oh, one more question: have there been any changes in the way relationships are stored in version 1.6.x? I’m about to start updating my site, so I’m hoping something will be changed.

For backing up purposes, clear all caches from the CP before you run the download. This will dramatically reduce the size of that table!

I used the EE control panel utility to backup. whenI use zip choice the backup is corrupt. When I use plain text it’s 10.2mb and the last few lines have the following error.

Also my database appears to be in latin1 - but I specifically set it to utf8. Is there any way to convert the database, easily, to utf8?

KEY `entry_id` (`entry_id`),
  KEY `weblog_id` (`weblog_id`),
  KEY `site_id` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Fatal error:  Out of memory (allocated 565182464) (tried to allocate 5503871 bytes) in /path/to/system/db/db.mysql.php on line 385

 

Hi Linguist, the error you are getting is because PHP ran out of available memory. If you have access to the php.ini file (usually in /etc ) you can up this amount, though some hosts won’t let you do this.

okay, will look into that.