Author Topic: database problem  (Read 3427 times)

0 Members and 1 Guest are viewing this topic.

Offline daika

  • Pre-Newbie
  • Posts: 2
    • View Profile
database problem
« on: May 02, 2006, 03:19:55 PM »
I have just install 4images and no images in my gallery
but i don't know why my database is 1,6MB (session table is 1,6MB  8O)
I do a backup and my backup file is 17,1 KB
I don't know why ?

Offline JensF

  • Addicted member
  • ******
  • Posts: 1.028
    • View Profile
    • http://www.terraristik-galerie.de
Re: database problem
« Reply #1 on: May 02, 2006, 05:01:56 PM »
Have you another tables into the database, not from images??
Mit freundlichem Gruß
Jens Funk



-> Sorry for my bad English <-

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: database problem
« Reply #2 on: May 03, 2006, 12:37:59 AM »
and what is inside the backup file?

P.S. the session table is always huge, even if its empty, because it uses "MEMORY" (aka "HEAP") engine which is optimized for perfomance and not size.
Since sessions is not very important, you should not include it into backup, plus after NN period of time these sessions will expired anyway.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline daika

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: database problem
« Reply #3 on: May 04, 2006, 07:40:02 AM »
but session only have my own session ( no registed member )
I try to backup session table and it is about 1KB.
but it show in database ( phpmydamin and Cpanel, 4images backup ) about 1,6MB
I don't know why.
My 4images has no member, no image. I have just installed it.

(Sorry for my bad English)

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: database problem
« Reply #4 on: May 05, 2006, 06:19:20 AM »
You must understand that the size of the backup and the size of the table is not the same things.

P.S. sessions have nothing to do with how many members you have, because every visitor on your site will get an unique session.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)