Moving Database

[rc133]

I am sorry if this has been answered already but I have spent a good few minutes searching and cannot find a related topic.

 

I have been configuring and testing osCommerce locally and I am now pleased with what I have and am ready to upload it to my web server.

 

I understand that all that needs changing is the configure.php file to point to the different server etc.

 

But how do I move the database? it is currently empty so I dont mind if it is rewritten!

 

Could someone who has the knowledge please share as I am rather new to all this and I dont want to balls it up!

[Guest]

I this a new install, and you don't care about preserving products in the database, then just create a new one on your webhost and import oscommerce.sql.

 

-jared

[rc133]

I this a new install, and you don't care about preserving products in the database, then just create a new one on your webhost and import oscommerce.sql.

 

-jared

<{POST_SNAPBACK}>

 

I have changed quite alot from the original install and did not really want to change it all again.

 

Is there anyway of doing it so I dont have to do a fresh install

 

Thanks Rob

[Guest]

Sorry -- I must have misinterpreted

But how do I move the database? it is currently empty so I dont mind if it is rewritten!

 

You can backup your database with mysqldump or phpMyAdmin (export option).

 

-jared

[♥Vger]

But how do I move the database? it is currently empty so I dont mind if it is rewritten!

 

If all that you have changed are files then just use phpMyAdmin (available from your web hosting control panel) to set up a balnk database, and then import the oscommerce.sql file into it. Or import the contents of your local sql file (that you have been working on).

 

Then, upload all of your files to your web hosting space and just redo the configure.php files manually.

 

Vger