Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Replication help!!!


macroflux

Recommended Posts

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! :)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...