Transferring a MySQL database from local PC onto an ISP server

[aa]

If I have an MySQL database on my local w2k, how do I transfer it onto my
ISP server?
The ISP gave me the name of an empty MySQL database they set up for me, the
username and the password with no further explanations.
I came here from ASP/Access where I was just uploading a mdb file into my
webspace.
But with MySQL there should be a different procedure, should it not?

[Michael Vilain]

In article <41***********************@ptn-nntp-reader02.plus.net>,
"aa" <[e-mail]> wrote:

If I have an MySQL database on my local w2k, how do I transfer it onto my
ISP server?
The ISP gave me the name of an empty MySQL database they set up for me, the
username and the password with no further explanations.
I came here from ASP/Access where I was just uploading a mdb file into my
webspace.
But with MySQL there should be a different procedure, should it not?

Read the man page for mysqldump, which should be on your system if you
installed MySQL. And do some selected reading on MySQL from whatever
books work for you. I like the O'Reilly books and articles:

http://www.oreilly.com/catalog/msql2/index.html
http://tinyurl.com/5jyu3

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[Michael Fesser]

.oO(aa)

If I have an MySQL database on my local w2k, how do I transfer it onto my
ISP server?

Assuming you have shell-access to the server:

1) On your local machine, command line:

mysqldump -uUsername -pPassword Database > backup.sql

2) Upload the file backup.sql.

3) On the remote machine, command line:

mysql -uUsername -pPassword Database < backup.sql

Micha

[aa]

> 3) On the remote machine, command line:

mysql -uUsername -pPassword Database < backup.sql

How do I do that on my ISP's remote machine?

[Michael Fesser]

.oO(aa)

3) On the remote machine, command line:
mysql -uUsername -pPassword Database < backup.sql

How do I do that on my ISP's remote machine?

You need a shell account on that server.

If you're not able to login to the server using a secure shell (SSH) for
example you have to find another way. You could use phpMyAdmin or set up
a simple script that executes the command on the server.

XCIV. Program Execution Functions
http://www.php.net/manual/en/ref.exec.php

Micha

[aa]

I made some search.
If you mean that on my local machine from the command line I enter
mysql -h name_of_the_remote_host -u my_username -p

then it indeed asks for a pw, which means that it recognised the server
name. Howver after I ebter the pw, an error 2003 is returned:
Can't connect to MySQL server on name_of_the_remote_host (10060)

What should I do about it?

[Michael Fesser]

.oO(aa)

I made some search.
If you mean that on my local machine from the command line I enter
mysql -h name_of_the_remote_host -u my_username -p

then it indeed asks for a pw, which means that it recognised the server
name. Howver after I ebter the pw, an error 2003 is returned:
Can't connect to MySQL server on name_of_the_remote_host (10060)
That's how it's supposed to be. A database server on a public host
should not be accessible from remote machines.
What should I do about it?

First question: Are you able to login to the remote machine using SSH or
PuTTY or something like that? If unsure check with your host, maybe they
have a FAQ section.

Micha

[aa]

> First question: Are you able to login to the remote machine using SSH or

PuTTY or something like that?

Never heard of PuTTY or SSH - will check and revert