Wordpress Database space

[TR123]

My blog is hosted on some webspace I have with 1and1. Annoyingly although I have the allocation of about 15 MySQL databases each can only be a max of 100MB. Although I am a long way off ofthat at the moment, the database does seem to be creeping up in size and I wondered if it was possible to use more than one database for the overflow (over 100MB) if and when it happens? Otherwise when it gets bigger I guess I will just have to move hosts.

Thanks for your help.

[Kevin]

I dont believe it is possible. If your blog does reach that level, I would encourage you to upgrade your hosting :)

[Michael-Martin]

I doubt it's possible either. I don't know much SQL, but relational databases work by interlinking tables (e.g. in the wp_posts table, it doesn't store your name. It stores a link to a field in the wp_users table). If you tried to split the databases, those links would break. :(

And splitting individual tables would be near impossible I think. :(

[TR123]

Thanks for the info - the database seems to be growing at an alarming Rate now 40MB and I will have to change soon - Kevin I know you have suggested good hosting before but I can't remember who you said please could you remind me? I need a large database with the hosting

Does anyone have suggestions for keeping database size smaller, I am unsure what effects it - I use a lot of images would these be the cause?

[shypys]

You'd need 2000+ posts to have a database that big... :eek:

[TR123]

I only have about 200 postings? Any ideas, thanks

[Kevin]

I assume that you will be using a lot of the space in your database with images etc. Are you uploading a lot of images to your database?

[TR123]

I am just uploading images via wordpress - upload - does this put them in the database? They appeared to be stored just in uploads in my webspace (not database)

[jblanton]

If your hosting provider has PHPmyAdmin you can do a bit more analysis of why the database is so big. If they don't my recommendation is to click on that Host Gator banner above and get some better hosting. :-)

[Kevin]

bloggingtips is currently using about 39mb from 453 posts.

have a look at phpmyadmin and list the tables in your wordpress database which are taking up the most space

for example, my posts table is taking up 2.7mb but my comments table is taking up 4.2mb. You will probably have something similar.