473,544 Members | 2,249 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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?
Jul 17 '05 #1
7 2850
In article <41************ ***********@ptn-nntp-reader02.plus.n et>,
"aa" <aa@virgin.ne t> 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...

Jul 17 '05 #2
.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
Jul 17 '05 #3
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?
Jul 17 '05 #4
.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
Jul 17 '05 #5
aa
I made some search.
If you mean that on my local machine from the command line I enter
mysql -h name_of_the_rem ote_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_rem ote_host (10060)

What should I do about it?
Jul 17 '05 #6
.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_rem ote_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_rem ote_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
Jul 17 '05 #7
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
Jul 17 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1904
by: Abby | last post by:
I have an application that is written in php/mysql on a Linux platform and need to transfer hosts. This is a session based application and I don't know a lot about php/Linux/mysql, but can get by. I know windows/asp, etc. much more extensively. So, can I just move the whole thing over to a Windows server, upload the mysql backup database...
0
1433
by: Andrew Keating | last post by:
------=_NextPart_000_0005_01C36576.78A1ECD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit To whom it may concern, We are having some trouble installing a MySQL database onto one of our servers and would appreciate some assistance, details are below.
0
3928
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
1
3360
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer uses his own php shopping cart to receive customer orders. The configuration was done via cPanel with no external modifications - which produced...
3
1671
by: JayD | last post by:
(Not sure whether it is a general aspnet problem or a specific security problem, hence posting it in 2 groups). This will solve for us a number of problems. I have developed a website on my local machine (part of a LAN) using Visual Web Developer, with ASP.NET 2.0. Backend is a SQL Server 2000 database. All queries and webforms work...
2
2684
by: balavignesh | last post by:
Hello frends! I want to connect with mysql using php. In my mysql "my.cnf" file i have specified the socket for both client and server as "/usr/local/mysql/var/mysql.sock" In my "php.ini" file, for mysql socket i have specified
4
2344
by: nurcan.kurtoglu | last post by:
Hi, I have a .php site which uses a mysql database. I would like some info on how I can download (preferably free and simple) and use a GUI. As in, I know they exist, but do I need to put it into the server (plesk interface), or use it on my pc, and then how do I access the site's database to modify entries. And all this because I'm...
221
367070
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in...
2
1908
by: garther | last post by:
Hi I'm trying to get something like this to work: Application calculates data and stores them in local SQL server. Once a week this data needs to copied to DVD. Then I need second application which has to take this data from DVD and send to global SQL server. Talking directly from remote hosts to main database is not an option.
0
7438
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7632
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7783
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7720
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5931
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5309
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3430
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3422
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
996
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.