re: replication newbie questions

[Michael Widenius]

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 
Ed> 5.0.45, and then cutover to the new server.  Due to extreme SAN 
Ed> congestion and a grossly overloaded master server, our DB dumps take 5.5 
Ed> hours.  But we cannot afford that much downtime or locking during the 
Ed> replication transition; we can manage 10-15 minutes, but more is very 
Ed> problematic.

Ed> I understand that "FLUSH TABLES WITH READ LOCK" will lock the tables for 
Ed> the duration of the 5.5 hour dump.  Is this true?

Yes.

Ed> If so, we'd like to dump/initialize/sync slave WITHOUT any locking 
Ed> anything the master for more than a few seconds if at all possible.  
Ed> Will this give us the dump we need?

Ed>  mysqldump --single-transaction --master-data --all-databases

You can do a dump without locking by using the xtrabackup tool.
This however assumes you are using InnoDB as the storage engine.

The other option is to use file system snapshots, if your file system
supports that.  In this case you only have to do the FLUSH TABLES
... for the duration of the snapshot.

Regards,
Monty

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: replication newbie questions

[Ananda Kumar]

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 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 are already done during the least busy
> times.
>
> Regarding snapshots, how long are snapshot locks held?  These are ext4
> filesystems.  Assuming the lock is not held for long, what's the
> recommended way to do snapshots on ext4?
>
> Thanks,
> Ed
>
>
>
> 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 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.  Due to extreme SAN congestion
> and a grossly overloaded master server, our DB dumps take 5.5 hours.  But
> we cannot afford that much downtime or locking during the replication
> transition; we can manage 10-15 minutes, but more is very problematic.
> >
> > I understand that "FLUSH TABLES WITH READ LOCK" will lock the tables for
> the duration of the 5.5 hour dump.  Is this true?
> >
> > If so, we'd like to dump/initialize/sync slave WITHOUT any locking
> anything the master for more than a few seconds if at all possible.  Will
> this give us the dump we need?
> >
> > mysqldump --single-transaction --master-data --all-databases
> >
> > Thank you in advance for any help.
> >
> > Ed
> >
>
>
>

Re: replication newbie questions

[Ed L.]

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 are already done during the least busy 
times.


Regarding snapshots, how long are snapshot locks held?  These are ext4 
filesystems.  Assuming the lock is not held for long, what's the 
recommended way to do snapshots on ext4?


Thanks,
Ed



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 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.  Due to extreme SAN 
congestion and a grossly overloaded master server, our DB dumps take 
5.5 hours.  But we cannot afford that much downtime or locking during 
the replication transition; we can manage 10-15 minutes, but more is 
very problematic.

>
> I understand that "FLUSH TABLES WITH READ LOCK" will lock the tables 
for the duration of the 5.5 hour dump.  Is this true?

>
> If so, we'd like to dump/initialize/sync slave WITHOUT any locking 
anything the master for more than a few seconds if at all possible. 
 Will this give us the dump we need?

>
> mysqldump --single-transaction --master-data --all-databases
>
> Thank you in advance for any help.
>
> Ed
> 

Re: replication newbie questions

[Ananda Kumar]

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 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.  Due to extreme SAN congestion
and a grossly overloaded master server, our DB dumps take 5.5 hours.  But
we cannot afford that much downtime or locking during the replication
transition; we can manage 10-15 minutes, but more is very problematic.
>
> I understand that "FLUSH TABLES WITH READ LOCK" will lock the tables for
the duration of the 5.5 hour dump.  Is this true?
>
> If so, we'd like to dump/initialize/sync slave WITHOUT any locking
anything the master for more than a few seconds if at all possible.  Will
this give us the dump we need?
>
> mysqldump --single-transaction --master-data --all-databases
>
> Thank you in advance for any help.
>
> Ed
>

replication newbie questions

[Ed L.]

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.  Due to extreme SAN 
congestion and a grossly overloaded master server, our DB dumps take 5.5 
hours.  But we cannot afford that much downtime or locking during the 
replication transition; we can manage 10-15 minutes, but more is very 
problematic.


I understand that "FLUSH TABLES WITH READ LOCK" will lock the tables for 
the duration of the 5.5 hour dump.  Is this true?


If so, we'd like to dump/initialize/sync slave WITHOUT any locking 
anything the master for more than a few seconds if at all possible.  
Will this give us the dump we need?


mysqldump --single-transaction --master-data --all-databases

Thank you in advance for any help.

Ed

Data Formatting - Newbie Questions

[David Blomstrom]

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
Frontier, and The Great Land  have
replaced Seward’s Folly and Seward’s
Ice Box

But my question regards differentiating between
narrative descriptions and pure data. The example
above is what I might call a narrative account. If I
wanted to focus on just state nicknames alone, I might
make table cells, each with its own entry:

1. Land of the Midnight Sun
2. The Last Frontier
3. The Great Land
4. Seward's Folly
5. Seward's Ice Box

But that gets confusing, too, because some states have
just one nickname and would therefore require a single
column, versus five fields for Alaska.

So, suppose I want to have my data available in two
formats - the "narrative form" I offered in the first
example, and pure data that I can sort alphabetically
and manipulate in other ways. What's the best strategy
for doing this?

Should I make two fields - one for the narrative, and
another with values separated by commas...

The Great Land, Land of the Midnight Sun, Seward's
Folly

Or is there a way to dump all your data into one cell,
then choose between displaying everything in that cell
and just displaying (and manipulating) isolated bits
of data?

Thanks.




__
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie questions (3) - listeners / BLOB / PHP

[Subhakar Burri]

-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 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?

MySQL uses port/socket to listen uniquely. No listener as such available. To access 
another machine you pass the arguments -p (for port) / -S (for socket) instead of @ to 
connect to an instance.

2) Can anyone tell me if MySQL allows the storage of BLOB data?

Yes.

3) What is a good resource for learning about PHP & MySQL 'together'?

php.net & mysql.com

Thanks for any and all pointers - happy to help myself if you can direct me
to where i will find the info.

cheers
Jeremy


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: Fri 04/07/2003

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie questions (3) - listeners / BLOB / PHP

[Greg Donald]

> 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 
by default.

> 2) Can anyone tell me if MySQL allows the storage of BLOB data?

Yes.

> 3) What is a good resource for learning about PHP & MySQL 'together'?

I learned both of them from the online manuals and a little help from the 
available mailing lists.  Both have excellent searchable online manuals.


-- 
Greg Donald
http://destiney.com/



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie questions (3) - listeners / BLOB / PHP

[Mike Hillyer]

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 
> 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 anyone tell me if MySQL allows the storage of BLOB data?
> 
> 3) What is a good resource for learning about PHP & MySQL 'together'?
> 
> Thanks for any and all pointers - happy to help myself if you 
> can direct me
> to where i will find the info.
> 
> cheers
> Jeremy
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.497 / Virus Database: 296 - Release Date: Fri 04/07/2003
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie questions (3) - listeners / BLOB / PHP

[Jeremy]

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 anyone tell me if MySQL allows the storage of BLOB data?

3) What is a good resource for learning about PHP & MySQL 'together'?

Thanks for any and all pointers - happy to help myself if you can direct me
to where i will find the info.

cheers
Jeremy


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: Fri 04/07/2003

Re: newbie questions...

[Gerald Clark]

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 application that needs to keep track of 'child counts'.
>Currently, I'm using integer 'count' fields for this and manually updating
>'parent' counts where necessary. Would it be better to just use 'count(*)'
>instead where possible? Would this be slower? If I index the fields to be
>counted, would this end up wasting/saving disk-space?
>
>Finally...MySql is GREAT! I have a complete BBS application up and running,
>coded 'from scratch' with no prior SQL knowledge based just on the MySql
>package and docs. Of course, its now in dire need of cleaning up!
>
>Sincerely,
>Mark Sibly,
>Blitz Research Ltd
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

newbie questions...

[Mark Sibly]

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 using integer 'count' fields for this and manually updating
'parent' counts where necessary. Would it be better to just use 'count(*)'
instead where possible? Would this be slower? If I index the fields to be
counted, would this end up wasting/saving disk-space?

Finally...MySql is GREAT! I have a complete BBS application up and running,
coded 'from scratch' with no prior SQL knowledge based just on the MySql
package and docs. Of course, its now in dire need of cleaning up!

Sincerely,
Mark Sibly,
Blitz Research Ltd


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: newbie - questions about timestamp(14)

[p.whiter]

Thanks, the query is now working, butit is not producing the required
results. I have now tried many different methods, it does not seem to me to
be possible to compare these times!!

Thanks anyway
Paul

- Original Message -
From: "Torgil Zechel" <[EMAIL PROTECTED]>
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.whiter [mailto:[EMAIL PROTECTED]]
: > Skickat: den 18 oktober 2001 14:47
: > Till: MySQL List
: > Ämne: Re: newbie - questions about timestamp(14)
: >
: > Thanks for your reply, I have tried using the query as you suggest,
: see
: > below:
: >
: > SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) < 300,
: > 'true',
: > 'false') FROM clinic_log
: >
: > But this just gives me an error, ie the query won't run?
: >
: > Does the query seem to 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:
: > :
: > : 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_SEC(logged_ts) > 300, 'true',
: 'false')
: > : from ;
: > :
: > : where logged_ts is your logged timestamp and  is the name of
: your
: > : table..
: > :
: > : /torgil
: > :
: > : > 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 my
: > : > script.
: > : > Thanks
: > : > Paul



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: newbie - questions about timestamp(14)

[p.whiter]

Thanks for your reply, I have tried using the query as you suggest, see
below:

SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) < 300, 'true',
'false') FROM clinic_log

But this just gives me an error, ie the query won't run?

Does the query seem to 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:
:
: 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_SEC(logged_ts) > 300, 'true', 'false')
: from ;
:
: where logged_ts is your logged timestamp and  is the name of your
: table..
:
: /torgil
:
: > 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 my
: > script.
: > Thanks
: > Paul



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SV: newbie - questions about timestamp(14)

[Torgil Zechel]

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_SEC(logged_ts) > 300, 'true', 'false') 
from ;

where logged_ts is your logged timestamp and  is the name of your
table.. 

/torgil

> 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 my
> script.
> Thanks
> Paul
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail  [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

newbie - questions about timestamp(14)

[p.whiter]

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 my
script.
Thanks
Paul


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie questions

[Michael Kimball]

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

Chris Bolt wrote:
> 
> > 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 easier to review and catch up.
> 
> http://marc.theaimsgroup.com/?l=mysql&r=1&w=2
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Newbie questions

[Carsten H. Pedersen]

> 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 application tool that supports ODBC (and I assume that
goes for pretty much anything running on NT) will be able
to connect to the server using MyODBC.

> 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 easier to review and catch up.

Why not use one of the online archives?

http://www.geocrawler.com/lists/3/Databases/8/0/

http://marc.theaimsgroup.com/?l=mysql&r=1&w=2

http://lists.mysql.com/

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Newbie questions

[Chris Bolt]

> 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 easier to review and catch up.

http://marc.theaimsgroup.com/?l=mysql&r=1&w=2

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie questions

[Michael 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 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 easier to review and catch up.

Thank you,

Mike Kimball
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie Questions

[Grigory Bakunov]

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

_
For technical support contracts, visit https://order.mysql.com/
** This email is sponsored by SWSoft, http://www.asplinux.ru/ **
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/   Glazov, Russia
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie Questions

[Paul DuBois]

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 doesn't fit MySQL's, so I try
>to find the MySQL way by trial and error, or ny the O'Reilly book.
>Some times this works and sometines I fail. For instance, the 10 min
>book has a query:
>
>SELECT cust_contact
>FROM Customers
>WHERE cust_contact LIKE '[JM]%'
>ORDER BY cust_contact;
>
>The reply is:
>Empty set (0.02 sec)
>
>So I need to know the correct syntax for this query, such that it
>returns only cust_contacts which begin with J or M.
>
>I have searched the Manual and so on.
>
>Point me in the right direction or something.

This is what you want:

WHERE cust_contact REGEXP '^[JM]'

>
>--
>Bob Rea
>
>   Fear of Hell is pernicious;
> So is fear of Heaven.
>
>[EMAIL PROTECTED]   http://www.sirius.com/~rear



-- 
Paul DuBois, [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie Questions

[Hank Marquardt]

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 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 the MySQL way by trial and error, or ny the O'Reilly book. 
> Some times this works and sometines I fail. For instance, the 10 min 
> book has a query:
> 
> SELECT cust_contact
> FROM Customers
> WHERE cust_contact LIKE '[JM]%'
> ORDER BY cust_contact;
> 
> The reply is:
> Empty set (0.02 sec) 
> 
> So I need to know the correct syntax for this query, such that it 
> returns only cust_contacts which begin with J or M.
> 
> I have searched the Manual and so on.
> 
> Point me in the right direction or something.
> 
> -- 
> Bob Rea
> 
>   Fear of Hell is pernicious;
> So is fear of Heaven.
> 
> [EMAIL PROTECTED]   http://www.sirius.com/~rear
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Hank Marquardt <[EMAIL PROTECTED]>
http://web.yerpso.net

Web & Database Development in PHP, MySQL/PostgreSQL
Small Office Networking Solutions - Debian GNU/Linux & FreeBSD
PHP Instructor - HTML Writers Guild 
*** PHP II "The Cool Stuff" starts July 16, 2001
*** http://www.hwg.org/services/classes/p181.1.html


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie Questions

[Bob Rea]

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 the MySQL way by trial and error, or ny the O'Reilly book. 
Some times this works and sometines I fail. For instance, the 10 min 
book has a query:

SELECT cust_contact
FROM Customers
WHERE cust_contact LIKE '[JM]%'
ORDER BY cust_contact;

The reply is:
Empty set (0.02 sec) 

So I need to know the correct syntax for this query, such that it 
returns only cust_contacts which begin with J or M.

I have searched the Manual and so on.

Point me in the right direction or something.

-- 
Bob Rea

Fear of Hell is pernicious;
So is fear of Heaven.

[EMAIL PROTECTED]   http://www.sirius.com/~rear

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL newbie questions.

[Sean Strycker]

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.

Re: Newbie Questions and a resolution

[Lad . Gaal]

Well, I finally got that portion working. After I putzed around for awhile, I
said to myself - Self, With all this putzing, I probably need to restart the
mysqld server. So I tried that from linuxconf and for some reason it just didn't
want to restart! So, I went and did a /etc/rc5.d/S85mysqld stop and then a
/etc/rc5.d/S85mysqld start. Low and behold, I could now change the password from
a blank to meg123.

So now my next question is how do I add users? Do I do that from the mysql
database??

Tx for your help




"mysql-return-64843-gaal=ct.marconimed.com"@lists.mysql.com 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 775 on the directory.
So I still get basically the same thing.
I enter: mysqladmin -u root -p password meg123
Enter password:(I leave it blank and CR)
mysqladmin: unable to change password; error: 'Table 'user' is read only'

But if I enter:
mysqladmin -u root -p password meg123 (cr)
Enter password: meg123 (CR)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using 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
premissions.

I am hanging out at www.mercylink.com/chat/chat.php chat server for a while
if you want to talk about it.

Aaron Sinclair



- Original Message -
From: <[EMAIL PROTECTED]>
To: "Aaron Sinclair" <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 2:05 PM
Subject: Re: Newbie Questions


>
>
> I just tried mysqladmin -u root password meg123
> the return was: mysqladmin: unable to change password; error: 'Table
'user' is
> read only'
>
> I then tried running the mysql_install_db again and then typed
> mysqladmin -u root -p password meg123
> the response was t enter the password which I left blank and hit return
> and got: mysqladmin: unable to change password; error: 'Table 'user' is
read
> only'
>
> I installed MYSQL during the redhat 7 install. Do I need a .cnf file
someplace
> like in /etc. I think I saw a mf.cnf file that I need to copy from
> /usr/share/mysql/my-medium.cnf. I feel like it's something simple, but I
just
> can't grasp it. Things were so much easier with postgresql.
> This is what I get for trying to advance!!!
> Tx...
>
>
>
>
> "Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 06:22:26 PM
>
> To:   Lad Gaal/MarconiMedical@Marconi
> cc:
>
> Subject:  Re: Newbie Questions
>
>
>
> after running the mysql_install scripts..
>
> mysqladmin -uroot password password
>
> mysql requires you to specify what user you are  ie
>  mysql -u -p
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, February 10, 2001 11:22 AM
> Subject: Newbie Questions
>
>
> >
> >
> > 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 /var/lib/mysql/mysql.sock
> >
> > So how do I change/add passwords for the users and how do I add users?
> > I tried 'mysqladmin password newpassword' (where newpassword is my
> password)
> > The response I get is: 'mysqladmin: unable to change password; error:
'You
> are
> > using MySQL as an anonym' '
> > So then I switch to superuser and try again.
> > The response I get is: 'mysqladmin: unable to change password; error:
> 'Table
> > 'user' is read only' '
> > I try : 'mysqladmin -password newpassword'
> > The response is: 'mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> >
> > So how the heck do I do this??
> >
> > Thanks
> >
> > 
> > Lad. Gaal
> >
> >
> >
> >
> >
> > -
> > Before po

Re: Newbie Questions

[Lad . Gaal]

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 directory.
So I still get basically the same thing.
I enter: mysqladmin -u root -p password meg123
Enter password:(I leave it blank and CR)
mysqladmin: unable to change password; error: 'Table 'user' is read only'

But if I enter:
mysqladmin -u root -p password meg123 (cr)
Enter password: meg123 (CR)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using 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
premissions.

I am hanging out at www.mercylink.com/chat/chat.php chat server for a while
if you want to talk about it.

Aaron Sinclair



- Original Message -
From: <[EMAIL PROTECTED]>
To: "Aaron Sinclair" <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 2:05 PM
Subject: Re: Newbie Questions


>
>
> I just tried mysqladmin -u root password meg123
> the return was: mysqladmin: unable to change password; error: 'Table
'user' is
> read only'
>
> I then tried running the mysql_install_db again and then typed
> mysqladmin -u root -p password meg123
> the response was t enter the password which I left blank and hit return
> and got: mysqladmin: unable to change password; error: 'Table 'user' is
read
> only'
>
> I installed MYSQL during the redhat 7 install. Do I need a .cnf file
someplace
> like in /etc. I think I saw a mf.cnf file that I need to copy from
> /usr/share/mysql/my-medium.cnf. I feel like it's something simple, but I
just
> can't grasp it. Things were so much easier with postgresql.
> This is what I get for trying to advance!!!
> Tx...
>
>
>
>
> "Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 06:22:26 PM
>
> To:   Lad Gaal/MarconiMedical@Marconi
> cc:
>
> Subject:  Re: Newbie Questions
>
>
>
> after running the mysql_install scripts..
>
> mysqladmin -uroot password password
>
> mysql requires you to specify what user you are  ie
>  mysql -u -p
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, February 10, 2001 11:22 AM
> Subject: Newbie Questions
>
>
> >
> >
> > 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 /var/lib/mysql/mysql.sock
> >
> > So how do I change/add passwords for the users and how do I add users?
> > I tried 'mysqladmin password newpassword' (where newpassword is my
> password)
> > The response I get is: 'mysqladmin: unable to change password; error:
'You
> are
> > using MySQL as an anonym' '
> > So then I switch to superuser and try again.
> > The response I get is: 'mysqladmin: unable to change password; error:
> 'Table
> > 'user' is read only' '
> > I try : 'mysqladmin -password newpassword'
> > The response is: 'mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> >
> > So how the heck do I do this??
> >
> > Thanks
> >
> > 
> > Lad. Gaal
> >
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
>
>






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie Questions

[Lad . Gaal]

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 /var/lib/mysql/mysql.sock

So how do I change/add passwords for the users and how do I add users?
I tried 'mysqladmin password newpassword' (where newpassword is my password)
The response I get is: 'mysqladmin: unable to change password; error: 'You are
using MySQL as an anonym' '
So then I switch to superuser and try again.
The response I get is: 'mysqladmin: unable to change password; error: 'Table
'user' is read only' '
I try : 'mysqladmin -password newpassword'
The response is: 'mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

So how the heck do I do this??

Thanks


Lad. Gaal





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php