Database table question
 

Hi all hope you can shed some light here for me.

I am currently trying to backup and save a database, VB4 all is fine apart from 2 tables which are massive

Posts 186,884 records 85.9 mb
Postindex 2,381,479 records 57.3 mb

While i know how to shrink the content of post tables by removing old dumped posts, my problem is how do \i get the size of postindex reduced doesnt seem to change even when removing old posts and threads.

Currently trying to import dbase to a new server and size is causing timeouts, i did import a copy but i think the tables have been broken by the constant stop and start of the import.

any advice appreciated.

postindex is used for searching. You can remove that and then rebuild your search indexes after you import/install the forum. But, the size of that table is smaller than your post table. I'm surprised you are having problems with it as it isn't that large. What method are you using to save it and import it?

From the manual:
Backing Up The Database via SSH/Telnet or
Backing Up The Database via phpMyAdmin

Restoring The Database via SSH/Telnet or
Restoring The Database via phpMyAdmin

If you don't have shell access, some people have also reported success with these scripts:
MySQLDumper
MySQLHotxcopy
Bigdump

Thanks lynne i am using phpmyadmin, I think the server settings are a little on the lean side, im hoping they will be adjusted to increase timeout issue.

I tried importing full database it times out about 8 times and resumes, i think this is why site is not working.

Ive managed to reduce it now, however im getting conflicting data from phpmyadmin and the VB4 admin panel dbase. vb is reporting 26mb while phpmyadmin is still reporting 57mb. post tabe is also having same issue of timeout, i will see what happens if i manage to get server limits increased.