Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Uploading Database


DnJ

Recommended Posts

I have my store working perfectly on my local machine and now want to transfer the contents of my database to my web server.

 

Can someone please tell me how to do this - I have created a database on my server and when I open phpmyadmin it gives me 2 options

 

1. Structure

2. Sql

 

When I try to use the Sql browse and select a database table it gives a syntax error.

 

There must be a way to copy these table over.

 

Thanks for any help

 

Doug

"One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"

Link to comment
Share on other sites

on your local system, go to the admin area, and then tools/backup. select backup. then go to the server and use sql to restore the file.

 

portions explained in the documentation.

Link to comment
Share on other sites

Tools - Db Backup

 

 

Click on the "backup" button.

 

Choose GZIP, ZIP, or pure sql.

 

Click "Download only" to download to your harddrive. A box will pop up for you to pick the folder to put it in.

 

Will this above work if I had a store developed by someone else that I want to now setup on my local machine inorder to test changes. If so do i just backup into the catalog folder that i set up when i setup the example store?

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...