473,513 Members | 2,676 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql db replication

Hi I'm trying to replicate a database to a server.

from the server I try :

mysqldump -h remote_host --opt --compress eslsl -u dbmaster -p \ mysql eslsl
Enter password:
mysqldump: Got error: 2003: Can't connect to MySQL server on
'remote_host' (60) when trying to connect

I'm sure from the remote host name / ip but still can't connect from
another machine.

Does someone see what's going on. Is that a permission trouble ?

Thanks in advance.
Jul 23 '05 #1
2 1607
Alexandre Jaquet a écrit :
Hi I'm trying to replicate a database to a server.

from the server I try :

mysqldump -h remote_host --opt --compress eslsl -u dbmaster -p \ mysql
eslsl
Enter password:
mysqldump: Got error: 2003: Can't connect to MySQL server on
'remote_host' (60) when trying to connect

I'm sure from the remote host name / ip but still can't connect from
another machine.

Does someone see what's going on. Is that a permission trouble ?

Thanks in advance.

I can^'t understand. I can access mysql server trough phpmyadmin (under
https) but not by command line :(
Jul 23 '05 #2
Alexandre Jaquet <al***@floor.ch> wrote in
news:d0**********@news.hispeed.ch:
Hi I'm trying to replicate a database to a server.

from the server I try :

mysqldump -h remote_host --opt --compress eslsl -u dbmaster -p \ mysql
eslsl Enter password:
mysqldump: Got error: 2003: Can't connect to MySQL server on
'remote_host' (60) when trying to connect

I'm sure from the remote host name / ip but still can't connect from
another machine.


it is quite likely that whoever admins your database does not allow non-
local connections to the database.
Jul 23 '05 #3

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

Similar topics

0
3510
by: Lenz Grimmer | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary...
0
3248
by: I.P. | last post by:
Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my...
0
2117
by: I.P. | last post by:
No one has replied to my post. ----- Original Message ----- From: "I.P." <jancio_wodnik@wp.pl> To: <mysql@lists.mysql.com> Sent: Monday, August 18, 2003 1:01 PM Subject: mysql 4.0.14 +...
1
2165
by: adiavr | last post by:
Hi, I have read up on MySQL failover/replication and decided that weren't many cons to setting up two way replication where two servers are both master and slave to eachother. Here's the my.cnf:...
1
1724
by: Uli | last post by:
Hello group, i am relatively new to SQL-Server database, but i have lots of experience with DB2 and Oracle Database. One of my tasks is setting up a replication between a Mysql-Database running...
39
8367
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...
2
4911
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection...
13
2289
by: Jim Hubbard | last post by:
I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the...
3
6072
by: Juan Antonio Villa | last post by:
Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to the slave, an example update reads as follows:...
0
12870
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
0
7158
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7535
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...
1
7098
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...
0
7523
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...
0
5683
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,...
0
3232
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...
0
3221
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
455
bsmnconsultancy
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...

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.