Re: Remote Access to MySQL

2015-03-09 Thread patrick
wrote: - Original Message - From: "Rafael Ribeiro" Subject: Remote Access to MySQL After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost the ability to connect to mysql remotely, from external IPs. "It doesn't work" is not a helpful comm

Re: Remote Access to MySQL

2015-03-09 Thread Johan De Meersman
- Original Message - > From: "Rafael Ribeiro" > Subject: Remote Access to MySQL > > After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost > the ability to connect to mysql remotely, from external IPs. "It doesn't work"

Re: Remote Access to MySQL

2015-03-09 Thread Pothanaboyina Trimurthy
om external IPs. >> >> I read a lot of tutorials and tips without success. >> >> What I need to do, to come back to working configuration like oldest >> machine, allowing remote connections? >> > > did you check "bind-address" in your my.cnf?

Re: Remote Access to MySQL

2015-03-09 Thread Florian Schaal
ty to connect to mysql remotely, from external IPs. I read a lot of tutorials and tips without success. What I need to do, to come back to working configuration like oldest machine, allowing remote connections? did you check "bind-address" in your my.cnf? regards Florian -- MySQL

Re: Remote Access to MySQL

2015-03-07 Thread Thufir
On Sat, 07 Mar 2015 21:49:10 -0300, Rafael Ribeiro wrote: > I read a lot of tutorials and tips without success. > > What I need to do, to come back to working configuration like oldest > machine, allowing remote connections? By no means am I an expert, but, while not specific to y

Remote Access to MySQL

2015-03-07 Thread Rafael Ribeiro
s. I read a lot of tutorials and tips without success. What I need to do, to come back to working configuration like oldest machine, allowing remote connections? Thanks in advanced! Atenciosamente, Rafael Ribeiro – CEO XPS NetWorks Group rafael.ribe...@xpsnetworks.net Skype: xpsnetworks Celula

Re: Problem accessing phpmyadmin using IP from remote machine

2012-12-11 Thread Girish Talluru
Hi Abhishek, Yes I can do that. On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain wrote: > Can you ping ip 192.168.1.9 from other machines? > On Dec 11, 2012 11:21 AM, "Girish Talluru" > wrote: > >> Hi Guys, >> >> I have environment as specified below. >> >> Main server: Windows Server 2008 >> Vir

Re: Problem accessing phpmyadmin using IP from remote machine

2012-12-10 Thread abhishek jain
Can you ping ip 192.168.1.9 from other machines? On Dec 11, 2012 11:21 AM, "Girish Talluru" wrote: > Hi Guys, > > I have environment as specified below. > > Main server: Windows Server 2008 > Virtual Box: Oracle VM > VM OS: Ubuntu > > Inside Ubuntu I downloaded and configured Apache, MySql, PHP

Re: Remote mysql too slow

2012-04-09 Thread Noel Butler
On Mon, 2012-04-09 at 06:14 -0500, Johnny Withers wrote: > right speed and duplex. It seems that every new server I get now has > to have the speed and duplex explicitly set instead of auto negotiate. > Many of the cisco switches are notorious for this. signature.asc Description: This is a

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 13:17:55 +0200 Reindl Harald wrote: > > > Am 09.04.2012 13:05, schrieb J. Bakshi: > > I have reset these two now > > > > ` ` ` ` > > key_buffer_size=200M > > innodb_buffer_pool_size=4G > > [!!] InnoDB data size / buffer pool: 3.6G/8.0M > > there did go something terrible

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 13:05, schrieb J. Bakshi: > I have reset these two now > > ` ` ` ` > key_buffer_size=200M > innodb_buffer_pool_size=4G [!!] InnoDB data size / buffer pool: 3.6G/8.0M there did go something terrible wrong what is the mysqld log saying at startup? waht about post your complete my.

Re: Remote mysql too slow

2012-04-09 Thread Johnny Withers
which I can add/configure to make the network latecy > small or any such mechanism to make the query fast ? > > > I run the mysqltuner directly on the remote mysql server; and here is the > result > > ``` > General Sta

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
> and yow your queries are written > >> > >> keep in mind that only connect has 15-20% overhead > >> compared with a unix socket and if your network is > >> too slow you notice latency more and more > >> > >> additionally your queries have more impac

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
;> too slow you notice latency more and more >> >> additionally your queries have more impact >> if you have usually very small results by optimized queries >> this makles the db-server himslef possibly better suited >> but keep in mind taht your querie himself must over

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
very small results by optimized queries > this makles the db-server himslef possibly better suited > but keep in mind taht your querie himself must over the wire > > > I run the mysqltuner directly on the remote mysql server; and here is the > > result > > [OK] Key buffer

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
network is too slow you notice latency more and more additionally your queries have more impact if you have usually very small results by optimized queries this makles the db-server himslef possibly better suited but keep in mind taht your querie himself must over the wire > I run the mysqltuner d

Remote mysql too slow

2012-04-09 Thread J. Bakshi
mechanism to make the query fast ? I run the mysqltuner directly on the remote mysql server; and here is the result ``` General Statistics -- [--] Skipped version check for MySQLTuner script [OK

Re: Mysqld remote dont stop

2012-03-28 Thread Johan De Meersman
- Original Message - > From: "AdmSA" > We have a problem when we try to stop the mysql service (mysql Ver > 14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a > remote server throught SSH. > The problem is that mysql_safe, start again mysqld bef

Mysqld remote dont stop

2012-03-28 Thread AdmSA
Hello: We have a problem when we try to stop the mysql service (mysql Ver 14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a remote server throught SSH. The problem is that mysql_safe, start again mysqld before that mysql kill all the connection and stop the process. So cannot

Re: Remote access of MySQL

2011-06-04 Thread Reindl Harald
s is denied for user root. > > It looks that MySQL remote access is blocked. Can someone suggest me which > variable to add or change in my.cnf file? or I have to change something else > so that I can access MySQL databases from other computers using ODBC signature.asc Description: OpenPGP digital signature

Re: How to dump MySQL data on remote server using mysqldump

2010-09-02 Thread Jangita
On 02/09/2010 7:19 a, James Corteciano wrote: How could I put the dump data on web server and not the local disk on mysql server? Log into the web server and do it from there? or copy the file onto the web server? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jangita | GTalk

Re: How to dump MySQL data on remote server using mysqldump

2010-09-02 Thread Johan De Meersman
>From the mysqldump manpage, on the -T option: Note > This option should be used only when mysqldump is run on the same machine > as the mysqld server. You must have the FILE privilege, and the server must > have permission to write files in the directory that you specify. > In other words, you'v

RE: How to dump MySQL data on remote server using mysqldump

2010-09-01 Thread Rolando Edwards
Worx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: James Corteciano [mailto:ja...@linux-source.org] Sent: Thursday, September 02, 2010 1:19 AM To: mysql@lists.mysql.com Subject: How to dump MySQL data on remote server using mysqldump Hi, I have m

How to dump MySQL data on remote server using mysqldump

2010-09-01 Thread James Corteciano
Hi, I have mysql server separated from web server. My problem is, when I dump the data from database using the command "mysqldump -uuser -p -h mysql_server -t -T /tmp/dbname database_name" on web server, all data were dumped to the /tmp/dbname of mysql server and not inside of web server. [web]$

Re: Allowing Connections From Remote Clients

2010-07-26 Thread jayabharath
Hi Carlos, >From your trailing mail I noticed the below GRANT. This will just give 'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases. *Access to mysql:* | GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED BY PASSWORD '' | In addition t

Re: Allowing Connections From Remote Clients

2010-07-26 Thread Carlos Mennens
Guys - I am no expert but I don't think this is a DNS or rDNS issue. All resolution appears to be working fine. When my PC (tuna) attempts to connect to the MySQL server via MySQL Workbench, it says "Failed to Connect to MySQL at mysql.iamghost.com:3306 with user root Host 'tuna.iamghost.com' is no

Re: Allowing Connections From Remote Clients

2010-07-14 Thread Carlos Mennens
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote: > GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD 'password'; > > *.* ie for all databases , if want on particular DB > > GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com' > IDENTIFIED BY

RE: Allowing Connections From Remote Clients

2010-07-13 Thread Gavin Towey
:mich...@weblore.com] Sent: Tuesday, July 13, 2010 12:54 PM To: mysql@lists.mysql.com Subject: Re: Allowing Connections From Remote Clients On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote: > GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD &#x

Re: Allowing Connections From Remote Clients

2010-07-13 Thread Michael Satterwhite
On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote: > GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD 'password'; > > **.** ie for all databases , if want on particular DB > > GRANT ALL PRIVILEGES ON *MyDATABASE.** TO username@'tuna.iamghost.com' > ID

Re: Allowing Connections From Remote Clients

2010-07-13 Thread Prabhat Kumar
lowed to connect to this MySQL server." > > Can someone please tell me what I need to do so I can allow remote > connections to the database from the MySQL workbench application? I > have access to MySQL via CLI. > > Thank you! > > -- > MySQL General Mailing List &g

Allowing Connections From Remote Clients

2010-07-13 Thread Carlos Mennens
to do so I can allow remote connections to the database from the MySQL workbench application? I have access to MySQL via CLI. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How can I see the query from a remote session against my server

2010-06-09 Thread Michael Dykman
, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > > www.the-infoshop.com > >>-Original Message- >>From: Anirudh Sundar [mailto:sundar.anir...@gmail.com] >>Sent

RE: How can I see the query from a remote session against my server

2010-06-09 Thread Bill Dossett
log working if possible as it sounds pretty useful, so thanks again. Bill -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: 09 June 2010 16:43 To: 'Anirudh Sundar'; mysql@lists.mysql.com Subject: RE: How can I see the query from a remote session against my s

RE: How can I see the query from a remote session against my server

2010-06-09 Thread Jerry Schwartz
om: Anirudh Sundar [mailto:sundar.anir...@gmail.com] >Sent: Wednesday, June 09, 2010 9:47 AM >To: mysql@lists.mysql.com >Subject: Re: How can I see the query from a remote session against my server > >Michael is right. But sometimes General log is not enabled and if that is >the case th

Re: How can I see the query from a remote session against my server

2010-06-09 Thread Michael Dykman
error saying the query is empty back at us. >> > >> > I am an IT manager and I don't know much about how our software scripting >> system works or even if there is a debugger, so I was just trying to attack >> the problem from the server side to see if I could see t

Re: How can I see the query from a remote session against my server

2010-06-09 Thread Anirudh Sundar
so I was just trying to attack > the problem from the server side to see if I could see the query at the > server... I thought profiling might help, but that only helps me with the > session that I am connected to as far as I can see anyway, I'm not seeing > any of the queries that a

Re: How can I see the query from a remote session against my server

2010-06-09 Thread Michael Dykman
as I can see anyway, I'm not seeing any > of the queries that are being generated by the remote seesion through the > odbc connector... > > Is there some way the I can see the queries that are being run against this > server from the remote session?  As this is a test system and i

How can I see the query from a remote session against my server

2010-06-09 Thread Bill Dossett
m from the server side to see if I could see the query at the server... I thought profiling might help, but that only helps me with the session that I am connected to as far as I can see anyway, I'm not seeing any of the queries that are being generated by the remote seesion through the

Re: remote mysqldump to csv (--tab)

2010-05-04 Thread walter harms
T a, b, c INTO OUTFILE '/tmp/result.txt' >> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' >> LINES TERMINATED BY '\n' >> FROM test_table >> >> more info see the link >> http://dev.mysql.com/doc/refman/5.0/en/selec

Re: remote mysqldump to csv (--tab)

2010-05-04 Thread Marijn Vandevoorde
select-into-statement.html Carlos Caldi > Date: Wed, 28 Apr 2010 14:11:14 +0200 > From: ma...@psb.vib-ugent.be > To: mysql@lists.mysql.com > Subject: remote mysqldump to csv (--tab) > > Hi all, > > posted this in the backup list, but that one seems to be pretty de

RE: remote mysqldump to csv (--tab)

2010-04-28 Thread Carlos Eduardo Caldi
re info see the link http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html Carlos Caldi > Date: Wed, 28 Apr 2010 14:11:14 +0200 > From: ma...@psb.vib-ugent.be > To: mysql@lists.mysql.com > Subject: remote mysqldump to csv (--tab) > > Hi all, > > posted t

remote mysqldump to csv (--tab)

2010-04-28 Thread Marijn Vandevoorde
Hi all, posted this in the backup list, but that one seems to be pretty dead, so i'll try my luck again here: We're currently looking for a way to backup a pretty big mysql table to a csv file. However, we don't want to allow the user ssh or file access to the server, so it'd have to happen

reaction to mysql remote buffer overflow 0day being posted online?

2010-01-10 Thread Brian Krebs
a large number of 0day vulnerabilities in database and web server products, including at least one -- possibly two -- remote buffer overflows in mysql. I've interviewed clueful folks who vouch for this guy's chops, so I know he's not making this up. As you may have guessed by now

RE: Select from remote server from stored procedure

2009-12-09 Thread Neil Aggarwal
Steve: > I suppose maybe making this a slave table > to the other > server... nah... lots of work there Setting your local server to be a slave of the remote server is not too hard and would be a MUCH better solution. The steps are fairly staightforward: 1. Add a slave user to t

RE: Select from remote server from stored procedure

2009-12-09 Thread Steven Staples
elect from remote server from stored procedure Hello Johan, On Dec 9, 2009, at 11:22 AM, Johan De Meersman wrote: > Posted this before, but beware: federated tables do NOT use indices. > Every > select is a full table scan, and if you're talking about a logging > table > that co

Re: Select from remote server from stored procedure

2009-12-09 Thread Harrison Fisk
true. If you define an index on the local federated table, and it makes sense to use it, then a remote WHERE clause will be passed through and hence use the remote index. Not all types of index accesses can be passed through such as this, however for a single row lookup on a primary key, it s

Re: Select from remote server from stored procedure

2009-12-09 Thread Johan De Meersman
Posted this before, but beware: federated tables do NOT use indices. Every select is a full table scan, and if you're talking about a logging table that could become very expensive very fast. On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal wrote: > > Is this possible to do? To make a connection, i

RE: Select from remote server from stored procedure

2009-12-09 Thread Neil Aggarwal
> Is this possible to do? To make a connection, inside the > stored procedure > to a completely different machine and access the mysql there? The only way I know to access tables from different servers from a single connection is federated tables: http://dev.mysql.com/doc/refman/5.0/en/federated

Select from remote server from stored procedure

2009-12-09 Thread Steven Staples
Ok, I feel silly for asking this, but I am going to do it anyway. I have a huge stored procedure that does quite a bit of logic, and gathering/splitting of data. I currently have our customer database on one server, and our logging on another. What i need to do, is to pull the customer id from

Re: Slot connection on a remote MySQL server - not name resolve problem!

2009-10-08 Thread Kim Delevati
Damn I just said I wrote slot instead of slow... Well I solved the problem, we added the client ip on the etc/hosts file on the server. Now its pretty fast. 2009/10/8 Kim Delevati > Hi. > > I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server > but switched my database to an

Slot connection on a remote MySQL server - not name resolve problem!

2009-10-08 Thread Kim Delevati
Hi. I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server but switched my database to another machine, on a Windows Server 2008. Problem is, the connection to that other server (which is on the same network) is very slow, taking 4-6 seconds every time. That is impossible to use

RES: [SPAM] RE: Remote connection

2009-08-05 Thread Hugo Leonardo Ferrer Rebello
It´s working. The problem was related to grant permission. Thank you. Cheers, Hugo -Mensagem original- De: Gavin Towey [mailto:gto...@ffn.com] Enviada em: terça-feira, 4 de agosto de 2009 19:46 Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com Assunto: [SPAM] RE: Remote

RE: Remote connection

2009-08-04 Thread Gavin Towey
systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't w

Re: Remote connection

2009-08-04 Thread Carlos Proal
Are you sure that root has granted access to connect remotely ?? Carlos On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote: Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf fi

RE: Remote connection

2009-08-04 Thread Pablo A. Otero
May not have root access to remotely! Try to reconfigure the parameters of the engine. although it is not good idea to allow remote access to the root user!. Greetings, Pablo -Mensaje original- De: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Enviado el: Martes

Remote connection

2009-08-04 Thread Hugo Leonardo Ferrer Rebello
Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the s

Re: how to get the timestamp from remote mysql

2009-07-04 Thread Michael Dykman
but it will work - michael dykman On Sat, Jul 4, 2009 at 2:48 AM, Nathan Huang wrote: > Hi guys > I am going to fetch out the data from remote mysql database according to > timestamps colmmen, however my local date is different from the one on > remote mysql database, > how can I g

Re: how to get the timestamp from remote mysql

2009-07-04 Thread Marcus Bointon
On 4 Jul 2009, at 07:48, Nathan Huang wrote: I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone? that is to

R: how to get the timestamp from remote mysql

2009-07-04 Thread Claudio Nanni
ch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone? that is to say I set the date and send itto remote server or database to calculate

how to get the timestamp from remote mysql

2009-07-03 Thread Nathan Huang
Hi guys I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone? that is to say I set the date and send itto remote

Try to create a tunnel SSH to remote DB server, but with error Number 2013

2009-06-29 Thread Lin Chun
hi As the DB server is behind bastion host, each time I have to connect to this host and then connect the DB server In order to connect the server from my pc windows, I use PuTTY to create a tunnel SSH, mapping 'remotserver:port' to 'localhost:6001' thought the bastion host After the configurati

Re: how to fetch and calculate data from remote database and insert into local database

2009-06-26 Thread Shawn Green
Hello Nathan, Nathan Huang wrote: Hello I want to fetch and calculate the data from remote database(for example Japan) and insert them into my local database(for example usa), does mysql have such function to do it, or do I have to write a script using perl or other language to help

Re: how to fetch and calculate data from remote database and insert into local database

2009-06-25 Thread Lin Chun
Hi I think you mean that you want to get some results (by calculating the data in remote database) and then stock them in local database; so dosen't need to dump the db and transfer to local,but need to do some program to fetch the result and insert into the local database; In addition, like

Re: how to fetch and calculate data from remote database and insert into local database

2009-06-25 Thread bharani kumar
ort (mysql cmd) of data is done >> as >> below: >> >> Supposing "japan" is the source db and "usa" is your destination db, >> >> 1) Dump the database on source server: >> >> $ cd >> $ mysqldump -u -S -p japan > >>

Re: how to fetch and calculate data from remote database and insert into local database

2009-06-25 Thread John Daisley
japan" is the source db and "usa" is your destination db, > > 1) Dump the database on source server: > > $ cd > $ mysqldump -u -S -p japan > > ./source_japan.dbdmp > > 2) ssh to destination host > 3) Check if that folder is shared between remote and loca

Re: how to fetch and calculate data from remote database and insert into local database

2009-06-25 Thread Uma Bhat
rce_japan.dbdmp 2) ssh to destination host 3) Check if that folder is shared between remote and local host. else, Step4. 4) scp the dump file from souce host to destination host: $ @::> 5) Import the dumpfile to destination db: $ mysql -u -p -S usa < ./source_japan.dbdmp Regards, U

how to fetch and calculate data from remote database and insert into local database

2009-06-24 Thread Nathan Huang
Hello I want to fetch and calculate the data from remote database(for example Japan) and insert them into my local database(for example usa), does mysql have such function to do it, or do I have to write a script using perl or other language to help achieving it? thank you in advance nathan

Re: MySQL command line remote monitoring tool for 5.0

2009-04-16 Thread Moon's Father
Innotop can satisfy you demand. On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote: > Hello, > I'd like to know if there is a command line tool I can run to collect > vital health information for a remote mysql server (just like > mysqltop) for 5.0 - I often see mysql swapping

MySQL command line remote monitoring tool for 5.0

2009-04-16 Thread Hitesh Shah
Hello, I'd like to know if there is a command line tool I can run to collect vital health information for a remote mysql server (just like mysqltop) for 5.0 - I often see mysql swapping to disk and would like to know what causes that. Thanks Hitesh -- MySQL General Mailing List For

Re: Remote data

2009-03-18 Thread Ananda Kumar
you can do this also (source) (desti) mysqldump -uroot -p -habc.com --databases yyy --table tab1 | mysql -uroot -p -hzzz.com -Dxxx On 3/18/09, Krishna Chandra Prajapati wrote: > > Hi all, > > I am looking for a solution. > > While being on one db server how to get the data from other server

Remote data

2009-03-18 Thread Krishna Chandra Prajapati
Hi all, I am looking for a solution. While being on one db server how to get the data from other server. One method is federated. Is there any other way Thanks, Krishna Chandra Prajapati

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Sven
On 3/11/09, Thomas Spahni wrote: > > I am searching for a generic command to monitor that MySQL instance is > > up and running. I don't have any know-how about the schema of the DB. > What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards Sven -- M

Re: mysqlimport remote host problem

2009-03-11 Thread René Fournier
Thanks. That works great. On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote: On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote: OK, I've managed to do the same thing with just the mysql command line program: mysql -h 192.168.0.224 -u root -p alba2 < /Backup/Latest/alba2_2009-03-10_0

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Thomas Spahni
On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing

Re: mysqlimport remote host problem

2009-03-11 Thread Claudio Nanni
zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h 192.168.0.224 -u root -p alba2 Cheers Claudio 2009/3/11 Rob Wultsch > On Tue, Mar 10, 2009 at 7:16 PM, René Fournier > wrote: > > > OK, I've managed to do the same thing with just the mysql command line > > program: > > >

Re: mysqlimport remote host problem

2009-03-10 Thread Rob Wultsch
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote: > OK, I've managed to do the same thing with just the mysql command line > program: > >mysql -h 192.168.0.224 -u root -p alba2 < > /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql > > Works great. However, the sql file is normally gz

Re: mysqlimport remote host problem

2009-03-10 Thread wultsch
info if we had ill intents. Sent from my Verizon Wireless BlackBerry -Original Message- From: Darryle Steplight Date: Tue, 10 Mar 2009 22:20:26 To: René Fournier Cc: mysql Subject: Re: mysqlimport remote host problem Hi Rene, Just a head's up. You might want to keep your use

Re: mysqlimport remote host problem

2009-03-10 Thread Darryle Steplight
Hi Rene, Just a head's up. You might want to keep your username/password credentials private. On Tue, Mar 10, 2009 at 10:16 PM, René Fournier wrote: > OK, I've managed to do the same thing with just the mysql command line > program: > >        mysql -h 192.168.0.224 -u root -p alba2 < > /Bac

Re: mysqlimport remote host problem

2009-03-10 Thread René Fournier
OK, I've managed to do the same thing with just the mysql command line program: mysql -h 192.168.0.224 -u root -p alba2 < /Backup/Latest/ alba2_2009-03-10_00h45m.Tuesday.sql Works great. However, the sql file is normally gzipped, so Can I ungzip the file on the fly (and without removi

mysqlimport remote host problem

2009-03-10 Thread René Fournier
I'm writing script that, each night, copies a small database to my laptop on the local network. I'm having trouble getting it to work. Here's my syntax so far (run on the server): mysqlimport --host=192.168.0.224 --user=root --password alba2 alba2_2009-03-10_00h45m.Tuesday.sql Which produ

Re: generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread walter harms
you may like to try "mytop" or watch -n10 mysql -BNA -e "show full processlist" add user,host,databasename as needed Sven schrieb: > Hi folks > > I am searching for a generic command to monitor that MySQL instance is > up and running. I don't have any know-how about the schema of the DB. > >

generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread Sven
Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: Accessing remote machine (Ubuntu) from Window

2008-07-18 Thread Jesse
Do you have skip networkin in my.cnf ? No, no skip-networking is in the my.cnf file. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread chaim . rieger
Do you have skip networkin in my.cnf ? --Original Message-- From: Jesse To: Curtis Maurand Cc: MySQL List Sent: Jul 17, 2008 16:54 Subject: Re: Accessing remote machine (Ubuntu) from Window My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
L PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 5:41 PM Subject: RE: Accessing remote machine (Ubuntu) from Window I just checked my ubuntu config and I have: Port = 3306 Bind-address = 0.0.0.0 Pid-file = /var/run/mysqld/mysqld.pid Socket = /var/run/mysqld/mysqld.sock Nothig

RE: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Curtis Maurand
"Curtis Maurand" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: 7/17/2008 4:46 PM Subject: Re: Accessing remote machine (Ubuntu) from Window I was wondering how I get it to listed on all ports. When I try 0.0.0.0, and try to restart, the restart fails, and when it tries

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
and" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 4:31 PM Subject: Re: Accessing remote machine (Ubuntu) from Window I cannot. Are you trying to connect via the localhost. It may still be trying t

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Curtis Maurand
I cannot. Are you trying to connect via the localhost. It may still be trying to connect to localhost. You might try changing the bind-address statement to bind-address = 0.0.0.0 so that it also listens to localhost as well. Also if you're trying to connect to an ip address instead of

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
Obvious question: Did you restart MySQL? netstat -l should show you what's listening for connections. you'll want to see if its listening on port 3306. Yes. When that didn't work, I re-started the whole server. netstat -l tells me that 192.168.1.128:mysql is listening. It lists a foreign a

Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
I have a Ubuntu 8.04 Server VM set up that I'm using for replication for a WS2003 machine (which is the master).I have used a checksum utility that someone recommended to check if the tables are in sync, but I don't have a GUI installed on Ubuntu, so trying to interpret the selected columns that

how to stay connected to remote mysql server?

2008-07-02 Thread Can-Hua Chen
I am using syslog-ng to pipe syslog entries to a remote mysql server. I would like to stay connected to remote mysql server, always trying to reconnect if disconnected due to network problem. Is there some mysql-internal mechanism to do this? Or must I write a script to do so? If a script is

Re: Copying InnoDB files to remote server -> remote server won't start

2007-09-12 Thread Baron Schwartz
the folders that contain the .frm files either. Ownership and permissions are both identical? As best as I can tell - here's the remote machine list: drwxr-xr-x 11 mysql mysql 4096 Sep 11 18:29 . drwxr-xr-x 33 root root 4096 May 10 11:17 .. drwx-- 2 mysql mysql 4096 Sep

Re: Copying InnoDB files to remote server -> remote server won't start

2007-09-11 Thread Whil Hentzen
contain the .frm files either. Ownership and permissions are both identical? As best as I can tell - here's the remote machine list: drwxr-xr-x 11 mysql mysql 4096 Sep 11 18:29 . drwxr-xr-x 33 root root 4096 May 10 11:17 .. drwx-- 2 mysql mysql 4096 Sep 11 13:22 delme drwx-

Re: Copying InnoDB files to remote server -> remote server won't start

2007-09-11 Thread Baron Schwartz
Whil Hentzen wrote: Michael Dykman wrote: if you see no errors, check your config... are you sure InnoDB is enabled ? I can create a new database and add InnoDB tables to it without problems. Ack, I lied. No error in the /var/lib/mysql, but there IS an error file in /var/logs, and it contai

Re: Copying InnoDB files to remote server -> remote server won't start

2007-09-11 Thread Whil Hentzen
http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html Running a local box and a remote box, both with Fedora 6, MySQL 5. Trying to copy a local /var/lib/mysql/mydata InnoDB. The problem: After I copy InnoDB files to a remote box, the MySQL server on the remote box won't restart. Here ar

Copying InnoDB files to remote server -> remote server won't start

2007-09-11 Thread Whil Hentzen
Hi gang, After reading through two years of 'how do I back up my database' threads, I'm trying out the various backup mechanisms offered up. I've read through these steps: http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html Running a local box and a remote box

Re: Synchronizing a remote database with a local database

2007-03-20 Thread Dave M G
Janek, Thanks for responding. I was really hoping to not have to go to any third parties and start a whole new learning curve. Is what I'm after really not possible with MySQL? -- Dave M G Ubuntu 6.10 Edgy Eft Kernel 2.6.20-5-generic Pentium D Dual Core Processor PHP 5, MySQL 5, Apache 2 --

Re: Synchronizing a remote database with a local database

2007-03-16 Thread Janek Bogucki
On Fri, 2007-03-16 at 18:43 +0900, Dave M G wrote: > MySQL Users, > > I have a local website development environment where I have a "master" > MySQL database. > > I have several web sites which use the exact same database structure. > > The structure of the master database doesn't change very o

Synchronizing a remote database with a local database

2007-03-16 Thread Dave M G
MySQL Users, I have a local website development environment where I have a "master" MySQL database. I have several web sites which use the exact same database structure. The structure of the master database doesn't change very often, but it does sometimes. When that happens, I want to be abl

RE: Connecting from a remote computer

2007-01-18 Thread Jerry Schwartz
; From: Kay C. Tien [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 18, 2007 4:32 PM > To: Chris White > Cc: mysql@lists.mysql.com > Subject: Re: Connecting from a remote computer > > I got it working perfectly on a Linux server, but my boss wants this > on a Windows I

  1   2   3   4   5   6   7   >