Re: Design advice for hotel availability program

[Chaim Rieger]

On 2/17/2012 4:01 AM, Tompkins Neil wrote:

Hi,

I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates.  My question is does anyone
have any experience with regards the best way to store the daily rates.  Am
I best using the following pattern

(1) Default rates/rooms stored in a generic table
(2) Any exceptions/changes/closed days to the daily rates are store in
a separate table.
(3) Any special offer exceptions are stored as a rule

All, should I consider that for any hotel, for any room, for any day I have
a record in a huge single table ???

Thanks for any help and input.

There is already more than one package out there that does what you are 
trying to do, so why not take a look at how they do the db stuff.


also keep in mind that you are working two reservations at once for each 
entry


a guest requests an asett (the room)
a guest then promises to pay a certain amount for an asset
an asset can be tied to  a variety or prices, but only one at a time, 
unless certain conditions are met.

so no its not easy to do, but it has been done.
http://drupal.org/project/uc_hotel

(ps. no i do not do drupal)



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

Re: Matrix Stats Login

[chaim rieger]

Oops
--Original Message--
From: Tompkins Neil
To: [MySQL]
Subject: Matrix Stats Login
Sent: Sep 24, 2010 09:41

User  fifaleagues
Pass DrUch929eHek9Huwa7HAcH6wRUk5QaTr




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: strange authentication issue

[chaim rieger]

Another thing I just noticed

In your first example you are using localhost, which probably means you are 
connecting via network

The second option you don't define a host, which means you're prolly using 
socket connection



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: strange authentication issue

[chaim rieger]

Just a stab but what's the max connect set to ?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Join

[Chaim Rieger]

Oops
--Original Message--
From: Mark Farnsworth
To: mysql@lists.mysql.com
Subject: Join
Sent: Jun 28, 2009 15:40

Join

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=chaim.rie...@gmail.com



Sent via BlackBerry from T-Mobile

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Best way to convert character set from "latin1 to utf8" for existing database?

[Chaim Rieger]

Export schema
Export data
Change exported schema to utf8
Import schema into new db
Import exported data into new db


Sent via BlackBerry from T-Mobile

-Original Message-
From: Darryle Steplight 

Date: Sun, 7 Jun 2009 22:52:22 
To: Uma Bhat
Cc: ewen fortune; 
Subject: Re: Best way to convert character set from "latin1 to utf8" for 
existing database?


Uma,
   I apologize in advance if this is redundant ,because I did not
click on any of Ewen's link. Nonetheless, this is the approach I would
take.

start your mysql server with different --character-set-server and
---collation-server options

Type SHOW COLLATION; in your mysql shell to determine which collations
are available for each character set


If you want to change the character set while running MySql, that may
also change the sort order. you must run myisamchk -r -q
-set-collation=collation_name on all MyISAM tables or your indexes may
not be ordered correctly

There are numerous collations for the uft8 charset so I'm assuming
mysql is selecting a collation that you don't want to use.
Additionally, if you did not run myisamchk on any of your MyISAM
tables that may be why you are getting unexpected results. I hope this
helps.



On Sun, Jun 7, 2009 at 10:29 PM, Uma Bhat wrote:
> Thank was great piece of info Ewen, Thanks!
>
> However this approach works for new data. But the existing data in the
> database does not show us the Japanese characters from application side.
>
> Appreciate responses who 'actually' got to work on this conversion.
>
> Thanks!
> Uma
>
>
> On 6/1/09, ewen fortune  wrote:
>>
>> Uma,
>>
>> On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat  wrote:
>> > Hi All,
>> >
>> > I have read many blogs suggesting some examples for this.
>> > But suggestions from you guys who have ACTUALLY worked on such a scenario
>> > would help me out the best.
>> >
>> >
>> > Current Database has:
>> > DEFAULT CHARACTER SET - latin1
>> > DEFAULT COLLATION : latin1_swedish_ci
>> >
>> > We need to convert this to
>> >  DEFAULT CHARACTER SET - utf8
>> > DEFAULT COLLATION : utf8_general_ci
>> >
>> >
>> > Note that this has to be done on a database that has *existing data* in
>> it .
>> >
>> > Hence just by doing a:
>> >
>> > ALTER DATABASE  CHARSET=utf8;
>> >
>> > would result in unexpected behaviour of the data.
>>
>> Ryan Lowe blogged about this.
>>
>> http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/
>>
>> He wrote a tool for it (linked from post)
>>
>> http://www.pablowe.net/convert_charset
>>
>> And Schlomi Noach commented that openark also has a tool.
>>
>> http://code.openark.org/forge/openark-kit
>>
>> Cheers,
>>
>> Ewen
>>
>> >
>>
>> > Thanks!
>> > Uma
>> >
>>
>



-- 
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=chaim.rie...@gmail.com

Re: A good US Hosting Site?

[Chaim Rieger]

Dreamhost is decent


Sent via BlackBerry from T-Mobile

-Original Message-
From: Cameron Rogers 

Date: Sun, 19 Apr 2009 20:42:27 
To: 
Subject: A good US Hosting Site?


Hi everyone.  I am starting my first web site.  I have a temporary contract
with godaddy but know there are better options out there.   The only problem
is, I don't know reliable sources to research which hosting program to use.
Any recommendations on a hosting sight or some good resources to find a
hosting site.  I need a hosting site that allows me to:
1.  Use PHP/MYSQL
2.  Send 1000 + emails a day   <-- the mail function has been my greatest
limitation with godaddy


Thanks in advance, Cameron



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Log and Data directories

[Chaim Rieger]

Michael Dykman wrote:

On Wed, Mar 4, 2009 at 1:22 PM,   wrote:

On a high read/write load.. is it good to split log (binlogs, innodb txn logs) 
and data (all tables, innodb tablespace) in different partitions ?

Anybody had any experience ?

For example; out of 25 disks array with 142GB 1rpm... I would like to keep 
few disks to logs and rest to data .. is it advised or better to keep 
everything in spool so that all spindles can be efficiently managed...

Thanks in advance



You most certainly can get enhanced performance by putting your bin
log and transaction logs onto  separate spindles..  Separate
partitions on the same physical device will be of little-to-no-value.
For systems like Oracle or DB2, this is part of the standard
installation drill.  ON MySQL, I do not do this routinely, but I do
when I am expecting high, sustained loads,




what kind of storage are you using ?
we do this on netapp.

--
--
Chaim Rieger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: moving data to MySQL

[chaim . rieger]

There are products out there that convert from ms sql to MySql. 
Though I would test them before trusting them


--Original Message--
From: Chris Rehm
To: mysql@lists.mysql.com
Subject: moving data to MySQL
Sent: Feb 21, 2009 10:47

I want to write some programs to work with data from eveonline.com but my 
installed database is MySQL and the data format they provide is a backup of 
MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded 
that and am willing to install it, I just want to know if there is a 
programmatic way of transferring the data to MySQL. Any help or insight 
would be appreciated, I have been away from coding for several years because 
of health issues and I'm trying to knock the rust off my brain and get going 
again.

Chris Rehm
ch...@javadisciple.com 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=chaim.rie...@gmail.com



Sent via BlackBerry from T-Mobile

Re: Resend: enabling storage engine with RPM install

[chaim . rieger]

The answer is no


Sent via BlackBerry from T-Mobile

-Original Message-
From: Jim Lyons 

Date: Thu, 19 Feb 2009 23:50:13 
To: 
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install


What configuration parameter in the config file could have an impact on
whether a particular storage engine is supported?  The binaries are built
before the config is even used.  I don't mind posting the file, but I don't
see the point.

The question is pretty simple, can one add a storage engine to an RPM
install?  The config file follows.  Thanks.

[client]
socket  = /db/data/mysql.sock
port= 3306
[mysqld]
socket  = /db/data/mysql.sock
datadir = /db/data
tmpdir  = /db/tmp
port= 3306
user= mysql
max_allowed_packet = 1024M
lower_case_table_names=0
log-bin=/db/binlog/tlsgriffin01-bin
sync_binlog = 1
expire_logs_days = 14
log-error=/db/log/tlsgriffin01-err.log
log-slow-queries=/db/log/tlsgriffin01-slow.log
long_query_time = 1
log_warnings=2
server-id = 101
skip-slave-start
sysdate-is-now
log_bin_trust_function_creators=1
skip-external-locking
key_buffer_size = 128M
query_cache_size = 256M
table_cache = 4096
thread_concurrency = 14
thread_cache_size = 0
open_files_limit = 10240
max_connections = 1000
skip-bdb
read_buffer_size = 64M
read_rnd_buffer_size = 64M
sort_buffer_size = 64M
tmp_table_size = 512M
max_heap_table_size = 250M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 20G
innodb_data_home_dir = /db/innodb
innodb_log_group_home_dir = /db/innodb
innodb_data_file_path = ibdata1:10M:autoextend:max:4G
innodb_log_files_in_group = 2
innodb_log_file_size = 256M
innodb_file_per_table
innodb_buffer_pool_size = 400M
innodb_additional_mem_pool_size = 80M
transaction-isolation = READ-COMMITTED
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer = 64M
sort_buffer_size = 16M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
[manager]
socket = /db/log/manager.sock
pid-file=/db/log/manager.pid
password-file = /db/data/.mysqlmanager.passwd
monitoring-interval = 60
port = 1998
bind-address = tlsgriffin01
[mysql.server]
use-manager


On Thu, Feb 19, 2009 at 11:24 PM,  wrote:

> Can you post you my.cnf please
>
> Sent via BlackBerry from T-Mobile
>
> --
> *From*: Jim Lyons
> *Date*: Thu, 19 Feb 2009 23:06:33 -0600
> *To*: 
>
> *Subject*: Re: Resend: enabling storage engine with RPM install
> How does one do that in my.cnf?
>
> It is possible to disable a supported engine by screwing up the my.cnf
> configuration.  For example, I once pointed the InnoDB data file to a
> directory that still had root as its owner.  The Innodb engined appeared as
> DISABLED in the SHOW ENGINES output, but it was supported.  I chown'd the
> directory to the proper owner and it was fine.  (This may be why I mistyped
> InnoDB in my first post - I had InnoDB on my mind.)
>
> In the case of the FEDERATED engine in my database, it's not supported at
> all.  I don't think I can turn support on or off in my.cnf.  I would love
> it, if I could, though.
>
> On Thu, Feb 19, 2009 at 10:47 PM,  wrote:
>
>> Perhaps you disabled it via my.cnf
>>
>>
>> Sent via BlackBerry from T-Mobile
>>
>> -Original Message-
>> From: Jim Lyons 
>>
>> Date: Thu, 19 Feb 2009 22:45:01
>> To: MySQL
>> Subject: Re: Resend: enabling storage engine with RPM install
>>
>>
>> Yes, I had a slip of the mind.  The engine that was not supported by the
>> install is the Federated engine.  I apologize, I had a blind spot.  The
>> "SHOW ENGINES" command lists FEDERATED but has NO in the Support column.
>>
>> The question, though, is how does one add an unsupported engine to an RPM
>> install?  Is it possible?  Otherwise I have to either compile from source
>> or
>> upgrade to a version that I hope will have it.
>>
>> On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz  wrote:
>>
>> > Where on earth did you get an RPM that doesn't have InnoDB support?  I
>> > find this unlikely.  I think it is more likely that you have some
>> > configuration error that's causing InnoDB to disable itself on start.
>> > How do you know InnoDB isn't supported?  And by "isn't supported" I
>> > mean "isn't compiled into mysqld".
>> >
>> > Per your commend that InnoDB wasn't installed with mysqld -- it is not
>> > separate.  It's built into the /usr/sbin/mysqld binary (or whatever
>> > that is on your system).  For example, look at this:
>> >
>> > strings /usr/sbin/mysqld | grep -i innodb
>> >
>> > If you see a bunch of lines starting with "InnoDB: blah blah", you
>> > have a binary that includes InnoDB, and it's just disabled for some
>> > reason.
>> >
>> > Baron
>> >
>> > On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons 
>> wrote:
>> > > Sorry, but I'm resending because I made a mistake in terminology and
>> want
>> > to
>> > > be clear.  The problem isn't that innodb is "DISABLED" on the
>> database.
>> >  The
>> > > innodb engine is not s

Re: Resend: enabling storage engine with RPM install

[chaim . rieger]

Can you post you my.cnf please

Sent via BlackBerry from T-Mobile

-Original Message-
From: Jim Lyons 

Date: Thu, 19 Feb 2009 23:06:33 
To: 
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install


How does one do that in my.cnf?

It is possible to disable a supported engine by screwing up the my.cnf
configuration.  For example, I once pointed the InnoDB data file to a
directory that still had root as its owner.  The Innodb engined appeared as
DISABLED in the SHOW ENGINES output, but it was supported.  I chown'd the
directory to the proper owner and it was fine.  (This may be why I mistyped
InnoDB in my first post - I had InnoDB on my mind.)

In the case of the FEDERATED engine in my database, it's not supported at
all.  I don't think I can turn support on or off in my.cnf.  I would love
it, if I could, though.

On Thu, Feb 19, 2009 at 10:47 PM,  wrote:

> Perhaps you disabled it via my.cnf
>
>
> Sent via BlackBerry from T-Mobile
>
> -Original Message-
> From: Jim Lyons 
>
> Date: Thu, 19 Feb 2009 22:45:01
> To: MySQL
> Subject: Re: Resend: enabling storage engine with RPM install
>
>
> Yes, I had a slip of the mind.  The engine that was not supported by the
> install is the Federated engine.  I apologize, I had a blind spot.  The
> "SHOW ENGINES" command lists FEDERATED but has NO in the Support column.
>
> The question, though, is how does one add an unsupported engine to an RPM
> install?  Is it possible?  Otherwise I have to either compile from source
> or
> upgrade to a version that I hope will have it.
>
> On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz  wrote:
>
> > Where on earth did you get an RPM that doesn't have InnoDB support?  I
> > find this unlikely.  I think it is more likely that you have some
> > configuration error that's causing InnoDB to disable itself on start.
> > How do you know InnoDB isn't supported?  And by "isn't supported" I
> > mean "isn't compiled into mysqld".
> >
> > Per your commend that InnoDB wasn't installed with mysqld -- it is not
> > separate.  It's built into the /usr/sbin/mysqld binary (or whatever
> > that is on your system).  For example, look at this:
> >
> > strings /usr/sbin/mysqld | grep -i innodb
> >
> > If you see a bunch of lines starting with "InnoDB: blah blah", you
> > have a binary that includes InnoDB, and it's just disabled for some
> > reason.
> >
> > Baron
> >
> > On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons  wrote:
> > > Sorry, but I'm resending because I made a mistake in terminology and
> want
> > to
> > > be clear.  The problem isn't that innodb is "DISABLED" on the database.
> >  The
> > > innodb engine is not supported by the database.
> > >
> > > We have 5.0.22 installed on a test machine and for some reason the
> innodb
> > > storage engine was not installed with it.  We install from RPMs so I'm
> > not
> > > sure how to install the storage engine. If we compiled ourselves, we'd
> > > recompile but that's not an option.
> > >
> > > Does anyone know how to install a storage engine once mysql's been
> > installed
> > > by an RPM?  How does one make the selections in the first place with
> > RPMs?
> > > We've always just taken what we got and it was sufficient.
> > >
> > > Thanks,
> > > Jim
> > >
> > > --
> > > Jim Lyons
> > > Web developer / Database administrator
> > > http://www.weblyons.com
> > >
> >
> >
> >
> > --
> > Baron Schwartz, Director of Consulting, Percona Inc.
> > Our Blog: http://www.mysqlperformanceblog.com/
> > Our Services: http://www.percona.com/services.html
> >
>
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Re: Resend: enabling storage engine with RPM install

[chaim . rieger]

Perhaps you disabled it via my.cnf


Sent via BlackBerry from T-Mobile

-Original Message-
From: Jim Lyons 

Date: Thu, 19 Feb 2009 22:45:01 
To: MySQL
Subject: Re: Resend: enabling storage engine with RPM install


Yes, I had a slip of the mind.  The engine that was not supported by the
install is the Federated engine.  I apologize, I had a blind spot.  The
"SHOW ENGINES" command lists FEDERATED but has NO in the Support column.

The question, though, is how does one add an unsupported engine to an RPM
install?  Is it possible?  Otherwise I have to either compile from source or
upgrade to a version that I hope will have it.

On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz  wrote:

> Where on earth did you get an RPM that doesn't have InnoDB support?  I
> find this unlikely.  I think it is more likely that you have some
> configuration error that's causing InnoDB to disable itself on start.
> How do you know InnoDB isn't supported?  And by "isn't supported" I
> mean "isn't compiled into mysqld".
>
> Per your commend that InnoDB wasn't installed with mysqld -- it is not
> separate.  It's built into the /usr/sbin/mysqld binary (or whatever
> that is on your system).  For example, look at this:
>
> strings /usr/sbin/mysqld | grep -i innodb
>
> If you see a bunch of lines starting with "InnoDB: blah blah", you
> have a binary that includes InnoDB, and it's just disabled for some
> reason.
>
> Baron
>
> On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons  wrote:
> > Sorry, but I'm resending because I made a mistake in terminology and want
> to
> > be clear.  The problem isn't that innodb is "DISABLED" on the database.
>  The
> > innodb engine is not supported by the database.
> >
> > We have 5.0.22 installed on a test machine and for some reason the innodb
> > storage engine was not installed with it.  We install from RPMs so I'm
> not
> > sure how to install the storage engine. If we compiled ourselves, we'd
> > recompile but that's not an option.
> >
> > Does anyone know how to install a storage engine once mysql's been
> installed
> > by an RPM?  How does one make the selections in the first place with
> RPMs?
> > We've always just taken what we got and it was sufficient.
> >
> > Thanks,
> > Jim
> >
> > --
> > Jim Lyons
> > Web developer / Database administrator
> > http://www.weblyons.com
> >
>
>
>
> --
> Baron Schwartz, Director of Consulting, Percona Inc.
> Our Blog: http://www.mysqlperformanceblog.com/
> Our Services: http://www.percona.com/services.html
>



-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Re: installation nightmare

[Chaim Rieger]

PJ wrote:
longer a problem... but noweven pgsql was a breeze to install and 
update... the only reason I'm trying to install mysql is because my 
ISP Web host is using that... maybe not if I can help it









no offense but at this time, perhaps its operator error

i've installed mysql on freebsd may times.


--
--
Chaim Rieger
www.jravel.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MYSQL startup problem

[chaim . rieger]

When you do the following
Mysql -h localhost -u root. 
What do you get ?


Sent via BlackBerry from T-Mobile

-Original Message-
From: "BAJAJ POOJA" 

Date: Fri, 12 Dec 2008 08:43:45 
To: ; Chandru
Cc: 
Subject: RE: MYSQL startup problem


 
Hi,

It doesn't allows me to telnet port 3306.
If I ping that port I receive Request timed out.

--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
Phone:+124-413-3078 | Onnet: 2721-3078

-Original Message-
From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com] 
Sent: 12 December 2008 13:02
To: BAJAJ POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem

It says that is started mysql

Can you telnet to port 3306 ?


Sent via BlackBerry from T-Mobile

-Original Message-
From: "BAJAJ POOJA" 

Date: Fri, 12 Dec 2008 08:27:02
To: Chandru
Cc: 
Subject: RE: MYSQL startup problem


Hi,
 
Pls find logs attached below in mail:
 
 
080605 15:28:08  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080606  9:32:18  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080606  9:32:18  InnoDB: Starting shutdown...
080606  9:32:21  InnoDB: Shutdown completed
080606  9:32:21  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080606  9:30:58  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080606 11:43:53  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080606 11:43:53  InnoDB: Starting shutdown...
080606 11:43:54  InnoDB: Shutdown completed
080606 11:43:54  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080606 11:43:55  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609  9:29:04  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609 10:14:40  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080609 10:14:40  InnoDB: Starting shutdown...
080609 10:14:41  InnoDB: Shutdown completed
080609 10:14:41  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080609 10:26:27  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609 16:45:52  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080609 16:45:52  InnoDB: Starting shutdown...
080609 16:45:54  InnoDB: Shutdown completed
080609 16:45:54  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080609 17:01:50  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080610 11:05:35  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080610 11:05:35  InnoDB: Starting shutdown...
080610 11:05:36  InnoDB: Shutdown completed
080610 11:05:36  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080610 11:11:23  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080613 17:28:21  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080613 17:28:21  InnoDB: Starting shutdown...
080613 17:28:24  InnoDB: Shutdown completed
080613 17:28:24  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080616 11:28:22  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080701 11:10:31  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080701 11:10:31  InnoDB: Starting shutdown...
080701 11:10:33  InnoDB: Shutdown completed
080701 11:10:33  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080701 11:12:34  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080701 11:15:12  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080701 11:15:12  InnoDB: Starting shutdown...
080701 11:15:13  InnoDB: Shutdown completed
080701 11:15:13  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080701 11:16:01  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080818 16:40:28  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
081211 13:10:16  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
081211 13:10:16  InnoDB: Starting shutdown...
081211 13:10:17  InnoDB: Shutdown completed
081211 13:10:17  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
081211 13:10:18  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
08 13:13:43  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
08 13:13:43  InnoDB: Starting shutdown...
08 13:13:44  InnoDB: Shutdown completed
08 13:13:44  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
08 13:13:59  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '

Re: MYSQL startup problem

[chaim . rieger]

It says that is started mysql

Can you telnet to port 3306 ?


Sent via BlackBerry from T-Mobile

-Original Message-
From: "BAJAJ POOJA" 

Date: Fri, 12 Dec 2008 08:27:02 
To: Chandru
Cc: 
Subject: RE: MYSQL startup problem


Hi,
 
Pls find logs attached below in mail:
 
 
080605 15:28:08  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080606  9:32:18  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080606  9:32:18  InnoDB: Starting shutdown...
080606  9:32:21  InnoDB: Shutdown completed
080606  9:32:21  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080606  9:30:58  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080606 11:43:53  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080606 11:43:53  InnoDB: Starting shutdown...
080606 11:43:54  InnoDB: Shutdown completed
080606 11:43:54  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080606 11:43:55  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609  9:29:04  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609 10:14:40  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080609 10:14:40  InnoDB: Starting shutdown...
080609 10:14:41  InnoDB: Shutdown completed
080609 10:14:41  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080609 10:26:27  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080609 16:45:52  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080609 16:45:52  InnoDB: Starting shutdown...
080609 16:45:54  InnoDB: Shutdown completed
080609 16:45:54  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080609 17:01:50  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080610 11:05:35  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080610 11:05:35  InnoDB: Starting shutdown...
080610 11:05:36  InnoDB: Shutdown completed
080610 11:05:36  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080610 11:11:23  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080613 17:28:21  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080613 17:28:21  InnoDB: Starting shutdown...
080613 17:28:24  InnoDB: Shutdown completed
080613 17:28:24  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080616 11:28:22  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080701 11:10:31  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080701 11:10:31  InnoDB: Starting shutdown...
080701 11:10:33  InnoDB: Shutdown completed
080701 11:10:33  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080701 11:12:34  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080701 11:15:12  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
080701 11:15:12  InnoDB: Starting shutdown...
080701 11:15:13  InnoDB: Shutdown completed
080701 11:15:13  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
080701 11:16:01  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
080818 16:40:28  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
081211 13:10:16  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
081211 13:10:16  InnoDB: Starting shutdown...
081211 13:10:17  InnoDB: Shutdown completed
081211 13:10:17  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
081211 13:10:18  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
08 13:13:43  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
08 13:13:43  InnoDB: Starting shutdown...
08 13:13:44  InnoDB: Shutdown completed
08 13:13:44  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
08 13:13:59  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
08 13:14:35  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
08 13:14:35  InnoDB: Starting shutdown...
08 13:14:36  InnoDB: Shutdown completed
08 13:14:36  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
08 13:14:36  InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log'  socket: ''  port: 3306
08 13:16:50  c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
 
08 13:16:50  InnoDB: Starting shutdown...
08 13:16:52  InnoDB: Shutdown completed
08 13:16:52  c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete
 
08 13:17:30  InnoDB: Started
c:\wamp\mysql\bi

Re: slow.log by date

[chaim . rieger]

Write a perl script

Am sure there are some out there

Look at addons for awstats.


--Original Message--
From: Fayland Lam
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: slow.log by date
Sent: Nov 30, 2008 18:37

[EMAIL PROTECTED] wrote:
> Syslog-ng combined with logrotate
>   

well, logrotate is for the coming log. what can we do towards existing 
ones. :)

Thanks.

>
> --Original Message--
> From: Fayland Lam
> To: mysql@lists.mysql.com
> Subject: slow.log by date
> Sent: Nov 30, 2008 18:22
>
> well, our slow.log is pretty huge and say I just want the logs in the 
> last week. (tail -n XXX is not good enough)
> I'm wondering there is a script (Perl or bash or others) can do this? 
> I'm not willing to reinvent the wheel. :)
>
> Thanks.
>
>   


-- 
Fayland Lam // http://www.fayland.org/ 
Foorum based on Catalyst // http://www.foorumbbs.com/ 



Sent via BlackBerry from T-Mobile

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

Re: slow.log by date

[chaim . rieger]

Syslog-ng combined with logrotate


--Original Message--
From: Fayland Lam
To: mysql@lists.mysql.com
Subject: slow.log by date
Sent: Nov 30, 2008 18:22

well, our slow.log is pretty huge and say I just want the logs in the 
last week. (tail -n XXX is not good enough)
I'm wondering there is a script (Perl or bash or others) can do this? 
I'm not willing to reinvent the wheel. :)

Thanks.

-- 
Fayland Lam // http://www.fayland.org/ 
Foorum based on Catalyst // http://www.foorumbbs.com/ 


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



Sent via BlackBerry from T-Mobile

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

Re: STORE MYSQL DATA ON TWO HARDDISK

[chaim . rieger]

Move your logs to the second drive
I wouldn't do this, but you can move a db to drive2 and link it into the 
/data/dir


--Original Message--
From: Krishna Chandra Prajapati
To: mysql@lists.mysql.com
Sent: Oct 13, 2008 22:33
Subject: STORE MYSQL DATA ON TWO HARDDISK

Hi,

I have two hard disk on debian system. Each of 80GB. I want to use both the
hard disk for storing the *mysql data.  *On one hard disk the data has
reached up to 73GB.

What changes, I can do to use both the hard disk for storing mysql data.
Quick response is highly appreciated.

Thanks
-- 
Krishna Chandra Prajapati



Sent via BlackBerry from T-Mobile

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

Re: multiple mysql service on the same server

[chaim . rieger]

Right

Keep them in the datadir to make things easier for you


Sent via BlackBerry from T-Mobile

-Original Message-
From: "Ananda Kumar" <[EMAIL PROTECTED]>

Date: Sun, 24 Aug 2008 23:47:24 
To: Jim Lyons<[EMAIL PROTECTED]>
Cc: mysql
Subject: Re: multiple mysql service on the same server


Hi Jim,
If i need to use different my.cnf file, they should be in different
directory right.

regards
anandkl


On 8/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi All,
> I did using single my.cnf file, by specifying different server groups,
> which allows for specifying different socket, pid and data directory
> structure. It can be managed by using mysqld_multi.
>
> regards
> anandkl
>
>
>  On 8/22/08, Jim Lyons <[EMAIL PROTECTED]> wrote:
>>
>> You really need different config files if you're going to log anything or
>> if you need different server ids.  You should also use different sockets.
>> You can stop a specific server by specifying the host on the mysqladmin
>> shutdown command.
>>
>> I did it by keeping everything different, including the names of the
>> my.cnf files, so it would be easy to distinguish the servers in a "ps -ef"
>> command.
>>
>> On Fri, Aug 22, 2008 at 3:55 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>>
>>> Hi All,
>>> I am asking a very simple question.
>>>
>>> I need to install two mysql service (instances) on the same server.
>>> I know we can do that using different port, but should i use two
>>> different
>>> my.cnf files, and also, what is the procedure to stop one mysql service
>>> and
>>> keep other one running.
>>>
>>> regards
>>> anandkl
>>>
>>
>>
>>
>> --
>> Jim Lyons
>> Web developer / Database administrator
>> http://www.weblyons.com
>>
>>
>
>

Re: mysqldump questions

[chaim . rieger]

Whatever you name it
Wherever you place it
Mysqldump (options) > filename



--Original Message--
From: Nanu Kalmanovitz
Sender: 
To: mysql@lists.mysql.com
Sent: Aug 22, 2008 23:48
Subject: mysqldump questions

Hi!

What is the name dumped file and where it is created?
 
System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3.

TIA

Nanu




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



Sent via BlackBerry from T-Mobile

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

Re: Blocking HTML code in inserts?

[chaim . rieger]

Doubt this can be done easily if at all.
Accept only text and no html. But even that should be the job of the form 
validator



--Original Message--
From: Skip Evans
To: mysql@lists.mysql.com
Sent: Aug 2, 2008 14:16
Subject: Blocking HTML code in inserts?

Hey all,

What is the most effective way to block HTML code 
in insert statements?

I have a client with a comments form that is being 
bombarded with people inserting references to 
their own sites, etc, and I need an effective way 
to filter basically any HTML tags at all.

Thanks,
Skip
-- 
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/

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



Sent via BlackBerry from T-Mobile

Re: MySQL won't start with external bind-adress in my.cnf

[Chaim Rieger]

Skip Evans wrote:

Chaim Rieger wrote:

Skip Evans wrote:
can you post the output of ifconfig please


bge0: flags=8843 mtu 1500
options=1a
inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1
inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255
bge1: flags=8843 mtu 1500
options=1a
inet6 fe80::230:48ff:fe88:2b8b%bge1 prefixlen 64 scopeid 0x2
inet 192.168.1.250 netmask 0xff00 broadcast 192.168.1.255

ok

where do you come up with the public addy then ?
i only see private ips listed

i would change it to allow networking on all interfaces.



--
--
Chaim Rieger


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

Re: MySQL won't start with external bind-adress in my.cnf

[Chaim Rieger]

Skip Evans wrote:

Hey Chaim,

I'm sorry, I don't know what you mean by "default route". I am only 
familiar with the current contents of my.cnf, and mods were made 
according to instructions I found via Google.


I don't see this noted in MySQL anywhere. Is this a network-wide 
configuration?

can you post the output of ifconfig please


thanx





--
--
Chaim Rieger


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

Re: Access denied for user 'debian-sys-maint'@'localhost'

[chaim . rieger]

Do you login via sock or network ?
Didja change the passwd for localhost and % ?


--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'

OK. This is driving me Nutz 8-p

Any time I try to restart mysql, I get the error, "Access denied for user 
'debian-sys-maint'@'localhost'"

My understanding is that the password for the debian-sys-maint user is found 
in /etc/mysql/debian.cnf  So, I edit that, and note the password.

I then execute the following in MySQL (with the correct password, of 
course):
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 
PASSWORD 'LongPasswordHere' WITH GRANT OPTION

To test it out, I try a mysql -u debian-sys-maint -p, type in the password 
and get the "Access denied" error again.  What's going on? Why can't I get 
this to work?

Jesse 


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



Sent via BlackBerry from T-Mobile

Re: Spaces in sourced file names?

[chaim . rieger]

Ls -la file\ name.file


\ 
Will escape the space for ya me believes
--Original Message--
From: Jerry Schwartz
To: mysql@lists.mysql.com
Sent: Jul 21, 2008 13:48
Subject: Spaces in sourced file names?

In the CLI, is there any way to source a file whose name has whitespace in
it (particularly spaces)? 

 

Regards,

 

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

 

860.674.8796 / FAX: 860.674.8341

 

  www.the-infoshop.com

  www.giiexpress.com

www.etudes-marche.com




Sent via BlackBerry from T-Mobile

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

[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 tried 0.0.0.0, and I still cannot connect from other 
machines.

Jesse

- Original Message - 
From: "Curtis Maurand" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL 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 is in upper case.  My phone is doing that for me.


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



Sent via BlackBerry from T-Mobile