Backing up my database - problems

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
joey
Regular
Posts: 12
Joined: Sun Mar 26, 2006 3:05 pm

Backing up my database - problems

Post by joey »

Hiya how are you? i hope everyone here is well,

im trying to backup my database for my blog, but its too big the table called serendipity_sapmblocklog is too big its 204MB is it possible to empty that table using phpmyadmin and them backup my blog, if that is possible can you please tell me how do i go about doing that? i dont want to lose any of my articles from my blog etc i dont really need this serendipity_sapmblocklog table in the database because I dont allow visitors to comment on my blog this was due to spam and have deleted the comment.php file to stop this i think the reason why the serendipity_sapmblocklog file is soo big was becuase of this spamming i used to get

i havent upgraded to the new version thats just come out, cant wait to try that out, but i would like to back up all my work before i do that

can you please help

Thankyou
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Backing up my database - problems

Post by garvinhicking »

Hi!

Yes, spamblocklog can be truncated. Use phpMyAdmin to "EMPTY" (NOT Drop) that table.

(BTW: Try to end your sentences with a "." once in a while - it's very hard to read!)

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
joey
Regular
Posts: 12
Joined: Sun Mar 26, 2006 3:05 pm

Re: Backing up my database - problems

Post by joey »

garvinhicking wrote:Hi!

Yes, spamblocklog can be truncated. Use phpMyAdmin to "EMPTY" (NOT Drop) that table.

(BTW: Try to end your sentences with a "." once in a while - it's very hard to read!)

Best regards,
Garvin
Thanx Garvin for your prompt reply, and yes i will put "." once in a while
:)

Thanx again
Post Reply