s
with a MySQL Core Certificate! https://order.mysql.com/
Regards,
Carsten H. Pedersen
MySQL AB Certification Manager
--
MySQL Certifications, http://www.mysql.com/training/certification.html
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Carsten Pedersen &l
wondered if there is any memory leakage at all.
If you have deleted from many tables, OPTIMIZE will be
your friend.
You might also want to go back to your queries, do an
EXPLAIN and see if you need to redefine indexes, etc.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitby
and now it's gone! Where did it go (a search of
> the HD doesn't show it) and, more important, how do I get it back?
The socket file is created by mysqld at startup.
Are you sure mysqld is running?
Have you tried restarting mysqld?
/ Carsten
--
Carsten H. Pedersen
keep
and now it's gone! Where did it go (a search of
> the HD doesn't show it) and, more important, how do I get it back?
The socket file is created by mysqld at startup.
Are you sure mysqld is running?
Have you tried restarting mysqld?
/ Carsten
--
Carsten H. Pedersen
keep
Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
FROM user
WHERE User='username';
-- if they match, the unencrypted password matches.
Alternatively,
SELECT PASSWORD('thepassword')=Password
FROM user
WHERE User='username';
will return 1 on a match, 0 on non-match (watch out for
nonexisting usernames).
ons on the mysql data directory.
Does the Linux user running mysql (usually "mysql")
have the proper permissions on the directory and
files? If not, do a chown...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
> is there a max row length for MyISAM tables? I'm having a hard
> time finding
> it.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbyb
;
> displays this error:
> ERROR 1054: Unknown column 'z' in 'where clause'
>
> Why isn't z recognized as a column identifier?
Because you should be using HAVING rather than WHERE:
select a,count(*) as z from aa group by a having z>1;
/ Carsten
localhost to domain name?
I don't believe you can - not for the server, at any
rate. For the client, you can twiddle values in my.cnf
to suit your needs.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
> Is there any way to start Ids in table from some number for exampl 1
> with function auto_increment and not from 1?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_4_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/my
es the "user" running mysqld have permission to read/write/execute
on those dirs/files? Might you at some point have been running
mysqld as root, and now you are running it as the "user" mysql?
/ Carsten
--
Carsten H. Pedersen
keeper and main
course, follow the SQL standard, which explicitly
states that the value should be truncated and a warning issued.
MySQL does both.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---
in 3.23.46. From
the change log:
---
D.2.2 Changes in release 3.23.46
Fixed problem with aliased temporary tables replication
---
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
seem to come from "127.0.0.1" -- unless you
specifically set the perms. Don't specify "--host"
when connecting to localhost -- then "--pipe" will
be correctly be assumed.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http:/
uot;. What's wrong?
>
> A fast answer is really appreciated.
Does 'bla bla' have a primary key?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
ll often
be much faster:
SELECT ...
WHERE data LIKE "TOP/World/Japan/%"
AND data NOT LIKE "TOP/World/Japan/%/%"
- in essence: select all those records which start with
"TOP/World/Japan/", then subtract those which contain
any further "/".
/ Carsten
--
Carst
Try reading
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www
error message
you get?
> 2. Mysqldump does not dump the compleat tables.
Which command do you use when running mysqldump?
What is missing?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http:
oup"
You're not providing a lot of information. Is it something
like this, you're looking for:
SELECT t1.depart_time, t2.arrive_time
FROM flights AS t1, flights AS t2
WHERE t1.flight_group = t2.flight_group;
/ Carsten
> related question:
>
> Does MySQL label as "slow" (as I believe PostgreSQL does) any
> query that is
> not referencing an indexed table?
No. Any query that takes longer than long_query_time,
e.g. 10 seconds on most systems, to execute.
Use SHOW VARIABLES to see it
ke many slow queries to have everything backing up waiting
for tables to be released. Try enabling --log-slow-queries, then
have a peek at the log file to see what's causing these.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of th
3.6 was the first version to support UDVs.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (t
.
This is not a TCP port; it's a socket.
>
> Please guide me to over come this problem.
Try running
$ ps -A | grep mysqld
- and see if mysqld isn't already running.
I don't think you have a problem: mysqld is already
running and waiting for you to use
f". It can be set in
a macro as well, though I wouldn't hazard to guess the Italian
translation).
> Greetings from Italy
And some from Denmark, as well...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
as an
> anony
> mous users and anonymous users are not allowed to change passwords'
Because you must do this as root@localhost.
To reset the root password, follow this procedure:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
And some more insight into the privilege system:
http:/
gt; MySQL is case insensitive in selecting records...
> how to make it case-sensitive in selecting records...
SELECT BINARY ...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
the error
>
> Can't connect to MySQL server on '209.249.147.203' (10060)
>
> What does this error 10060 typically indicate?
Try reading
http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0
- it might give you the hints you need.
/ Carsten
--
Carsten H. Peder
from?
You need to get and install the MySQL-client-x-x-x.rpm as well...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://ww
go about it.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
>
> Thanks
>
> Shannon
> --- Michael Brunson <[EMAIL PROTECTED]> wrote:
> > On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon
> > Ken
> Am 21 Dec 2001 15:57:13 +0100 schrieb Carsten H. Pedersen:
> >
> > > I would like to know if there is a possibility to get all allowed
> values
> > > of an enum field out of the database.
> > >
> > > I know there are methods to get the field
ns the two rows
SELECT * from test WHERE c BETWEEN 1 AND 2;
-- fails, 0 rows returned
MyISAM tables on v. 3.23.45.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
ue3')", and I can parse my
> possible values out of this with regexp's in the Programming language of
> my Choice, but I am interested to know if there isn't a more "beautiful"
> possibility where Mysql gives me back the result direct.
SELECT DISTINCT e
nyone else encountered this problem?
You do not tell us which MySQL version you're using. Some
of the early 3.23 versions had some problems with the
SUM()/other group functions. They should have been
resolved with v. 3.23.09.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of t
the following error:
>
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
I wonder when the mysql team will get around to
changing that message...
- Don't use '-p
datadir=/usr/lib/mysql
...
or on the command line in your startup script:
mysqld --datadir=/usr/lib/mysql
4) restart mysqld.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
>
> -Original Mess
> mysql> CREATE DATABASE mynewdb;
> ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
> mysql>
[carsten@tsort carsten]$ perror 28
Error code 28: No space left on device
- Maybe clearing up some disk space would h
> It simply won't connect. It just says 'Can't connect to local MySQL
> server through socket '' (111)'
>
> I can connect via terminal so I know MySQL is (at least semi) correctly
> setup.
>
> Any ideas?
http://www.bitbybit.dk/mysqlfaq/
> Hello,
> I am interested in knowing :-
> 1) The maximum number of tables possible in MYSQL Database
> 2) The maximum number of columns that are in a table.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.
OR 1030: Got error 1 from table handler
>
> This happens when I do an order by in the sql statement.
Use perror:
[carsten@tsort carsten]$ perror 1
Error code 1: Operation not permitted.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http
> Some how I don't have control over mysqld as root. It starts on
> boot, but I
> am unable to stop it to reset root password. How can I correct this?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk
value for that particular connection.
So I don't really see why this would matter.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please
; [TCX][MYODBC]Can't connect to MySQL server on
> 192.168.1.20 (10071)(#2003)
More likely, it's a permissions problem. Try
reading
http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer
c, so each computer
will receive only the value that it generated.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> Thanks / Henrik
>
> ---
>
> create table MySequence ( nextval int(10) not null default
rrect permissions. More info:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
sec. 4.2.4 - 4.2.10 of the manual
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
www.mysql.com/doc/S/e/Secure_connections.html
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php
ll help you, unless you
take a good look at the other issues above.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.
> Hello,
> them, will the command line over ride the settings in the my.cnf,
Manual sec. 4.1.2: "Options specified on the command
line take precedence over options specified in any
option file. "
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.d
elp ? thanks
Sounds like a file permission problem. Does the
user running mysqld have the correct permissions
on the directory containing host-bin.1?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---
ed, but subselects aren't. So you can use IN with
a value list, i.e.
select count(*) from user where user.ID in (4, 101, 1000);
but not in the context you describe.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlf
> I would like to know how to create mysql.sock I destructed...
Restart mysqld
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, ple
see any reason that I can't connect to this MySQL
> server from
> a remote site.
How were the entries created? Using GRANT ... or by editing
the user table directly? In the latter case, did you remember
to FLUSH PRIVILEGES?
/
et the data by client or connection.
I'm curious as to *why* you're doing this. For billing?
In that case the data traffic is a lousy metric for
how many resources each client is hogging. The complexity
of the queries is by far more important than the amount
of data moved.
/ Carsten
--
l#ch7_26_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
ersect isn't implemented either?
Same procedure gives you (very first hit, too):
1.9.3 Things That Have to be Done Sometime
...
MINUS, INTERSECT and FULL OUTER JOIN. (Currently UNION (in 4.0) and
LEFT OUTER JOIN are supported)
> Hi all,
>
> Is there anyway to delete the duplicate records in mysql
> without creating new tables. I am wondering what query
> will achieve this task where mysql doesnt supports like ROWID and
> sub queries.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
/ Carsten
--
C
formation on both.
> Please provide any leads you may have. The
> permissions on the description_file is 777.
What about the rest of the path? Is that readably by MySQL as well?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL
to return
the number of matched rather than affected rows.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.c
be
> either a documentation or software bug.
It's a documentation bug. Although not on the list of reserved
words, the manual does say:
---
6.2.1 Numeric Types
... and the keyword DEC is a synonym for DECIMAL.
---
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of t
ege tables. Use the GRANT
and REVOKE commands instead. You might also want to read
http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
ly extended to other DBMSs, the UI
part of the book is very narrowly scoped on the use
of Glade and GTK+.
Full review at:
http://www.bitbybit.dk/mysqlfaq/MySQL-BUI.html
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.
> On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote:
>
> > > PRIMARY KEY
> > > (`collection_id`,`document_id`,`tcml_field_id`,`order_number`),
> > > KEY `collection_field_value`
> > > (`collection_id`,`tcml_field_id`,`value`(12)),
>
an't make use of the PRIMARY KEY -- as the document_id
part breaks any chance MySQL has of using the indexed
collection_id-tcml_field_id relation. Try either adding a
new index on just collection_id, tcml_field_id (and maybe
value), or simply re-define your PRIMARY KEY so th
tandard SQL terminology: a set of Columns in a Table,
whose values ("key values") are unique when taken together...
[2] In everyday speech: a set of not-necessarily-unique values,
especially values stored in indexes ... which can be used to
search particular rows of a Table. Both [1] an
t; enhanced
SQL support allows for it.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php
only be one auto column and it must
> be defined as a key
The following should do the trick:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_12_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
h
> Is a boolean column type possible in mysql? If not, what's the
> most common
> column type for true/false (or true/false/null) flags?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_16_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://w
t@localhost' (Using password: YES)
Try running w/o -p
> is there any way to change/reset the password if any or am i doing
> something wrong ?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.
ch row is limited to about 64k. TEXT/BLOB fields only count
towards this limit with 1-4 bytes; a VARCHAR uses the L+1 bytes
as you write.
I assume that there is a small speed penalty in using TEXT/BLOB
fields, as compared to VARCHARs.
n one column and not on a combination of columns. If I
> am wrong please correct me.
You're wrong :-)
mysql> CREATE TABLE tablename (col_a int not null,
-> b int not null, PRIMARY KEY (a, b));
> I am looking for work arounds.
No need to...
/ Carsten
--
Carsten H. Pedersen
a way of doing this?
At this time, no - not using MySQL directly. If you're
using some program to interface w/ MySQL, I would suggest
picking up the targettable.id's, collecting these in a
comma-separated list and use a query like:
DELETE FROM sourcetable WHERE id IN ().
/ Carsten
--
Cars
> Can you rename a database? If so, how does it handle all the
> tables inside it?
By shutting down the server, renaming the directory
of that database and restarting the server.
The server will be able to handle the change just fine.
/ Carsten
--
Carsten H. Pedersen
keeper and main
ds.
>
You're pushing a bit past the limits...
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
o do with file size -- disks
are random access devices.
> But, it is all explaind in the manual :)
Exactly where in the manual did you find that piece of information?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL
. See the CREATE TABLE /
ALTER TABLE commands in the manual. This would prevent
you from inserting any duplicates.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---
mance reason to use or not to use
> choice 'a'?
I think Bob Hall has the answer to your questions.
Here's a link to his excellent guide on MySQL SQL:
http://users.starpower.net/rjhalljr/MySQL/sql.html
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.d
d
> in the source distribution.
>
>
> Since the source is 11 MB and I have no other need for it, I wonder if
> there's another source for this documentation.
http://arglist.com/regex/
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bit
> > section 6.4.1.1:
> > ...
> > INNER JOIN and , (comma) are semantically equivalent. Both do a
> > full join between the tables used. Normally, you specify how
> > the tables should be linked in the WHERE condition.
> > ...
> > Carsten H. Pedersen
>
e documentation
section.
Alas, they have chosen not to do it, maybe
because it's not maintained by MySQL AB.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
be linked in the WHERE condition.
...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (the
> How do you change the order of columns in MySQL tables? I assume the
> tables have a concept of column order, since the DESCRIBE command always
> lists the columsn in the order in which they were created.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_5_0
/ Carsten
--
Carsten H.
first.
>
> How can I do this?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_20_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, pleas
> What GUIs exist for MySql and which is the best to use?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_1_0
lists most of them...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysql
> Does anyone know how to turn that annoying beeping off in the text mode
> utilities such as mysql.exe?
Cut the speaker cable.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/my
houldn't you require b.status to be 's' as well?
> Also, even though all of the fields are indexed, the query takes up to 12
> minutes to complete!
I'm not surprized -- you're forcing MySQL to calculate
date_add on every single one of the 300,000 rows. Indexing
doesn
'single quotes' but neither
> work. Can this be done?
Try using backticks (`) instead. AFAICT, this should
work with MySQL. Using such a naming strategy will
also have the added advantage of making your application
almost impossible to port in the future...
/ Carsten
--
Carsten
1_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
gt; ISAM tables also returned a "Duplicate entry" error when I hit
> the max. Was this "feature" eliminated?
I missed the start of this discussion, but maybe the following
explains what's going on...
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_5_0
/ Carsten
--
Carst
extraneous
mysql_free_result() which caused the next call
to mysql_store_result() to segfault. Why these
did not cause any problems on the test machine
is beyond me.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> I'm having som
of PASSWORD().
Another good reason not to do this: At startup, mysqld reads all
privileges for all users into memory - and they stay there whether
or not those people log in. Seems to be a pretty stupid way of
using up your RAM
> off list. 2.2megs
> I do not have any mdi, or mdy files for the database yet.
Those are ISAM files. If they were created on another OS, you're
out of luck. Only MyISAM files may be moved between different
OS's.
/ Carsten
--
Carsten H. Pedersen
keeper and mainta
n??
Correct. Table names may contain numbers, even start with
numbers -- but cannot consist solely of numbers.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
CREATE or ALTER statement that you use, and
don't forget to tell us which version of MySQL
you're using.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
I'm having some trouble moving a C application from
a test machine to production. The program, which uses
the small wrapper around mysql_query() shown below, runs
flawlessly on the test machine (hours of runtime; tens
of thousands if not a million+ queries).
On the production machine, the progr
think anyone is willing to read what amounts to two or
three printed pages before starting posting. Human beings are simply
too lazy to do that, especially when sitting with a problem they
need solved yesterday.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL
Oct. *1997*.
Exactly *how* old is your copy of MySQL ??
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
http:/
> Anyone know where this perl script is? I've got a lot of excel files to
> convert to MySQL. Thanks!
Search for "excel2mysql" on google, there are several
results. If you can't follow the link, use the Google
cache copy instead :-)
/ Carsten
--
Carsten H
.
It's actually quite fast, and adds the advantage
that you can off-load the temporary copy (i.e.
the dump files) to another disk - which was
an important issue in our particular case.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybi
ell on this page:
http://users.starpower.net/rjhalljr/MySQL/sql.html
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please check:
htt
1 - 100 of 183 matches
Mail list logo