macroflux Posted August 28, 2003 Posted August 28, 2003 hey guys, any ideas on automating a replication of an OSCommerce database product tables to other OSCommerce databases, so that they are all differnet except for the products? i havent been able to find an automated SQL replication process, i've just moved off of other OS's and have only been using PHP/MySQL for 6 months, so if anybody could just point me in the right direction, that'd be fantastic!! big thanks to anybody who bothers to answer a noob question! :)
Guest Posted August 28, 2003 Posted August 28, 2003 Do a normal backup. On the new host you can put that backup .sql (make sure it is pure sql, not compressed) in install and rename it oscommerce.sql and do the normal install. Or do your install and then go to admin.backup and restore useing your saved backup.
macroflux Posted August 28, 2003 Author Posted August 28, 2003 would that be for just the products? i need everything else to remain seperate-customers, orders, etc.
Guest Posted August 28, 2003 Posted August 28, 2003 The osc bu does not allow you to pck and chhose so then you have to use a sql admin tool like phpmyadmin. just export whatever table to a file...make sure you specofy "drop table" and then import into the new db.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.