Forums / Install & configuration / EzPublish DB : 100 mo
Nabil Alimi
Thursday 04 August 2005 4:03:02 am
Hi,
While performing a backup, I've noticed that the database of my site was 100 MBytes large. Is that "normal" ? The biggest part of it is the table <b>ezsearch_object_word_link</b> which is 85 MB large.
Is there a way to reduce it without disturbing Ezpublish functions ?
My blog : http://www.starnab.com/ezpublish / http://www.starnab.com/ / http://www.assiki-consulting.com eZ Publish Freelance developper. Feel free to contact me +33 674 367 057 nabil at assiki d0t fr
Gabriel Ambuehl
Thursday 04 August 2005 5:14:27 am
ezsearch_object_word_link is only used for the search function. I think you could skip the data in that table if you're content with regenarating your search indexes after a reinstall of the backups.
However, try compressing your MySQL dump. It will likely be muuuch smaller after that. SQL statements can be compressed very well.
Visit http://triligon.org
Friday 05 August 2005 3:58:56 am
But I can I freely truncate this table ? Won't it damage my installation ? I'd like to just to light my database.
Friday 05 August 2005 4:50:24 am
Well if you truncate it, searching won't work until you regenerate search index.
Xavier Dutoit
Friday 05 August 2005 7:03:01 am
Search indexes take a lot of space.
You can disable the search feature if you want to save space or try an external search engine (ez has plugs in). However, that's likely that it's going to take space too, but into another storage than your DB.
You can safely not backup this table, and in the case you have to restore, regenerate the index.
This being said, don't trust anyone on backup issues and you'd be wise to pratice restore before you really need it.
The last sentence is a definitive proof that I'm not wise, in case anyone wonders ;)
http://www.sydesy.com