Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Uploading Database


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



"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


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

  • Create New...