Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

site @ database migration


andytc

Recommended Posts

Posted

Hi

 

Can anyone tell me the correct method for migration to a new server ?

 

Do i need "drop table" and "if not exists" in my DB backup using PHP MYADMIN ?

 

How many files will i need to edit ? is it just config ?

 

I have quite a few mods installed , but the DB is not very large

 

 

any help will be appreciated before i get started

Posted
Do i need "drop table" and "if not exists" in my DB backup using PHP MYADMIN ?

 

I don't think you do. As long as your not trying to replace existing tables when you import it into your new database.

 

The only problem I've had is trying to import a database that was backed up using mysql5 into a mysql4. But it can be easily fixed.

 

How many files will i need to edit ? is it just config ?

 

Just 2. /admin/includes/configure.php and /includes/configure.php

Other great Open Source (Free) programs: (Free as in free speech not free beer)

The Gimp - An image program. | Firefox - All you have to do is add the Web Developer add-on to make this web browser complete. | FileZilla - An ftp program. | Inkscape - A good program to create images with. | Thunderbird - An email program. | Openoffice.org - An office suite that is compatible with MS Office. | Abiword - Another office suite. | Audacity - A sound recording tool. | ddp's Picks | Wordpress - An easy to use blogging software. | Joomla - An easy to use CMS that has ecommerce plug-ins. | Drupal - Another CMS

How do I find these programs? Google Search!

Posted

Ok thanks.

 

One other question.

 

Will I be able to migrate my existing install on a linux server to windows based server ?

Posted

I'm sure you can. You'll just have to deal with different paths in your config files. The best way to do that is to do a test install on your new server with a default OSC then you can take a look at your paths in the configure files.

Other great Open Source (Free) programs: (Free as in free speech not free beer)

The Gimp - An image program. | Firefox - All you have to do is add the Web Developer add-on to make this web browser complete. | FileZilla - An ftp program. | Inkscape - A good program to create images with. | Thunderbird - An email program. | Openoffice.org - An office suite that is compatible with MS Office. | Abiword - Another office suite. | Audacity - A sound recording tool. | ddp's Picks | Wordpress - An easy to use blogging software. | Joomla - An easy to use CMS that has ecommerce plug-ins. | Drupal - Another CMS

How do I find these programs? Google Search!

Archived

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

×
×
  • Create New...