How to upload using MySQL Workbench...?

[HappyGuyEpicure]

I have a small MySQL database which I manage through MySQL Workbench. Last week I created a heliohost account in order to upload the database and be able to access it via www.

 

I tried to use Workbench to upload the database to my heliohost account. Is that possible at all?

My settings were:

connection method: standard tcp/ip

host: wein.heliohost.org

port: 3306

user: happyguy_1 (database user name I created on cpanel)

password:******** (database password I created on cpanel)

default schema: happyguy_wein

 

It never works. What am I doing wrong?

 

 

[chentong]

I have a small MySQL database which I manage through MySQL Workbench. Last week I created a heliohost account in order to upload the database and be able to access it via www.

 

I tried to use Workbench to upload the database to my heliohost account. Is that possible at all?

My settings were:

connection method: standard tcp/ip

host: wein.heliohost.org

port: 3306

user: happyguy_1 (database user name I created on cpanel)

password:******** (database password I created on cpanel)

default schema: happyguy_wein

 

It never works. What am I doing wrong?

 

 

I'm not sure that I understood what you said.

host:localhost ????

 

[jje]

Change

host: wein.heliohost.org

to

host: localhost

 

[HappyGuyEpicure]

Thank you for your hint, but I do not understand that:

I always thought localhost is my own computer. But I want to upload the database from my computer to wein.heliohost.org!?!

 

..................

Change

host: wein.heliohost.org

to

host: localhost

 

[jje]

I am slightly confused over your question. Would you like to connect to the database from your computer, or from wein.heliohost.org?

 

If you wish to connect from your own computer, then go into 'Remote SQL' in cPanel and put a * or % in the box. Then use one of the below hosts, depending on which server you are on:

host: stevie.heliohost.org

host: johnny.heliohost.org

 

If you wish to connect from our server, then enter:

host: localhost

This is because that you will be connecting from the server, and from the the servers point of view, the MySQL engine is on the same server, so localhost will do fine.

[cl58]

Localhost is relative to whatever computer the files are hosted on. Since your files are hosted on HelioHost's servers, localhost refers to whatever server you are using (Stevie or Johnny).

[HappyGuyEpicure]

Thank you! It worked... I am now trying to upload my database from my local server to stevie..... ;-)

[jje]

Glad your problem got solved!

 

Please spare 2 minutes to fill in our quick survey:

http://www.helionet.org/index/index.php?showtopic=8947

Your participation in this survey is greatly appreciated