Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need to move huge installation


mythx_lv

Recommended Posts

Posted

I'm a PHP programmer who was just handed a project to move an OS Commerce installation to a new server. I'm new to OSCommerce so I'm looking for help with the issue I'm having.

 

The database is 5GB (this is a problem because GoDaddy only support 2GB and they're threatening to drop the database). Most of this DB size seems to be in phpBB tables which appear to be integrated into Os Commerce. GoDaddy export tools all fail at backing up the database (within the app, or outside the app). I haven't called them yet, but probably will soon since I suspect a DB problem.

 

The version of Os Commerce is 2.2-MS2, I guess it's an old one

 

How can I prune this database in order to make it easier to move? I'm told it's a 6 year old installation.

 

Thanks for any help I'm kind of stuck here.

Posted

How can I prune this database in order to make it easier to move? I'm told it's a 6 year old installation.

There are scripts to make backups of large MySQL installations that give problems because of maximum execution times. MySQLDumper is one of them just as this one for osC specifically.

Posted

Thanks for the info. That's running now, and looks promising. Now to my other question. I'd still like to shrink the DB, what can I do to reduce teh size of the tables. Like I said, the phpbb tables seem to be the largest, do they store pertinent info about the OSC transactions?

Posted

Like I said, the phpbb tables seem to be the largest, do they store pertinent info about the OSC transactions?

 

That is not a stock oscommerce table. I am guessing you have a forum addon filled with user posts over the years.

Posted

Now to my other question. I'd still like to shrink the DB, what can I do to reduce teh size of the tables.

You should find all osC relevant tables defined in includes/databasetables.php. There is not much you can do to trim these, apart from deleting old orders which span several tables. Obviously, you don't want to delete tables holding products...

 

In rare cases the table sessions is not pruned to delete old sessions but that is about it regarding osC.

 

The backups also take space. I don't know if you run into trouble with that. Otherwise backup groups of tables, download the backups, continue etcetera.

Posted

You should find all osC relevant tables defined in includes/databasetables.php. There is not much you can do to trim these, apart from deleting old orders which span several tables. Obviously, you don't want to delete tables holding products...

 

In rare cases the table sessions is not pruned to delete old sessions but that is about it regarding osC.

 

The backups also take space. I don't know if you run into trouble with that. Otherwise backup groups of tables, download the backups, continue etcetera.

 

OK, that's helpful info. Now when I look at the database_tables.php file, I find a section at bottom as follows:

// #CHAVEIRO16# BEGIN PHPBB2

define('TABLE_PHPBB_USERS', 'phpbb_users');

define('TABLE_PHPBB_SESSIONS', 'phpbb_sessions');

define('TABLE_PHPBB_GROUPS', 'phpbb_groups');

define('TABLE_PHPBB_USER_GROUPS', 'phpbb_user_group');

define('TABLE_PHPBB_POSTS', 'phpbb_posts');

define('TABLE_PHPBB_TOPICS', 'phpbb_topics');

define('TABLE_PHPBB_VOTE_CUSTOMERS', 'phpbb_vote_voters');

define('TABLE_PHPBB_AUTH_ACCESS', 'phpbb_auth_access');

define('TABLE_PHPBB_TOPICS_WATCH', 'phpbb_topics_watch');

define('TABLE_PHPBB_BANLIST', 'phpbb_banlist');

define('TABLE_PHPBB_PRIVMSGS', 'phpbb_privmsgs');

define('TABLE_PHPBB_PRIVMSGS_TEXT', 'phpbb_privmsgs_text');

// #CHAVEIRO16# END PHPBB2

 

I spoke to the site owner, he said he has no forum, but obviously this forum has been integrated into the system. Furthermore, There's a link to the forum admin within the OSC admin. I'm thinking the owner doesn't know what he has here. I'm told the installation is 6 years old. I'm guessing this OSC installation has been customized to include a forum (which btw, I can't find the front end to, so it may be old and partially removed).

 

Is there a STANDARD way to integrate phpbb into OSC? If so, can it be removed without causing problems with the rest of the site? Is there a document that describes the install/deinstall process of phpbb into OSC?

 

Thanks again for your help.

Posted

OK, that's helpful info. Now when I look at the database_tables.php file, I find a section at bottom as follows:

// #CHAVEIRO16# BEGIN PHPBB2

define('TABLE_PHPBB_USERS', 'phpbb_users');

define('TABLE_PHPBB_SESSIONS', 'phpbb_sessions');

define('TABLE_PHPBB_GROUPS', 'phpbb_groups');

define('TABLE_PHPBB_USER_GROUPS', 'phpbb_user_group');

define('TABLE_PHPBB_POSTS', 'phpbb_posts');

define('TABLE_PHPBB_TOPICS', 'phpbb_topics');

define('TABLE_PHPBB_VOTE_CUSTOMERS', 'phpbb_vote_voters');

define('TABLE_PHPBB_AUTH_ACCESS', 'phpbb_auth_access');

define('TABLE_PHPBB_TOPICS_WATCH', 'phpbb_topics_watch');

define('TABLE_PHPBB_BANLIST', 'phpbb_banlist');

define('TABLE_PHPBB_PRIVMSGS', 'phpbb_privmsgs');

define('TABLE_PHPBB_PRIVMSGS_TEXT', 'phpbb_privmsgs_text');

// #CHAVEIRO16# END PHPBB2

 

I spoke to the site owner, he said he has no forum, but obviously this forum has been integrated into the system. Furthermore, There's a link to the forum admin within the OSC admin. I'm thinking the owner doesn't know what he has here. I'm told the installation is 6 years old. I'm guessing this OSC installation has been customized to include a forum (which btw, I can't find the front end to, so it may be old and partially removed).

 

Is there a STANDARD way to integrate phpbb into OSC? If so, can it be removed without causing problems with the rest of the site? Is there a document that describes the install/deinstall process of phpbb into OSC?

 

Thanks again for your help.

 

You could have a look through the addons section to see if the addon was from there. Then you can undo the file changes and reverse the SQL changes. You should be able to drop those tables without it affecting your cart at all, BUT please don't do that without backing up first.

Posted

You could have a look through the addons section to see if the addon was from there.

Could be this one. Fits the name and time frame but there are others when looking for phpbb...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...