Database Overhead

[duonglg]

Hello!
My forum overhead >150mb, while my hosting allow <=100mb.
now, I cant access my forum, who can help me optimize this database.
I use phpmyadmin optimize database, it notice error in table.
Please help me
Thanks.
My forum VBB 4.1.1, not use shoutbox

duonglg Reviewed by duonglg on 6th Apr 2011. Database Overhead Hello! My forum overhead >150mb, while my hosting allow <=100mb. now, I cant access my forum, who can help me optimize this database. I use phpmyadmin optimize database, it notice error in table. Please help me Thanks. My forum VBB 4.1.1, not use shoutbox Rating: 5

[mp3show]

what forum software is it? IPB? VB?

[duonglg]

Vbb 4.1.1
I dont use shoutbox, only static

[eLight]

If your database is that large look into changing the search engine otherwise your only choice is to delete posts or move hosting.

[Shadow008]

nope,no need to delete anything,simply upload bigdump to your site and upload the sql file and upload it using bigdump
download:http://www.ozerov.de/bigdump.zip

You need to add sql database details in bigdump.php
you need to make a NEW database which has nothing,and add the details in it
i hope it helps ...

[onel0ve]

use ssh for import your db
if you dnt have access use mysqldumper or bigdump
if this also failed then use mysql splitter for split your db and then import part part

for optimize

To optimize a mysql database table via command line you will need to ssh into your server as the root user and enter into the mySQL command line interface by typing "mysql". This will give you the following prompt.

mysql>

Once you are at a mySQL command prompt you will need to type the following. The first selects the database you wish to use and the second optimizes the table(s).

mysql> USE your_database;
Database changed


mysql> OPTIMIZE TABLE `table1` , `table2` , `table3` , `table4`;

[Shadow008]

here is the mysql splitter :
http://www.rusiczki.net/2007/01/24/s...file-splitter/

...

[duonglg]

it see below:

Database notice overhead, access this forum it notice above.
I cant do what now.

[Cory]

I use phpmyadmin optimize database, it notice error in table.

You said there was an error, Try using the 'Repair' option in the database, once done, then Optimize the database and your forum should work.

If needed, I could take a look.

[duonglg]

i try repair but it notice error "INSERT command denied to user 'xxx'@'xxx' for table 'access'
example:xxx for database name and ip