Clearing IP fields for database.

[KennethH]

I would like to clear all the ips out of the databases for users but I'm unsure on how to. Is this a smart idea? I think alot of the space on the database is taken up by the logging of ip's and after 3 years I would like to clear it at least one time. No one is banned on my forums or anything so that won't get messed up.

What query should I run on the database?

[k33nny]

Nothing?

[Steve Machol]

I can't guarantee this so I srtongly recommend you make a good backup of your database first:

DELETE ipaddress FROM user;

[k33nny]

Will that completely remove the field or just erase whats in it?

[Steve Machol]

I won't guarantee anything which is why I said to make a backup. However this *should* only clear the info field, not delete the field entirely.

[k33nny]

I won't guarantee anything which is why I said to make a backup. However this *should* only clear the info field, not delete the field entirely.

SQL-query :

DELETE ipaddress FROM user
MySQL said:


You have an error in your SQL syntax near 'ipaddress FROM user' at line 1


Also, the ip's I'm talking about removing are the ones added with posts or the ones you search in the Admin CP under IP ADDRESSES for find user.

[Steve Machol]

Sorry then. I don't know the correct query to do this.

[k33nny]

Sorry then. I don't know the correct query to do this.

Thanks for trying. D;

[Steve Machol]

I think these will work. Backup first of course:

UPDATE user SET ipaddress='';
UPDATE post SET ipaddress='';