Uploading Database

[DnJ]

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

[Guest]

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.

[ths5949]

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?