I wouldn't recommend 'playing' with the grant tables instead use the
designated commands.
Anyway keep in mind that if you modify the grant tables manually you have
to force the reload of the privileges in memory by using the 'flush
privileges'.
Not needed if you use GRANT/REVOKE etc.
Cheers
Claudio
Just adding an extra note to the already good Shawn response.
Theoretically this is just as any booking system that needs to be run in
transactions (db or not).
What you are doing is not trivial if that makes you feel better.
The problem is basically that the web interface is asynchronous so you h
It doesn't particularly say, but this:
> 120116 19:15:29 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number
> 1595675
suggests to me that there's still junk from a previous install around. You
might want to clean that up.
- Original Message -
> From: "mantianyu"
> To: mysql@lis
2012/01/16 19:37 +0800, mantianyu
but at last step I start the service by run
sudo bin/mysqld_safe --user=mysql
I got following error message
cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to
'/var/log/mysql/error.log'.
Your means of starting does not sh
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu wrote:
> I have download the
>
> Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
>
> binary edition
>
> and I installed it all followed the INSTALL_BINARY
>
> but at last step I start the service by run
>
> sudo bin/mysqld_safe --user=mysql
>
>
> From: Tim Dunphy
>
> ... this is just a test environment so getting rid of those users won't have
> any meaningful impact...
I think what Paul (who wrote a book on MySQL, by the way) was getting at was
that you risk what database folk call "referential integrity issues" if you
mess with *an
Running mysql(5.5) /linux/ php/python
Got a situation with a test env, where I'm dealing with a number of
spawned processes, that might also spawn processes, so I have a "tree"
where I'm looking to determine when the spawned processes have
completed. To manage this cluster/tree of processes, I'm c
>
> I think what Paul (who wrote a book on MySQL, by the way) was getting at was
> that you risk what database folk call "referential integrity issues" if you
> mess with *any* data without knowing where else it is used.
> [snip]...
that was really an important post, excellently written!
-Govi
See the piece on trees at www.artfulsoftware.com. It goes into several
variations of how to handle hierarchies.
HTH,
--
Arthur
Cell: 647.710.1314
Prediction is difficult, especially of the future.
-- Neils Bohr
I am using debian squeeze and mysql 5.1.45. I am trying to use mysqldumpslow
-s c -t 10, but I keep getting the following error:
Can't determine basedir from 'my_print_defaults mysqld' output:
--general_log=on. Does anyone have any idea as to why? I am not getting
anything from google.
TIA,
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
> Hey Authur.
>
> Should have been more clear. I've looked over a number of sites. And
> with the exception of the the articles that talk about using the
> "Nested List" approach, nowhere did I find data on how to get a
> complete list of the child des
On 1/16/2012 12:53 PM, bruce wrote:
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
Hey Authur.
Should have been more clear. I've looked over a number of sites. And
with the exception of the the articles that talk about using the
"Nested List" approach, nowhere did I find data on how to get a
co
My two cents are this.
This is the kind of problems they invented transactions for. If you find
yourself doing this on non-transactional tables, you will need to use a lot of
error checking, triggers, application checks and post-cleanups to make it work
somehow. Likely, every once in a wh
hi Peter.
Sorry.. Been looking at this for awhile.
In the sample data/tbl I provided, it has two top level root/parents.
Ie, I have two entries that don't have a
parentID. I use 0 to be null.
The items are (0,1), and (0,8).
The (0,1) item, has a number of descendants. The (0,8) only has a
singl
On 1/16/2012 4:14 PM, bruce wrote:
hi Peter.
Sorry.. Been looking at this for awhile.
In the sample data/tbl I provided, it has two top level root/parents.
Ie, I have two entries that don't have a
parentID. I use 0 to be null.
Mistake. use Null.
The items are (0,1), and (0,8).
Then the ta
How do I do case insensitive searches and replace operations?
Is there an easy way to do this? Like some sort of a server level
setting telling mySQL to ignore case for once and for all?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
use LIKE
On Jan 17, 2012, at 10:36 AM, Haluk Karamete wrote:
> How do I do case insensitive searches and replace operations?
> Is there an easy way to do this? Like some sort of a server level
> setting telling mySQL to ignore case for once and for all?
>
> --
> MySQL General Mailing List
> F
Thank you for your reply... But isn't "like" very very slow in
comparison to a none-like straight search?
Isn't it an overkill for a case sensitivity issue?
It appears to me that like has its own usage arena and case
sensitivity issue won't just justify the use of it...
MSSQL can be configured to
In the last episode (Jan 16), Haluk Karamete said:
> How do I do case insensitive searches and replace operations? Is there an
> easy way to do this? Like some sort of a server level setting telling
> mySQL to ignore case for once and for all?
For searches (i.e. comparisons in the WHERE clause),
19 matches
Mail list logo
