How do I import my exsisting mySQL DB onto server?

[Rob Petterson]

Hi all,

I have my cart on localhost on my pc and am in the process of putting this up onto the internet.

I've uploaded my catalog / admin directories onto my root directory on my hosts server and have set permissions.

I can view my site no problem.

 

The issue I'm having is that it's using the default database and I want it to use the database with my own products which is currently stored on my pc. How do I transfer this DB to overwrite the default one that gets loaded onto my ISP's server? BTW they both have different names - I don't know whether this makes any difference.

[equilla]

Hi Rob,

 

if you've got phpmyadmin installed at either end (PC and server) then the easiest thing to do is to use the export on the PC and save to a text file on your hard disk.

 

Now you need to use phpmyadmin on the server to clear the tables from the existing database and use the import facility to upload the file you just created.

 

The fact that the databases have different names makes no difference.

 

Don't forget that you also need to upload the images for all your products to the images folder on the server too.

 

Cheers,

 

 

Mark

[Rob Petterson]

Cheers Mark,

I'll give it a whirl when I get in tonight. I'll do it before I get stuck into the Stella's.

 

Rob

[Rob Petterson]

OK, so far in phpMyAdmin I've ticked the checkbox for saving the file in sql format to my hard drive.

 

How do I do this next bit?

 

Mark wrote:

'Now you need to use phpmyadmin on the server to clear the tables from the existing database and use the import facility to upload the file you just created. '

 

Can someone explain in a bit more detail how I clear the tables on the server and also how to import mySQL file on my pc to the hosts server.

 

I've got phpMyAdmin on my localhost and I'm using Cuteftp file management.