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
- 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"
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?
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
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
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
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
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
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
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
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.
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
> 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
;> 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
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
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
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
- 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
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
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
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
>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
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
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]$
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
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
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
: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
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
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
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
,
>
> 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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 >
>>
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
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
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
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
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
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
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
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
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
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
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:
> >
>
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
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
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
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
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
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.
>
>
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/
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]
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
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
"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
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
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
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
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
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
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
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-
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
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
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
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
--
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
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
; 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 - 100 of 646 matches
Mail list logo