Problem with SQL database size

[Pixelmat]

Hi

My photoblog is host at OVH.

With my hosting service, SQL databases are limited to 5 Mo.

Now my database reach this limit. So I'd like to know if there is a way to reduce the database size by erasing datas that I don't need;

For Info my photoblog exist for 14 month now and there is almost 400 photos...

thanks

[dakwegmo]

Check your PP database and see which tables are using the most space. You can do this through phpMyAdmin, or if you have Dennis's database manager plugin, you can use that too. Once you've determined which tables are the culprits, post them here, and I'm sure we can help you figure out whether it's safe to clean up that data.

Secondly, I'm assuming you meant 5 MB, and if so, that's ridiculously low for a database, unless your hosting is free. I would seriously consider looking into alternate hosting arrangements, that don't have such restrictions.

[Pixelmat]

Thx,

The allowed size is 5 Mo !

So I went to PHPmyadmin and I empty the stats and visitors table...

Now it's ok ! my database is 0.69 Mo

Thanks for your help

[dakwegmo]

The allowed size is 5 Mo !

So, then what is a Mo? Is it anything like a Megabyte?

So I went to PHPmyadmin and I empty the stats and visitors table...

Now it's ok ! my database is 0.69 Mo

Thanks for your help

That would have been my suggestion too, if you don't mind losing the visitor data. Some tags won't be as useful without the history in the DB, but if you've got strict limitations, then it's probably the best course of action.

[Pixelmat]

So, then what is a Mo? Is it anything like a Megabyte?

Sorry, a Mo is the same than a MB : 1 Mo = 1 MB


++