database converted but the size increased to double

[Saurabh Jain]

It says one has to delete the ORIG_ table

 

How to delete that ?

 

Regards

Saurabh

[Saurabh Jain]

Has any  1 has done this?

[Saurabh Jain]

This is a pre requistion for installing IPS.. I belive   every one has done it...

 

[Nathan Explosion]

How to delete a table? Log in to phphmyadmin, view the structure, click the table(s) and drop them.

As for this being a pre-requisite for upgrading.....upgrading the database is, yes. Deleting tables though....sure about that?

Can you be more specific? What options did you choose when doing the upgrade - did you choose to use the converted tables or to rename them to your original prefix?

This is probably a lot more simple than you are thinking - remember, you have a prefix in the conf_global.php.....so delete the tables that DON'T use that prefix could be the easy answer here.

[Saurabh Jain]

There are now tables with two prefixes

 

1  ibf_

 

2 orig_ibf...

 

I need to drop all  Orig_  tables....     do I have to manually select all and then drop?

 

[Nathan Explosion]

Yes...but please double check your prefix so you know what NOT to drop.

[Saurabh Jain]

yes I did chk

Global config has  the following lines

$INFO['sql_tbl_prefix']            =    'ibf_';