set up the new user's access. In the commands below, I
used my name as for user and database names:
CREATE DATABASE steve_db;
GRANT ALL PRIVILEGES ON steve_db.* TO "steve"@"localhost"
-> IDENTIFIED BY "steve_pw";
FLUSH PRIVILEGES;
All commands worked succe
On Tue, 23 Jun 2015 14:51:48 -0400, you wrote:
>
>
>On 6/23/2015 10:59 AM, Steve Matzura wrote:
>> I'm building a mail system with Dovecot, Postfix and Mailman with
>> MySQL. I have the other three products installed but not yet
>> configured. I'll do that
I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.
The documentation at
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html
was instrument
To what list should I post with a post-installation config and startup
question?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
t I didn't miss anything.
Is there some sort of tool that allows me to check for repetitive queries?
- Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and i
-2 seconds, which
isn't much, but can be a bother at times)
Thanks, and any/all assistance/opinions are welcomed!
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
that it's a joined key? so the 3 fields
he's inserting, are part of a multi-field key... but to me, it looks
like the characters are not being seen, or converted to a UTF-8 style
format, rather than the chinese (korean/japanese) character set.. ?
maybe?
sorry if i am out of line here...
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
server_id" (which
would have to be unique anyway in the cluster), so you could just add
this to the query:
SELECT @@global.server_id
Then you can figure out elsewhere what 'server_id' corresponds to what
server ip address.
Just trying to think of other solutions on why the OP would wa
have
used InnoDB for large logging tables and what the performance has been?
Steve Musumeche
CIO, Internet Retail Connection
st...@internetretailconnection.com
1-800-248-1987 ext 802
On 2/4/2011 11:29 AM, Andy Wallace wrote:
Greetings, all...
I'm having an issue with a SELECT in our syste
On 1/25/2011 8:00 AM, Robinson, Eric wrote:
your whole solution is crippled because why in the world are
you killing your salves and reinit them without any reason daily?
There is a very good reason: it is the phenomenon of row drift. The
master and slave can appear to be in good sync, but often
rticles table.
Another aside -- I noticed you have index_articles_on_newsletter_id as
well as index_articles_on_newsletter_id_and_created_at. The first index
is redundant, the second index will take care of it. This will slow
down your INSERT/UPDATE/DELETE queries to some degree.
Steve
--
On 1/17/11 9:52 AM, Jerry Schwartz wrote:
[JS] I don't understand how an index on a timestamp would help. Theoretically,
each record could have a unique value for the timestamp; so the index would
have an entry for each record. Would MySQL really use that in preference to,
or in combination with,
n is not
deterministic. If there are multiple rows per album_id, any one of
those rows could provide the updated_at column that you're then using to
order by. What you probably want is to select (and order by) the
max(updated_at).
Steve
--
MySQL General Mailing List
For list a
tamp. What you want is this:
SELECT COUNT(*) AS num FROM alerts WHERE stamp > DATE_SUB(NOW(),
interval 300 second) AND devid=244;
With this query, MySQL will run DATE_SUB() once, and then use the index
on stamp (which I assume you have) to narrow down the result set.
Steve
--
MySQL General
On 1/13/11 3:51 PM, Reindl Harald wrote:
Are you sure that the lags are really the query and not the connection?
I have seen on a windows server with ipv7 large lags because mysql
treid by every connect to make a dns-reverse-lookup first on ipv6
and after fail ipv4
"skip-name-resolve" in the my
On 1/13/11 2:13 PM, Steve Staples wrote:
On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote:
On 1/13/11 1:21 PM, Steve Staples wrote:
table type is MyISAM, it is a "customer_account" table, which holds the
email address, and the customer_id field, the queries that are
consta
On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote:
> On 1/13/11 1:21 PM, Steve Staples wrote:
> > table type is MyISAM, it is a "customer_account" table, which holds the
> > email address, and the customer_id field, the queries that are
> > constantly being
On 1/13/11 1:21 PM, Steve Staples wrote:
table type is MyISAM, it is a "customer_account" table, which holds the
email address, and the customer_id field, the queries that are
constantly being queried is "select customer_id from customer_account
where customer_email = '
discount the value of measuring your raw i/o performance, but
> first we should determine how your data is being stored.
>
> - michael
>
> On Thu, Jan 13, 2011 at 2:44 PM, Steve Staples wrote:
> > Hello,
> >
> > I've been noticing a little lag in my application
s, or are they
sequential? would symlinking the file to another db make any difference
(or is that even possible)?
any insight would be appreciated, or even any ideas on what I may do to
increase the performance, or even how to measure where the issue could
be would help as well.
Steve
--
MySQL
On 1/11/11 9:31 AM, Simon Wilkinson wrote:
select users.id from users where users.id in (select newletters.user_id from
newletters left join articles on newletters.id = articles.newsletter_id
where articles.newsletter_id is null);
I think this would do what you require:
SELECT
u.id AS user_i
fields in the
> > key (i.e. a covering index) does it still choose what you consider to
> > be the wrong key?
> > --
> > Regards... Todd
> > I seek the truth...it is only persistence in self-delusion and
> > ignorance that does harm. -- Marcus Aure
Ok, been googling all morning, and keep getting the same post (on
multiple different sites).
Is there a way, where i corrupt a table purposely? I've tried playing
with the .MYD file, and yeah, it "marks" it deleted under the check
routine, but the table is still readable/writable, just doesn't
able {tablename}
quick; ?
the quick repair has alsways worked for me, and it takes like 20minutes,
to 1hr+ to repair the tables, but should I do somethign different?
if i can run the mysqlcheck -AF say daily, and it would pick up any
issues that would be great...
any ideas/thoughts would be welcomed.
EGES;
I can get the user and password set up fine, but it does not grant any
privileges. It is probably an easy fix that I am just missing, but I would
appreciate your help.
Thanks,
--
Steve Marquez
Marquez Design
e-mail: smarq...@marquez-design.com
web: http://www.marquez-design.com
phone: 479-648-0325
Google has not been kind to me on this one, so I figured I would ask
here...
how can I select with NICE options, so that it doesn't KILL my server,
or any other queries...
Do you understand what I am asking?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
What about:
select `id`, `column1` as 'column2', `column2` as 'column1';
Steve
On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote:
> Couldn't you just rename the columns?
>
> JW
>
>
> On Wed, Sep 22, 2010 at 11:53 AM, Rolando Edwards
> w
sues. it has
never crashed, or caused errors in anyway. I am on Ubuntu 9.10 (it
wants to uninstall wine to upgrade to 10.04, so for now i am not
upgrading)
Steve
> >> -Original Message-
> >> From: Carlos Mennens [mailto:carlosw...@gmail.com]
> >> Sent: Tue
>From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?
Steve
On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote:
> W
a quick routine that goes and 'shows' the tables, and if
it fails, then repair it (or report it back to me via email or
something).
Any ideas on a way to automate something that is efficient and quick?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
ope I missed the joke here, or missed something...
Steve.
On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
> We do nightly backups at work just by taring the mysql directory. In
> my environment, that is /var/lib/mysql.
>
> Like this:
>
> service mysql stop
> cd /var/
t to be able to allow ALL the users of this database
access to it, as well, if I were to change this function, i have to go in,
and manage every user that would be attached to it, to allow to use it
again.
I've tried '%'@'%', and I get the error that this user does not exis
kind of times/loads i
get) i get the error...
I am in the midst of removing the combined unique primary key, to see if
that is the culperate or not, but if anyone has any ideas, i am eager to
listen :)
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: February 8, 2010 10:01 AM
To: mysql@lists.mysql.com
Subject: Re: MyISAM no table lock
On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples wrote:
> Hi there.
>
> I was reading last week (and of course, i can't find i
Hi there.
I was reading last week (and of course, i can't find it now) something about
'nicifying' a query, so taht it doesn't lock the table...
How is this done? I've read so much stuff lately, that i can't find it for
the life of me, and google is not being my f
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
>From the MySQL command line, will this be ok?
Steve.
-Ori
reate them when we do go to a master/slave setup?
Once i finish moving data around, i can remove the old tables that i am
moving them out of, so I don't really see a huge issue with dumping them, i
just want to make sure.
Thanks in advance!
Steve Staples.
--
MySQL General Mailing List
Fo
, may not
be what *you* need.
I'd recommend spending some time reading the documentation for
autoincrement fields and the last_insert_id() function.
- sbe -
--
+----+
| Steve Edberg
Silly question here...
But can I have multiple definers for a stored proc, rather than allowing
`us...@`%`? basically, I want to only allow 1 user name, but from only 2
or 3 IP's.
My Googleing didn't turn up anything of use, so now, I am here asking :)
Thanks in advance!
Ste
x27;t used federated tables yet...
- steve
--
+----+
| Steve Edberg edb...@edberg-online.com |
| Programming/Database/SysAdminhttp://www.edberg-
ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = 'prodCat2';
- s
--
+----+
| Steve Edberg edb...@edberg-online.com |
|
est/suite/ndb/my.cnf
To be followed ... and congratulations to the MySQL Team for the quality of
this 5.4 beta version which looks yet great :)
Regards,
Steve
2009/11/29 Steve Pincaud
> Hello,
>
> I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X
>
ETA for GA
and to get beta versions (the mysql-5.4.3-beta is supported only on
osx10.5-x86_64) ?
Thanks,
Steve
http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg
http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html
http://bugs.mysql.com/bug.php?id=46999
http
7;,'j','k','l','m','n','o','p')
I wouldn't recommend the latter, but might be handy if you were
dealing with something more complex than a simple range.
- steve
--
+-
At 3:29 PM + 10/27/09, Olga Lyashevska wrote:
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a
few
,concat(thing3,thing4)
as thing5 from bar where thing4 like 'baz%' order by thing1 desc
You could create a TEMPORARY table if needed (CREATE TEMPORARY
TABLE...). Assuming version 5.0:
http://dev.mysql.com/doc/refman/5.0/en/create-table.htm
/optimize-overview.html
Table OPTIMIZE command
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
Using EXPLAIN
http://dev.mysql.com/doc/refman/5.0/en/using-explain.html
http://dev.mysql.com/doc/refman/5.0/en/explain.html
MySQL system variables
http://dev.mysql.com/doc/refman/5.0/en/mysqld-op
ables
(information_schema only exists in MySQL >= 5.0, methinks). Manual references:
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
- steve
--
+--- my people are the peopl
hich, by default, will be updated
every time a record is inserted or updated. Then the other
applications can simply select records with timestamp >
last_poll_time.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberg
running v5.0.51a; as you can see, the first invalid value was
truncated to '' with a warning, the second caused an error and did
not insert. I don't know what version you're running, perhaps this
does not apply to you. For more info:
http://dev.mysql.com/doc/re
that one db as the back end.
Steve.
On Wed, Jan 28, 2009 at 6:14 PM, Robert D. Crawford wrote:
> Hello, Olaf,
>
> "Stein, Olaf" writes:
>
> > the import of the dump will not remove your other tables unless there
> > is a naming conflict, then the table will b
Andy,
I just had an interesting experience you might also find interesting. I
rarely have to do restores, also (MySQL is very solid), but I just upgraded
my (only) MySQL server. At the same time I upgraded the MySQL release from
5.0.45 to 5.0.67. While testing my procedure (which was a piece of ca
t;inno
setup script". Please be more specific.
Steve.
ually
'localhost' (e.g. wordpress).
Steve.
On Tue, Dec 9, 2008 at 11:58 AM, Götz Reinicke <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> over the last couple of years our infrastructure rose as we needed and
> now we are thinking about the next steps as the access to the server
uery_log = "| some_program_that_monitors_activity") that might
reduce the load sufficiently.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davi
[3] or the upcoming
ZFS+crypto [4] to store your tables. To minimize the performance
impact, you should keep your index files on a non-encrypted volume if
possible.
steve
[1]
http://dev.mysql.com/doc/refman/5.1/en/roadmap.html
Also couldn't find anything on the mysql-internals list
(h
Hello Moon's Father,
That would be great..if it was in english ;)
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio <[EMAIL PROTECTED]>
wrote:
Hi,
Does anybody has a tip to install a MySQ
I'm trying to get used to visually mapping out my db design using the SqlYog
SchemaDesigner.
Once I have the PK/FK setup, how can I export that design to SQL code to
create the tables, etc??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables
here.
Thanks for any pointers.
Steve
-++
| Variable_name| Value |
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results| latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+---
Does the system in question have some type of "/tmp" cleaner script that
might be removing the socket file? Check /etc/crontab and root's crontab
(crontab -l)
Steve
Thank you so much, that worked!
--
Steve M.
on 1/15/08 3:17 PM Rolando Edwards ([EMAIL PROTECTED]) wrote:
> ORDER is a reserved word in standard SQL
>
> Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
>
> If the column name in the table is
Thanks,
Here it is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','b
Greetings,
I am trying to enter this information into a database called cms_md, with a
table called sections.
INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.
--
Steve M
-03 19:36:54 23
matt2007-10-04 19:37:09 67
steve 2007-10-03 19:36:35 50
steve 2007-10-04 19:36:54 12
steve 2007-10-05 19:37:21 5
If I want the second date for each name in the table, how would I go
about doing that? I've found it easy to get the first date for
for portability if nothing
else. It could well be your problem if you are referring to the
database 'FooBar' as 'FOOBAR' and MySQL is running on a *nix platform.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberg
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year, nice and quick. Now it seems
like its running slowly. Is there a tool to test the db and/or install and
see if there are any problems???
Or would upgrading help?
Anyone have
;t have a need for this).
To try to fix this problem, I restored the "mysql" database, but cannot restore
the "information_schema" database (I have no permission to do this even as the
root DB user).
Can anybody shed some light on this?
Thanks in advance...steve o
--
MyS
om/doc/refman/5.0/en/information-schema.html
for more information.
steve
At 6:29 PM +0200 7/23/07, Mogens Melander wrote:
Try this:
# mysqldump -d DBNAME > tables.sql
--no-data, -d
Do not write any row information for the table.
This is very useful if you want to dump only
th
million records is pretty reasonable. It all depends on your query
& index design (make friends with the EXPLAIN command). If you go
through the mailing list archives, you'll find numerous people with
multiple tables with billions of records.
steve
--
+--- my peop
will not
match. You need to insert more test data before MySQL has enough
words to compute valid relevances.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Ce
: 1
Key_name: i1
Seq_in_index: 2
Column_name: c2
Collation: A
Cardinality: NULL
Sub_part: NULL
Packed: NULL
Null: YES
Index_type: BTREE
Comment:
2 rows in set (0.00 sec)
steve
--
Chris W
KE5GIX
"Protect your digital freedom and pr
should
always have a close-to-balanced tree.
Lastly, I store a hash of the document itself in the database as
well. This allows me to detect if duplicate files are uploaded, and
to determine if a previously-uploaded file has been corrupted in some
way.
steve
--
+--- my p
How about your disk space? I had a similar problem on a large table and
it ended up being caused by filling up the disk.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Octavian Rasnita wrote:
From: "Steve Edberg" <[EMAIL PROTECTED]>
Sometimes I see that
ams out
there. Even after system crashes I haven't lost any data; a repair
table and index rebuild fixed things.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
I believe it would revert back to the settings in your my.cnf file. If
you want the change to be permanent, then set it there.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Bing Du wrote:
Hi,
We're running mysql 4.1.20. If I understand the manual correctly,
ate
current_timestamp
See
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
- steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Cen
and create a non-unique index?
that isn't what i'm trying to do...i need it to be unique.
You can disregard this; again, didn't read the original message
closely enough. This would indeed create a non-unique index.
steve
thanks,
jerad
On Mar 13, 2007, at 4:55 PM, St
eness across a set of columns, define
a unique composite key, for instance: create unique index01
(videourl,userid);
Indexes/keys do not have to be unique unless they are primary or
defined as unique.
steve
--
+--- my people are the people of the dessert, -
v.mysql.com/doc/refman/5.0/en/myisam-table-problems.html
InnoDB problems:
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
steve
PS. This may be an obvious question, but: are you sure data loading
was finished before running the select count(*) and select max(id)
que
rement field or explicitly
reset it using an
alter table auto_increment=1
statement. See
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
for more info.
steve
--
+--- my people are the people of the dessert, ---+
| Ste
ren...), there's
http://www.cdm.org/
Never been there, though, so I can't vouch for it. Interested in
aviation/space?
http://www.moffettfieldmuseum.org/
http://www.nasa.gov/centers/ames/home/exploration.html
http://www.hiller.org/
steve, museum nerd
At 10:
I
haven't played with this much, I might be doing something wrong.
For more info, see:
http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html
- steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghtt
r phone numbers and I
will call you. If it goes the way they want, we will have to have
all servers, frontend, middleman and backend setup within about 6
weeks if possible.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
see that it will do everything that I need for
other things too. I like that it can do a type of CVS for a database
too. A couple of long term projects that I am on could really use
something like that.
Thanks
Steve
At 05:45 AM 9/29/2006, COS wrote:
Hi,
Look at DBTools Manager Enterprise
Is there a program out there that I can use to compare two
databases? Just the structure, not the content.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dan,
Thank you, that works! FYI, you can treat the field like a number,
including sorting, numeric functions, etc.
For example,
select * from table order by (text_field+0.0)
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Dan Nelson wrote:
In the last episode (Sep 28
near 'decimal)' at line 1
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Douglas Sims wrote:
You can use CAST or CONVERT to see the data as a numeric type.
If the table is very big and you're going to be querying it intensely,
you might want to create a
dynamically cast the data to a numeric format so I can use
MySQL's numeric sorting?
I can't change the field's data type because it also needs to be able to
hold textual data. Thank you for your help.
--
Steve Musumeche
CIO, Internet Retail Connection
--
MySQL General Mailing Li
s
unique.
Check mysql manual for more info on syntax of insert command.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center
Select COUNT(*) as num_entries, url from table WHERE num_entries>1 GROUP
BY url
Untested, but the concept should work for you.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Peter Van Dijck wrote:
Hi all, a though query problem for me...
I have a table with 2 rows t
You could try using CONCAT:
select distinct(CONCAT(lat, long)) from table where ...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Lat & lon are two different fields. Either can be duplicated, but not
both.
On Sep 12, 2006, at 12:33 PM, S
Select DISTINCT(lat_long_field) from table where...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Many different records will be returned though, I just don't want any
dupes where both lat/lon is the same.
:)
On Sep 12, 2006, at 12:20 PM,
Greetings,
Does anyone know how I can set up my shell so that the mysql command works
without navigating to the directory? I am using Mac OS 10.2.8 and 10.4
shell> mysql u name p
??
Thanks,
--
Steve Marquez
t the information_schema
database; it might have everything you need already:
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavi
If you are manually editing the grant tables, don't forget to FLUSH
PRIVILEDGES after you add the new tables.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Chris Jones wrote:
Thanks for that. Will create the two tables ahead of time which won't
affect th
eed penalty (that is, do
mysqldump | bzip2 > outputfile.bz2).
Try 'man gzip' and 'man bzip2' for more info.
steve
--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavi
I use EMS MySQL Manager. You can buy it here:
http://www.sqlmanager.net/en/products/mysql/manager/buy
No, I am not affiliated with them, but I use the product everyday and I
love it.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Pooly wrote:
Hi,
MysqlCC not being in
1 - 100 of 1149 matches
Mail list logo