Hi!
Ed == Ed L mysql@bluepolka.net 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
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.
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. mysql@bluepolka.net wrote:
Mysql newbie here, looking for some help configuring 5.0.45 master-slave
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
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. mysql@bluepolka.net wrote:
On 8/28/13 2:00 PM, Ananda Kumar wrote:
Why don't u try snapshot backups,
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:
emLand of the Midnight Sun/em, emThe
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
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 background and wanted to ask a couple
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 3306
-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 linux
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 building a BBS
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
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
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()) -
- 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:
:
: mysql select NOW();
: +-+
: | NOW
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.whiter [mailto:[EMAIL PROTECTED]]
: Skickat: den 18 oktober 2001 14
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.
Any
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.
And is there
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
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 also
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 sometimes
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
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.
"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
premissions.
I am hanging out at www.mercylink.com/chat/chat.php c
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 775 on the direc
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
28 matches
Mail list logo