Hi!
> "Ed" == Ed L writes:
Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
Ed> replication. Here's my scenario...
Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
Ed> master-slave configuration to a new, beefier server running same mysql
if i u have LVM's then lock is held only for the duration of taking
snapshot, which would be few min, if there is very less activity on the db.
On Wed, Aug 28, 2013 at 3:08 PM, Ed L. wrote:
> On 8/28/13 2:00 PM, Ananda Kumar wrote:
>
>
> Why don't u try snapshot backups, where the lock held fo
On 8/28/13 2:00 PM, Ananda Kumar wrote:
Why don't u try snapshot backups, where the lock held for less
duration. Or can't u take mysql dumps during Night time when there is
less bd activity
I neglected to mention these systems are both CentOS linux systems.
Unfortunately, the 5.5 hour dumps
Why don't u try snapshot backups, where the lock held for less duration. Or
can't u take mysql dumps during Night time when there is less bd activity
On Thursday, August 29, 2013, Ed L. wrote:
>
> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my sce
Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my scenario...
We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
master-slave configuration to a new, beefier server running same mysql
5.0.45, and then cutover to the new server. Du
I think I've got most of the basics of MySQL under
control now, and I'd like to ask a question about
formatting table data. I've learned to insert html in
my tables. For example, the following cell includes
the code for proper apostrophes and quotation marks:
Land of the Midnight Sun, The Last
Fro
-Original Message-
From: Jeremy [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 12:49 PM
To: [EMAIL PROTECTED]
Subject: Newbie questions (3) - listeners / BLOB / PHP
Hi I'm from an Oracle background and wanted to ask a couple of questions:
1) Have installed mysql 4 on a
> 1) Have installed mysql 4 on a linux server. If I want to access this from
> another machine (i.e. run a MySQL-compliant client), is there a 'listener'
> of some sort that has to run on the server where the database is?
Nope, proper permissions is the only requirement. MySQL listens on port 33
No
Yes
www.php.net
Regards,
Mike Hillyer
> -Original Message-
> From: Jeremy [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: Newbie questions (3) - listeners / BLOB / PHP
>
>
> Hi I'm from an Oracle b
Hi I'm from an Oracle background and wanted to ask a couple of questions:
1) Have installed mysql 4 on a linux server. If I want to access this from
another machine (i.e. run a MySQL-compliant client), is there a 'listener'
of some sort that has to run on the server where the database is?
2) Can
Mark Sibly wrote:
>Hi,
>
>I'm new to this list, and have a few basic MySql questions:
>
>* Is it safe to convert a timestamp field to a datetime one? ie: will this
>'touch' each row and stuff up the ordering (hopefully not!).
>
What happend when you tried it on a test table?
>
>
>* I'm buildi
Hi,
I'm new to this list, and have a few basic MySql questions:
* Is it safe to convert a timestamp field to a datetime one? ie: will this
'touch' each row and stuff up the ordering (hopefully not!).
* I'm building a BBS application that needs to keep track of 'child counts'.
Currently, I'm usi
;
To: "'p.whiter'" <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 1:57 PM
Subject: SV: newbie - questions about timestamp(14)
: You seem to miss a comma:
:
: SELECT user_ip, IF(...
: ^^^
:
: > -Ursprungligt meddelande-
: > Från: p.white
be right?
Thanks again
Paul
- Original Message -
From: "Torgil Zechel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 11:54 AM
Subject: SV: newbie - questions about timestamp(14)
: You can use NOW() to get the current timestamp:
:
: mysq
You can use NOW() to get the current timestamp:
mysql> select NOW();
+-+
| NOW() |
+-+
| 2001-10-18 12:49:29 |
+-+
But it would be easier to let MySQL calculate the elapsed time:
select
IF(TIME_TO_SEC(NOW()) - TIME_TO_SE
Hi all
I'm having a problem getting a query to work where I want to compare the
current_timestamp to the logged timestamp, and return false if less than 300
seconds, can you tell me if it is possible to have the current timestamp
returned as part of a query, so as I can then do my calculations in
Thank you guys. I guess there is a big backlog, plus it seems a pretty
active list. Maybe I'd better just stick with the archives. As I
become more familiar with MySQL I'll probably have more specific
questions, and can search the archives a little more productively.
Thank you.
Mike Kimball
> I know I'm getting away ahead of myself here, but is there a GUI
> application development tool for mySQL? Something like Paradox or
> Access, that lets you create complete applications with attractive
> screens/forms and even start-up/splash screens. This would be on an NT
> workstation.
Any
> And is there some way to download the previous posts to this list? I
> found one list admin function that will download up to 100 posts
> concatenated into one email, but I'd like to be able to d/l them
> individually, with their own subject line and threading info. I just
> think it would be
I know I'm getting away ahead of myself here, but is there a GUI
application development tool for mySQL? Something like Paradox or
Access, that lets you create complete applications with attractive
screens/forms and even start-up/splash screens. This would be on an NT
workstation.
And is there
Date |Sat, 14 Jul 2001 20:38:23 -0500
>From |Hank Marquardt <[EMAIL PROTECTED]>
Hello!
HM> Try RLIKE or REGEXP --
HM> http://www.mysql.com/docs/S/t/String_comparison_functions.html
Little typo.
right url : http://www.mysql.com/docs/S/t/String_comparison_functions.html
___
At 6:39 PM -0700 7/14/01, Bob Rea wrote:
>OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
>general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
>Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have
>the MySQL Manual.
>
>The 10 minute book's syntax somet
Try RLIKE or REGEXP --
http://www.mysql.com/docs/S/t/String_comparison_functions.html
On Sat, Jul 14, 2001 at 06:39:00PM -0700, Bob Rea wrote:
> OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
> general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
> Forta. I als
OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have
the MySQL Manual.
The 10 minute book's syntax sometimes doesn't fit MySQL's, so I try
to find
Does anyone know exactly where to put the mysql.server file? is it in /etc? When I
run it I get these
./mysql.server: @HOSTNAME@: command not found
./mysql.server: my_print_defaults: command not found
Which leads me to believe I'm doing somthing wrong.
m on 02/10/2001
01:06:43 PM
To: "Aaron Sinclair" <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED] (bcc: Lad Gaal/MarconiMedical)
Subject: Re: Newbie Questions
You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a
chown mysql.mysql and then did a chmod
g password: YES)'
I'm open for suggestions TX
"Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 08:20:16 PM
To: Lad Gaal/MarconiMedical@Marconi
cc:
Subject: Re: Newbie Questions
check that /var/lib/mysql/mysql/* are owned by mysql and have read write
premiss
Just got mysql running (Ithink) on Redhat Linux 7. The version is
mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386
TCX Datakonsult AB, by Monty
Server version 3.23.22-beta-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket
28 matches
Mail list logo
