That still leaves the question, what are the actual rules/business logic by
which you want to group things and get their abbreviations? Are you adhering
to Royal Mail/Post Office residual selection/direct selection rules, or do you
have your own scheme? It seems like the latter ... the RM
machiel.richards wrote:
Good day guys
[snip]
. Each item in the text field is added in the field by entering
the country name then pressing enter and then entering the next, etc
. When exporting the data to a file (even when enclosing each field
within quotes) it still
SELECT * FROM `greeting` WHERE `season` IN ('christmas', 'new_year');
On Fri, Dec 25, 2009 at 2:33 AM, peter scott pbsb...@googlemail.com wrote:
Hope you are all having a Happy Christmas.
Regards
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
I have a Python application that is using MySQL to store records of
transactions about 3 tables with ~1k records each.
How can I periodically copy the records off the production on to an archive
server? I would like to this for two reasons:
1) To run data-mining queries on a copy
Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm wrote:
Why don't you just say Drop User carlos?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user
Hello,
I need to create a system where records are generated by a producer process
and processed by several worker processes.
I was thinking about something like:
Producer:
1) Producer INSERTs new records with state = new worker = null
2) Producer sleeps and loops back to step #1
Worker(s):
I am creating surveys for our website and want store questions and answers
in a database. I found a tutorial that was useful, however it only gave
structure for a single question with one answer. My surveys need to be more
comprehensive than a poll question, and so I need some help with the
You have ten half-open connections (in SYN_SENT state), and a new connection attempt is
giving you error 10055 which is windows' way of saying it can't allocate a buffer for a
new connection. Are you running XP SP2 or SP3 or Vista? Microsoft introduced a throttle
on in these versions, if
Ali, Saqib wrote:
I exported a large data set from from Microsoft SQL server in CSV
format. However whenever I try to import that data to a a mySQL server
running on Linux, it adds a space between each character in each
field.
Essentially:
Saqib Ali
becomes
S a q i b A l i
I have tried to use
Tangirala, Srikalyan wrote:
Hi All:
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
Sure, let's play devil's advocate for a minute.
Some things unique to MySQL that Oracle does not offer include:
- Storage engines, choices like
On 11/9/06, ViSolve DB Team [EMAIL PROTECTED] wrote:
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE
I haven't personally done a store locator, but...
Store locators are relatively crude, yet useful. It is unlikely that
exacting math will make one less crude in such a way as to make it
significantly more useful. They usually just display a list of locations
that *might* be convenient, and that's
Felix Geerinckx wrote:
On 24/11/2005, Lowell Allen wrote:
but I'm looking for a way to convert the short hash values into
comparable long hash values.
This is (fortunately) *not* possible.
Apparently the upgrade procedure can successfully convert
short-to-long hash values for MySQL user
for MySQL
user passwords (user in the sense of a MySQL user accessing the
database itself), so surely there's a way to convert short hashed values
to long hashed values for use within a PHP application. Any practical
advice greatly appreciated.
--
Lowell Allen
--
MySQL General Mailing List
net access.
Adding all the local machines to /etc/hosts solved the problem
immediately.
Chris Allen.
On Fri, Sep 16, 2005 at 01:30:34PM +0300, Gleb Paharenko wrote:
Hello.
What is SHOW PROCESSLIST reporting when the server is reaching the
max_connections limit
]
Rich Allen
Dare Do
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
MySQL AB doing work for SCO is one thing, partnership would be much
a different matter which would then lead me to agree that looking at
Pg would be a good idea. Hopefully MySQL AB will make all this clear
one way or the other ...
Rich Allen
Dare Do
.
Rich Allen
A kidney transplant saved my life, plese consider being an organ donor.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
is this a known issue? running mysql on mac os x 10.4
thanks
Rich Allen
Dare Do
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin processlist
On Jul 26, 2005, at 5:21 PM, Joeffrey Betita wrote:
hello
what command should i type to see all the user connected to
the database.
thank you very much.
Rich Allen
Dare Do
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test /temp/test.sql
eMac:~ hcir$ ls -l /temp/test.sql
-rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql
contents of ~/.my.cnf
[client]
user= username
password= password
# actual username and
do to help develope DBA skills?
Right now I have very little data that goes beyond 2 tables, so my
query skills are withering.
Rich Allen
A kidney transplant saved my life, plese consider being an organ donor.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
i am running 4.1.9 binary on tiger without any trouble
Your MySQL connection id is 1 to server version: 4.1.9-standard
- hcir
On May 23, 2005, at 1:03 PM, Kevin Victor wrote:
I would like to know if there is any existing solution for running
MySQL on Tiger. I dont see a binary version for
. No change. (I put the original
one back.)
So, I am stumped. Any suggestions are greatly appreciated.
--
regards,
allen wayne best, esq
your friendly neighborhood rambler owner
my rambler will go from 0 to 105
Current date: 8:6:16::98:2005
The real reason psychology is hard is that psychologists
mikael
thank you very kindly; that did the trick.
On Saturday 09 April 2005 16:49, Mikael Fridh pronounced:
Allen Wayne Best wrote:
hello;
I am having a spot of trouble getting to MySQL to start. Here is the
message:
050407 22:43:49 mysqld started
050407 22:43:49 /usr/libexec/mysqld
iH
i have a database that i only have READ access to (i am not the
creator). there are tables with stats data that are created each day;
ie data3_1_2005 and 'data3_2_2005. each table has the same layout.
create table data3_1_2005 (
port char(8),
tmval int,
val int
)
how can i create a single
Hi All,
Is this a valid query and will it achieve the result of appending a carriage
return and some text to the current contents of a text type field:
Update Atable set Afield = concat(Afield, \n, Some Text) where KeyField
= 'keydata'
Thanks in advance.
Allen
--
MySQL General
zlib 13 Mar 29 2003 /lib/libz.so -
libz.so.1.1.4
lrwxrwxrwx1 zlib zlib 13 Mar 29 2003 /lib/libz.so.1 -
libz.so.1.1.4
-rwxr-xr-x1 zlib zlib63020 Mar 23 2003 /lib/libz.so.1.1.4
--
Casey Allen Shobe | http://casey.allen.shobe.info
[EMAIL PROTECTED
make[2]: Leaving directory `/share/src/mysql/mysql-4.0.20/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/share/src/mysql/mysql-4.0.20/sql'
make: *** [all] Error 2
Casey Allen Shobe said:
Michael Stassen said:
-lz means to link with libz (the zlib library
http://www.gzip.org
, intentionally. How can I make MySQL build against
the dynamic library instead of the static?
--
Casey Allen Shobe | http://casey.allen.shobe.info
[EMAIL PROTECTED] | ICQ: 1494523 | AIM: SomeLinuxGuy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Allen Shobe | http://casey.allen.shobe.info
[EMAIL PROTECTED] | ICQ: 1494523 | AIM: SomeLinuxGuy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this query (I am used to using PostgreSQL and
subselects)?
What indexes would be the most beneficial to the query suggestion?
Thank you for your time, any response appreciated.
--
Casey Allen Shobe | http://casey.allen.shobe.info
[EMAIL PROTECTED] | ICQ: 1494523 | AIM: SomeLinuxGuy
--
MySQL
i have one MySQL dB that is currently about 26Gb, properly indexed
searches are very quick
- hcir
On Jul 28, 2004, at 4:23 AM, matt ryan wrote:
Should I even attempt this using mysql?
Has anyone played with this much data in mysql?
I've got two 100 gig databases in mysql, and slave replication
try:
lines terminated by '\r\n';
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 3:36 PM
To: [EMAIL PROTECTED]
Subject: problem importing .csv (excel format) into mysql
I was sent an excel file from a remote office, and need to put
iH
any machine running OS X can run MySQL,
this link http://dev.mysql.com/downloads/mysql/4.0.html has a Mac OS X
version with a package installer
- hcir
On Jun 29, 2004, at 5:14 PM, Jim Carwardine wrote:
Im new to the list and new to mySQL. Im a Mac user and would like
to set
up a DB on my
sounds like --safe-mode has been turned on, check your my.cnf files
- hcir
On Jun 10, 2004, at 7:18 PM, Nik Belajcic wrote:
I have a strange problem importing data from a text file. There are
1353
rows in the text file (generated by a Perl script) but only 1000 get
imported into MySQL. I am
Garth, good catch!
- hcir
mysql
- hcir
On May 24, 2004, at 1:05 PM, Garth Webb wrote:
On Mon, 2004-05-24 at 11:32, John Nichel wrote:
Rich Allen wrote:
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8 |
| 5 | 7 |
| 6 | 0 |
| 7 | 6 |
| 8 | 7 |
| 9 | 8 |
++---+
9 rows in set (0.00 sec)
test select count(distinct(field))
Thanks for the response, it was timely and right on the money.
Allen
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 6:22 PM
To: Allen Weeks; MySQL List
Subject: Re: Importing Fixed Length Text Files
Allen Weeks wrote:
Hello All
ps should show you something like the following:
Jupiter:~/desktop hcir$ ps uax | grep mysql
root 291 0.0 0.118644 1072 ?? S 3May04 0:00.06 sh
./bin/safe_mysqld --user=mysql
mysql 338 0.0 2.551720 19872 ?? S 3May04 10:17.86
Hello All,
Maybe I am not searching the documentation correctly or am I correct in
finding there is not method of directing importing a fixed length text file
into a MySQL table?
I hope I just missed the reference. Could someone point me to it.
Any assistance is greatly appreciated.
Allen
.
Kirti
-Original Message-
From: Rich Allen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 6:02 PM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'
Subject: Re: Perl Modelues
you can install Perl modules with
$ perl -MCPAN -e shell
cpan install [module::name]
- hcir
mysql
- hcir
you can install Perl modules with
$ perl -MCPAN -e shell
cpan install [module::name]
- hcir
mysql
- hcir
On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote:
Hello List:
I have run into stone wall in figuring out installation of Perl DBI
modules
with MySQL. When I review the MySQL
Brent Baisley wrote:
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
But the 50% rule is overridden when the search
I have a table with the following:
CREATE TABLE foo (
...
description text,
...
FULLTEXT INDEX (description),
...
);
select count(*) from foo where description like '%db2%';
returns 61 rows. Checking them confirms that the word db2 exists as a
standalone word separated either by punctuation or
Richard Davey wrote:
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include
I've read through the boolean mode fulltext docs, and they address all
my questions well except how searches containing exact phrases are
handled when there is more than one. I believe the following will work
as I expect, but was wondering if anyone can confirm it for me:
Given the following
For some reason mysql is logging every sql statement. I don't recall
turning on such a thing. Can someone tell me how to turn that down/off. It
seems a little excessive for my wimpy vps.
Thanks,
Mike
# dpkg -l | grep mys
ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl
ii
. This enables you to get very
acquainted with DB2 for free and only buy a licence if you like it enough to
use it in production.)
Rhino
- Original Message -
From: J. Allen Crider [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 10:54 PM
Subject: oracledump.pl error
Sasha Pachev wrote:
J. Allen Crider wrote:
I have just decided to try to learn something about MySQL after
several years of working with Oracle and wanted to transfer the data
I have in an Oracle 9i database to a new MySQL database. Since this
is strictly for personal use, I can't justify
']) at ./oracledump.pl line 471.
(followed by several other errors obviously caused by this error.)
Running the same statement in sqlplus works fine.
I am running Oracle 9i Release 2 on Gentoo Linux. Any ideas on what I'm
doing wrong?
Allen Crider
Huntsville, AL
[EMAIL PROTECTED]
--
MySQL General
it mentioned
several times on the PHP general discussion list.
HTH
--
Lowell Allen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is of type datetime:
WHERE (TO_DAYS(CURDATE()) - TO_DAYS(date)) = 1
HTH
--
Lowell Allen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
Please pardon the test as I have received no messages from the list in a few
days
Allen
I'd like to move some bookmarks in one database to another. The format
of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly trucated):
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Hi All,
Just a quick question, does anyone have a good estimate of when ver 4.1 will
go production.
Thanks
Allen
.
Can anybody suggest what might be the problem?
Many thanks,
Chris Allen.
Linux my.cnf:
[mysqld]
server-id = 2
skip-locking
set-variable= max_connections=400
set-variable= back_log=20
set-variable= key_buffer=150M
set-variable= table_cache=256
set-variable
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
There are a few things that could be happening:
Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
2. Which FS are you using? The native Solaris FS needs a bit of tuning
to get
On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote:
The DB is on a vanilla UFS partition. Do you have any references about
this? I couldn't find anything on the MySQL site...
There's nothing on the MySQL site but I do remember reading a comparison
between Solaris x86 and
At 09:24 PM 11/10/2003, Leo wrote:
notice the _and_ ?
*grin*
good point. I guess my reply (which I found out later was unnecessary since
the question had already been answered) would have been better stated had I
just pointed out the distinct keyword rather than constructing a sample
query. :)
At 07:45 PM 11/7/2003, Jonathan Terhorst wrote:
snip
One way I have found to implement this is
SELECT Table1.id from Table1 JOIN Features USING(id) WHERE
Features.FeatureCode='A01' OR Features.FeatureCode='B02' GROUP BY Table1.id
HAVING COUNT(*)=2;
e.g. counting the duplications of id and
Hi All,
I can't seem to find any documentation or opinions that would help me decide
if it is better to run mysqld-max-nt over the non-max server.
Opinions and pointers to supporting docs would be very welcome (especially
pointer to docs).
Thanks to All in advance.
Allen
I've searched the archives and was unable to find anything that seemed
pertinent.
Earlier today I had to stop and start mysql. When I issued mysqladmin
shutdown, however, the process did not die cleanly (reason unknown), and I
ended up having to kill -9 mysqld and mysqld_safe.
When the DB
Running 4.0.15a. The second select's FOUND_ROWS() returns the wrong number of rows.
To test yourself:
create database test1234;
\r test1234
create table test (id int, primary key (id));
insert into test values (1), (2), (3), (4), (5);
select SQL_CALC_FOUND_ROWS * from test where id 3 limit 0,
127.0.0.1 is always localhost, perhaps you could make this change in
your scripts
- hcir
use MySQL
is there a way to find out which host I am connected
from?
My CGI script checks privileges of users based on host
names they came from. But their hosts some times are
detected as IP. E.g. when
, which I don't really understand. What is taking so long? The join size should be no greater than 250,000 which is the size of the second table. Yes???
I am using the default join_buffer size, which seems to low. Might this be the problem?
--
Allen Brost
--
MySQL General Mailing List
Yes, you are correct. I was thinking that wouldn't be the case, but it makes sense now. I added indexes and then the query returned in a few seconds. Definitely have to have indexes.
Thanks!
Dan Nelson wrote:
In the last episode (Sep 18), Allen said:
I have two tables. One table is 13
them all up I get 340,413. Now they match! What seems to be happening is that the HAVING n 1 is really doing n == 2 not GREATER than 1 and so on.
I would say this looks like a bug or I am crazy either of which could be true.
- Allen
--
MySQL General Mailing List
For list archives: http
DISTINCT key_field is fine. I don't think it will make a difference. My example was using only one field.
Paul DuBois wrote:
At 4:22 PM -0500 9/18/03, Allen wrote:
Ok. I looked through google and saw a couple examples of how to find
the duplicates in a table that looked like this...
SELECT
this link from the mysql docs should help
http://www.mysql.com/doc/en/Resetting_permissions.html
- hcir
Kind of an oddball question but I'll try to make it as clear as
possible.
We have a Solaris server, that we have root access to. It houses mysql
db's and information.
I was not the admin for
, changing
either setting would require a rebuild of the FT index(es), but then, so
does FT_MIN_WORD_LENGTH...
TIA
--
Shane Allen [EMAIL PROTECTED]
http://www.emphasys.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
We're considering switching to InnoDB tables for a couple of tables in
our database where we need transactions. We're complete newbies with
reference to innodb, although we are seasoned veterans with regards to
MySQL/MyISAM and general concepts.
We have come up with a couple questions that we
Hi,
I tried:
Select ceiling(1.2)
It worked and returned 2.
HTH
Allen
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 12:12 PM
To: Fabio Bernardo; Mysql (E-mail)
Subject: RE: Round Question
what I've done is
select
Try SELECT * FROM `phrases` WHERE ph like %who%;
The percent symbol is the wildcard character for mysql queries
HTH
-Original Message-
From: Pag [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 11:08 AM
To: [EMAIL PROTECTED]
Subject: simple query
Imagine i
iH
you may find this site helpful in getting MySQL running for the first
time
http://www.entropy.ch/software/macosx/mysql/
also recommend that you spend some time learning how to be root, unix
permissions, etc
- hcir
On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg
The only thing I can add is check you hardware and OS platform.
Cheers
-Original Message-
From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 11:44 AM
To: Cybot
Cc: [EMAIL PROTECTED]
Subject: Re: Slow results with simple, well-indexed query
On Thu, Aug 21,
If you are using a MySQL version allowing subselects, try this:
SELECT * FROM temp_hits WHERE url NOT IN(SELECT * FROM hits)
use parenthesis not brackets
hope it helps
Allen
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Soren O'Neill
Sent: Tuesday, August 19, 2003
this is a Perl script, not shell ...
#!/usr/bin/perl
use strict;
use DBI;
# change the next four to match your network
my $SLAVE_IP= '0.0.0.0';
my $MASTER_IP = '0.0.0.0';
my $USER= 'user';
my $PASSWORD= 'password';
my ( $dbh, $sth, @masterResult, @slaveResult, $i );
I've actually noticed this in the past several releases; I apologize for
not mentioning it sooner.
I run:
BUILD/compile-pentium --with-other-libc=/usr/local/mysql-glibc-2.2.5
--prefix=/usr/local --with-extra-charsets=none --without-innodb --without-isam
and part-way through, it fails.
the whole source tree and find no references to
these functions, so I don't think they exist and whoever wrote
test_libmysqld.c forgot to write them. Or they live in a library that's local
to your site.
HTH
allen
--
*
Allen Grace ([EMAIL PROTECTED
' utility? This tells you in readable form what
symbols are defined in any given library - which makes it useful for
answering the kind of question you're asking.
dbconnect() is defined in test_libmysqld.c also, so you shouldn't have any
problems resolving it.
rgds
allen
iH
i found in the ODBC faq how to link from mysql to access, can this be
done in reverse? link from access to mysql?
thanks
- hcir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Description
This may be by design, but I figured I'd bring it up because it caused
less-than-desirable behaviour for me. I executed an alter table query, designed to
change the length of a fixed width char field to 128 from 255. The alter occured fine,
with no problems, except that there were
this article on cross tabulations should help you ...
http://www.mysql.com/articles/wizard/index.html
- hcir
(mysql sql query)
On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS
wrote:
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
iH
how do i properly escape the ampersand character in a mysql select match
against statement
mysql select * from logbook where match(username,body) against
('AT\T');
does not find a match although it should
thanks
- hcir
-
How about this:
mysql CREATE TABLE tablename (value1 int(10) AUTO_INCREMENT, value2 timestamp(14),
PRIMARY KEY (value1));
Query OK, 0 rows affected (0.00 sec)
mysql INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW());
+-+
| INSERT_ID() |
+-+
|
iH
trying to get v7.3 of SuSE/PPC working with mysql and perl. i have the
mysql server working and perl reports that the mysql driver is
available but when trying to connect to the a database i get
error while loading shared libraries:
iH
trying to install mySQL 4.0.10 onto SuSE/PPC and getting an error when
running ./configure
cant create executable
any ideas?
thanks
- hcir
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
trying to get mySQLGUI to install on Mac OS X, fltk seemed to install
ok but am getting the follwoing for flvw
[ARTiBook:~/src/flvw/1.0] root# make
=== making src ===
Compiling Flv_List.cxx...
In file included from ../FL/Flv_List.H:45,
from Flv_List.cxx:38:
have you looked at the mysql command
flush privileges
- hcir
On Tuesday, January 28, 2003, at 02:05 PM, Jon Miller wrote:
When granting someone permissions are these permissions dynamic or do I
have to reload mysql?
Also we have a developer who stated he cannot access the database
remotely.
this command should get your data moved to a new sql table
insert into table2
select
(concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2)))
from table1;
- hcir
On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote:
Hi
I have a few tables in a database Z, namely
table
mysql -h10.0.0.5 -u[username] -Dvisitor -p[password]
should get you in
- hcir
On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote:
I am trying to remotely connect to a MySQL database but I'm having
problems so I tried this on the same machine as the database.
It doesn't work when I
Paul/others,
/usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:477:in `load_driver': Could not
load driver (uninitialized constant Mysql at DBI::DBD)
(DBI::InterfaceError)
from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:384:in `_get_full_driver'
from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:364:in `connect'
this should answer your question, from the DBI documentation
http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm#execute
sql,query,queries,smallint
- hcir
On Friday, January 10, 2003, at 02:55 PM, [EMAIL PROTECTED] wrote:
I've been using the return value of $sth-execute(); (in Perl DBI) to
the example will connect to the local mySQL server and create a new
database named 'dbname
#!/usr/bin/perl -w
use DBI;
$dbh = DBI-connect( dbi:mysql:, 'user', 'password', {
PrintError = 0 } ) or die Can\t connect to database:
$DBI::errstr\n;
$dbh-do(create database dbname);
$dbh-disconnect or
shutdown mysql, move all the files in your current data directory to
the new location
in your my.cnf file (ie. unix: /etc/my.cnf)
[mysqld]
datadir=/my
---
all data files are in /my
- hcir
On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote:
Hi All
Right now I have all my MySQL
I had someything similar It was all down to permissions...make sure
that the permissions on the sql dbfolder allow the sql demon access. And
you have run the install_db script to create it in the first place
Wayne
-Original Message-
From: Jason Steig [mailto:[EMAIL PROTECTED]]
This is a repost of my previous message with a new and improved title
that will hopefully catch more eyes and generate a response. :)
We have two users, lets call them test and test2.
When we log in as test from our front end web servers, we can execute queries and
they replicate.
When we
sound like you may want to add the following to your my.cnf file for
MySQL
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote:
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA
We have two users, lets call them test and test2.
When we log in as test from our front end web servers, we can execute queries and they
replicate.
When we log in as test from our back end db servers (say to run a cleanup script by
hand), the queries replicate.
When we log in as test2 from
1 - 100 of 166 matches
Mail list logo