stupid question about uploading mysql database online

[taya]

Hello

this is probably a stupid question

i built my 1st database and when i was installing mysql i installed it as localhost on my PC

but now as i have a hosting i pay for
i'd like to upload my database and play with it online.

the support of my hosting company told me i might use telnet or ftp or something else ( i forgot) to upload and update database there,
i have password and login,

but i have no idea how to do that.

i understand idealy i could do it in mysql command line (black window where i create my tables , etc)
to connect with them and do the stuff.

please help me

Taya

[Xo_]

Well, you can dump your mysql database... refer to the manual on how to dump a database into a file, and then use phpmyadmin (your host most surely has it installed) and run that same file from there...

Hope you got it...

Cheers

[taya]

thank you so much for your prompt answer!

i understand i can download myphpadmin from
http://sourceforge.net/project/showfiles.php?group_id=23067&release_id=161661
for free

i'm not sure what dumping database on a file means and now trying to find it in manual i have

but if you could explain more about it would be great as my vocabulary (english) is not as good as i wish

thanks!

PS i just called them they say they don't have phpmyadmin installed but i can install it in my directory at their hosting.....

[dalecosp]

You can "dump" a MySQL database by using the "mysqldump" command from the command prompt, IIRC. I believe it creates an SQL language file that you can run at the MySQL prompt to recreate your database (it contains all the create table and insert into statements...)

Of course, you need create, Insert privileges on db.....

MyPHPAdmin might be better option after all....

HTH,

[Xo_]

Well, after installing phpmyadmin, chose the database you want dump. Then click in Export, chose Structure and Data and then submit
It'll give you a page full of text.
Copy that text and paste it on a file called database.sql

then you just need to create that same db on the server, choose it, choose SQL, then browse, choose the file you created (database.sql) and click go
If all went well you should have your db upload to the server,,,

Greetz

[taya]

ok i downloaded my php admin
, unzipped it

and now trying to do configurations in config.inc.php file

i understand that after i do smth (hopefully correctn)

i need to put the folder in the root directory of C and copy it via ftp to my host as a separate folder let's say "myPhpAdmin'

do you think i think in a right direction?

and how this thing will work?

wow i'm amazed at myself now!
:-)

[toddmarx]

sqlYOG is another powerful mysql tool. I use it and phpmyadmin

You can get sqlYOG here:
http://www.webyog.com/sqlyog/download.html

It saves pre-set connections. You can create connections for your localhost, and for your "live" host. Very easy to use.

[BeastRider]

Originally posted by taya
Hello

this is probably a stupid question

No, actually, getting a MySql database from one machine to the other can be quite daunting if any pieces of software are not available.

but now as i have a hosting i pay for
i'd like to upload my database and play with it online.

the support of my hosting company told me i might use telnet or ftp or something else ( i forgot) to upload and update database there, i have password and login,
Taya

It sounds like your ISP is not well acquainted with MySql. For starters:

a) the MySql server system requires that all databases be stored in a data directoy that is specified in the MySql config files. Most often, this is a single directory. Thus, in this directory, you will find the databases of all users who are using MySql at your ISP, and thus, it is very unlikely that you can use ftp or telnet or anything to upload a database because of security concerns. This directory is always protected and only available through protected maintenance programs like phpMyAdmin. Simply ftp'ing your database to your root html directory will do no good since that is outside of the MqSql data space.

b) What operating system is your ISP using? If Linux or other Unix, you probably have cpanel or a similar control panel that lets you define databases that will be available to MySql and to define users who can access the database.

c) It is real messy trying to use the command line mysqldump command to create a file on the source machine to be loaded by phpMyAdmin on your ISP machine. I struggled mightily with this problem, and finally gave up and installed phpMyAdmin on my local machine as well. This solved all my problems.

[dalecosp]

Insightful post from a good looking monkey. We should probably remember that almost nothing is as simple in practice as it is in theory.

I advocated MySQL dump as it is built for the purpose. I did state the quid pro quo that the permissions must be sufficient for the 'create database' and 'create table' statements... along with Insert, whatever...

I might be possible to take the 'dump' file and modify it so it simply modified whatever db the hosting company gave to you.

In either instance, given permission and access to the SQL monitor program, it'd be simple, at least in theory. 😉

a. ftp the file to a location in your tree.
b. close the shell and telnet in... <really? who still uses telnet? What's your domain so I can get my sniffer on line...>
c. $mysql < mydumpfile.sql

[taya]

thanks a lot guys!

trying to figure out what to do next.

my friend from russia sent me putty 0.53.b

she said it's a program her friend uses all the time.

it looks like telnet window to me.

and it looks very simple comparing to myphp admin as i'm not a programmer :-)

i guess i need to ask my providers what kind of operating system they use and if they have linux or unix i'll demand cpanel :-)

otherwise i'll install phpmyadmin on my computer and then will try to install phpmyadmin on theirs - but how? ftp it?

ok thanks

[BeastRider]

You need to find out if your service provider supports MySql databases. This is the number one question. If the answer is yes, then almost certainly, they will have phpMyAdmin or something similar because EVERY user of MySql needs to do what you want to do. In a similar vein, if the service provider supports MySql, then it is almost a given that there will be cpanel or something similar because EVERY user of MySql needs to manage hosts, databases, and users.

Within the world of service providers you are basically going to find Microsoft driven sites (Windows, IIS, and MS Sql databases) and you will find Unix sites. Many Unix sites are called LAMP sites... for Linux, Apache, MySql, and PHP. Why? Because they are really, really, really cheap... aka, free.

So, if your service provider supports MySql, the chances are excellent that he/she will also have all the support utilities you will need. If your service provider is running a Microsoft powered site, then MySql may or may not be available. You may need to look at another database.

But again, the first thing to do is find out what sort of animal you are dealing with when it comes to your service provider. Until you know that, talking about software packages doesn't do much good.

[taya]

below is the email from my provider - in case it might be useful for someone :-)

"Hello,

I created my database on my PC here and wanted to put it online to play with
it.

You will need to export the data on your PC Mysql database into a text
file, then upload the text file, and then import it into the database on
our server.

when i called you've recommended me to use telnet - but i think it might be
not very safe in security terms,

SSH is actually more secure then telnet. However, if you are not
familiar with SSH, you can use telnet.

also you've said it's possible to install myphpAdmin on your machine as well
as on mine and upload and edit files from my PC on your hosting.

do you think it's possib;e to do it with the other programs like sqlYOG?

sqlYOG is a windows based application and will not run on our servers.

HOW should i install any mysql tool on your hosting? ftp it?

The mysql tools are simply CGI scripts, so they would be installed like
any other CGI script.

also - i thought if you have unix/linux operating system you might have some
kind of cpanel or similar control panel that would let me define
databases that will be avaliable to mySQL and to define users who can
acess database?

Your account settings (via our web site), does have a section for "MySQL
Databases". In this section, you can create the database, the user and
password. Only one user can be assigned per database."

[dalecosp]

Originally posted by taya
thanks a lot guys!

trying to figure out what to do next.

my friend from russia sent me putty 0.53.b

she said it's a program her friend uses all the time.

it looks like telnet window to me.

and it looks very simple comparing to myphp admin as i'm not a programmer :-)

PuTTY is Simon Tatham's free telnet/SSH/any terminal client. Well, most any terminal, anyway. ftp site is [url]ftp://chiark.greenend.org.uk/users/sgtatham[/url]

SSH is superior to Telnet because Telnet is not encrypted, so passwords and all commands are sent 'in the clear'. There are forms of "encrypted telnet" that are more telnettish <?> than SSH, but, basically, a shell is a shell and a terminal is a terminal, right?

OTOH, if you must have something graphical, that's what PHPMyAdmin is for, I guess....

i guess i need to ask my providers what kind of operating system they use and if they have linux or unix i'll demand cpanel :-)

ok thanks

Why? 😉 learn the CLI, good job stuff, perhaps...