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? 7 2874
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...
.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
> 3) On the remote machine, command line: mysql -uUsername -pPassword Database < backup.sql
How do I do that on my ISP's remote machine?
.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
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?
.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
> 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 and change the settings for
the db connection and have it work? Is there anything that would prevent...
|
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.
|
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
|
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 no protests when built, ran and connected with no
|
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
beautifully on my local machine (file system web project).
However, when I copy this website to a...
| |
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
|
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 tired of my web-designer's unresponsiveness.
|
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 your database. This is generally considered to be the easiest and fastest way to store files.
...
|
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.
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |