mythx_lv Posted August 25, 2010 Posted August 25, 2010 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.
Jan Zonjee Posted August 25, 2010 Posted August 25, 2010 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.
mythx_lv Posted August 25, 2010 Author Posted August 25, 2010 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?
Hotclutch Posted August 25, 2010 Posted August 25, 2010 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.
Jan Zonjee Posted August 25, 2010 Posted August 25, 2010 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.
mythx_lv Posted August 25, 2010 Author Posted August 25, 2010 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.
Hotclutch Posted August 25, 2010 Posted August 25, 2010 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.
Jan Zonjee Posted August 25, 2010 Posted August 25, 2010 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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.