]
basedir=c:/mysql
datadir=c:/mysql/data
tmpdir=c:/mysql/temp
Restarting the MySQL server, it will start with exactly the options as
before.
Next step, you can experiment with different settings ...
Read more: http://www.mysql.com/doc/en/Command-line_options.html
Regards,
--
Stefan Hinz [EMAIL
| --
| 31494.998931885 |
+-+
2 rows in set (0.00 sec)
What query should I use to do this?
I leave this one to Paul or one of the other gurus.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
to transform your MySQL data into HTML in the
online documentation: http://www.php.net/docs.php
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original
Nedim,
I am new to MySql. I need to obtain information about tables including
the
names and types of each column, the primary keys etc.
SHOW TABLE STATUS;
To see only tables starting with t: SHOW TABLE STATUS LIKE 't%';
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
Regards,
--
Stefan
.)
HTH,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: M A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 19, 2003 7:48
: http://www.php.net/manual/en/ref.mysql.php
I leave formatting the output up to you ;-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message
statement (same with phpMyAdmin):
mysql select 5 - id from test;
+--+
| 5 - id |
+--+
| 18446744073709551611 |
+--+
1 row in set (0.00 sec)
Check the 1 in your 15. Maybe there's something wrong.
Regards,
--
Stefan Hinz
, like in
http://www.mysql.com/doc/en/Common_errors.html#IDX1753) error numbers
with their appropriate error messages?
(filter fodder: sql, mysql)
TIA,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30
in your browser, like http://localhost/phpinfo.php, and it should
tell you if MySQL support is enabled.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
this in the documentation.
Primarily, this is a feature for ODBC applications like MS Access. I
don't know of any other app that really longs to have a primary key for
each table, but if there were such apps, MySQL would act as described in
the manual (with or without ODBC).
Regards,
--
Stefan Hinz [EMAIL
guru on the list has a more precise information?!
P.S. I lived/worked in Berlin 1984-85 developing an RDBMS for
Siemens on a joint project w. Intel. It never reached the
market. Great City!! I miss alt bier.
:-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH
,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stefan Hinz [EMAIL PROTECTED]
Cc: Sergei Golubchik [EMAIL
| Avg_row_length |
+---+++--++
| myrowisam | MyISAM | Fixed | 109 | 11 |
+---+++--++
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr
Cesar,
your PHP problem is here:
$query1 = SELECT * FROM r2k_admin WHERE adminuser = $user;
It's supposed to be WHERE adminuser = '$user' , because $user is a
string.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
|
+---+++--++
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED
Avg_row_length: 20
Well, isn't the row length supposed to be 2 (not 20)? I mean 1 byte for
the character 's', plus 1 byte to store the length.
BTW, the manual doesn't say anything about internal uses of additional
bits/bytes, AFAIK. Thanks anyway.
Regards,
--
Stefan Hinz [EMAIL PROTECTED
. e. 'user'@'machine', and not - as in most
other DBMS - only as 'user'. What the manual says about it, is: The
simple form user is a synonym for user@%.
Details: http://www.mysql.com/doc/en/GRANT.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http
it?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Stefan Hinz [EMAIL
Dear all,
can anyone point me to a reference regarding the Com_ status information
you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and
Google groups, but nothing.
TIA,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6
INTO categoryRelatedToProducts /* great table name ;-) */
(categoryRelatedToProducts.fgNumber) SELECT products.fgNumber FROM
products;
is what you might want to do.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel
| ---
+--+---+
2 rows in set (0.01 sec)
Why is Aborted_connects incremented at all? And why is it incremented by
3?
sql,mysql for the filters
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30
doctor ...
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Jennifer Goodie [EMAIL PROTECTED]
To: Stefan Hinz [EMAIL PROTECTED
|
+-+++--++
| myrowisam | MyISAM | Fixed | 68 | 11 | ---
TIA,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
/String_functions.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Haisam K. Ido [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday
will find a number of MySQL servers in the bin/ directory (e.g.
c:\mysql\bin). If you start mysqld, you will have no InnoDB tables
activated, and thus no foreign key support. To enable InnoDB, you will
have to start mysql-max (or, on NT systems, mysqld-max-nt).
Regards,
--
Stefan Hinz [EMAIL
for details.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Ahmed S K Anis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday
' INTO TABLE t;
ERROR 1148: Das used Kommando ist mit dieser MySQL Version nicht erlaubt
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From
(). If this
is not the case, I'm quite sure (if no one here disagrees ;) that PHP 5
will.
And I'm really sure that it will always be called mysql_connect() in
PHP, just to keep things easy.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
the privilege changes. You need another statement for this:
FLUSH PRIVILEGES;
This will force the server to reload the grant tables, and thus, the
privileges.
Details: http://www.mysql.com/doc/en/User_Account_Management.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO
means you will have to
use UPDATE to insert the data in pieces.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Herbert
Christopher,
030111 13:41:11 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
Did you run the install_db script? If not, MySQL can't find the grant
tables.
See http://www.mysql.com/doc/en/Post-installation.html for details.
Regards,
--
Stefan Hinz [EMAIL
,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED];
[EMAIL
it's a MySQL on Win bug with the
4.0.x versions mentioned above, and it might also affect 3.23 version
after 3.23.49.
My advice is: Update, MySQL 4.0.7 is real funky :)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
my_database exists
on your QA machine, but has no tables in it):
c:\mysql\bin mysql -uusername -ppassword my_database
c:\mysql\my_database_export.sql
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49
value would be
1+1. Anyway, we know what the manual wants to tell us, so sorry for
being precocious.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
and 4.0.7 binary
distributions), LOCAL will not work at all. This is a bug, not a
(security) feature.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original
the MySQL server:
set-variable = lower_case_table_names=0
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Nick Stuart
reported the same thing with SuSE
Linux. (No one had an explanation or a solution for this.) Which OS do
you have?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
] option for the
mysql CLI to turn it on, but it only mentions --local-infile=0 for the
server to turn it off. To me, this looks like --local-infile=1 was
intended to turn LOCAL on again, though the manual doesn't mention it.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect
. Imagine an ISP giving
every customer write privileges for the mysql/bin directory ... ;-/
Unfortunately, Monty did'nt mention if this is fixed in 4.0.8 or going
to be fixed in 4.0.9 or 4.1. Personally, I regard this security
improvement rather a bug than a feature.
Regards,
--
Stefan Hinz [EMAIL
then is auto-incremented, and thus becomes 1.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED
:
Server version: 4.0.7-gamma-max-nt-log
OS: Win2K SP2
Maybe worth mentioning, a database 'footable' doesn't exist on my
machine. Double-checking this, I found out it doesn't matter if a
database exists or not. Bug #2 happens with database 'test', too.
Regards,
--
Stefan Hinz [EMAIL
Enclose table and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
not work at all!
I wonder if - finally and hopefully - someone from MySQL will reply to
the LOCAL problem mails, and tell us what to do (maybe there's a
workaround), or when the problem will be solved.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Richard,
I agree with the post... I feel there should be an inbuilt backup
routine.
AFAIK there's going to be a hot backup routine build into MySQL 4.1. At
this moment, my net connection has gone done, but you should find it at
http://www.mysql.com/doc/en/News-4.1.0.html.
Regards,
--
Stefan
from SQL Server to MySQL, and they miss this
feature quite a bit.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Paul DuBois
of table2 (the big one) to find out which
rows match.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Rob Taft [EMAIL PROTECTED
Win2K).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Francesco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED
/Post-installation.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Stefan Hinz
privileges. You'll find it at the bottom of this mail.
Maybe this can fix the other bugs you reported, too.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
this in MySQL :(
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Jon Bertsch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Nuno Lopes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January
Kevin,
I have a table with an ID column and a viewed column. I would like the
viewed column to increment by one each time the row is updated.
Stats
===
ID
views
UPDATE Stats SET Views = Views + 1 WHERE ID = (selected row)
Or is there more behind this question?
Regards,
--
Stefan
,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 2:07 PM
suggest you start with MyISAM, and if you find out it doesn't
(optimally) fit your needs, you can still switch to InnoDB.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
Anton,
first thing, try:
ps [whatever options] | grep mysqld
The daemon (database server) is called mysqld, not mysql.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
|
++
Isn't that what it's supposed to be?
Is it maybe something simple stupid like different data in your table?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
is exactly what I get under Windows when the
server is down.
To start the server: c:\mysql\bin\winmysqladmin.exe
You can also try: c:\mysql\bin\mysqld.exe
Then start c:\mysql\bin\mysql.exe, and you should get a connection.
À bientôt,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO
info here:
http://www.mysql.com/doc/en/safe_mysqld.html).
For a test, you can simply start the server like this:
# mysqld
AFTER THAT you connect to the SERVER using the CLIENT tool mysql.
Hope this gets you running,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http
. This was poorly thought
out and poorly implemented.
Any hints how to make LOAD DATA LOCAL work in spite of this
improvement?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49
set it up at http://justpickone.org/? (BTW, I like
your website, especially the PIX :-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message
for mysql_fix_privilege_tables, and it found nothing!
Guten Rutsch
Danke, Dir auch!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message
of my time tracking down this
annoying security improvement -- thanks but no
thanks, MySQL developers. This was poorly thought
out and poorly implemented.
Any hints how to make LOAD DATA LOCAL work?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
for subscriptions, too.
Great. We should discuss everything else via this list, then.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From
, show database etc.
All the manual (and the user notes) are telling me is that I have to run
the mysql_fix_privilege_tables script. But where can I find it? It's not
in the MySQL Windows distribution.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http
Dear Thomas,
you may want to take the queries from the
mysql_fix_privilege_tables shell script and run them
manually.
Thanks! If only I could find this script ...
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
be half as good.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
-
Before posting, please
suppose :(
Maybe some of the folks at MySQL AB will read this and come up with a
database structure for the FAQ on MySQL.com and user accounts for you
and me (and maybe others, once this thing has started).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http
the server when
installing the update, and I put a copy of my old DATADIR on another
disk.
Any hints are greatly appreciated.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
than VARCHAR.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Philip Mak [EMAIL
of your application (which is
little), I believe there's a problem with your application design.
Splitting up a transaction over two different scripts is IMHO no good
idea.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschaftsfuhrer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
probably the first place a new MySQL user would
look for it.
I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Pikasz,
...then appear the next error and I don't understand why:
Fatal error: Call to undefined function: mysql_connect() in
/var/www/html/vk/vk.php on line 11
Looks like MySQL has not been enabled in your PHP installation. Check
with phpinfo() to find out.
Regards,
--
Stefan Hinz [EMAIL
David,
Or is there perhaps a RENAME DATABASE command (I saw RENAME TABLE)
in MySQL 4.1, you will find ALTER DATABASE:
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News
-4.1.0
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http
which would make it a more complicated
task?
If you don't want all rows from the source table you can use WHERE
and/or LIMIT.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
/contact/mysql/, find out the telephone number and
give them a call. At least it's toll free :)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original
with sigwait() or if one wants to use the thr_alarm()
code in ones application without a dedicated signal handling thread.
Link to this manual part: http://www.mysql.com/doc/en/MySQL_threads.html
So, I guess all it means is that the thr_alarm queue is full ;-)
Regards,
--
Stefan Hinz [EMAIL
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 25, 2002 12:10 AM
(BRegards,
(B--
(B Stefan Hinz [EMAIL PROTECTED]
(B Geschaftsfuhrer / CEO iConnect GmbH http://iConnect.de
(B Heesestr. 6, 12169 Berlin (Germany)
(B Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
(B
(B- Original Message -
(BFrom: "kayamboo" [EMAIL PROTECTED]
(BTo: &
first ('%' in the Host column means ``any
host'' and is least specific).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From
find the default values for caches and other options here:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
I wish you and all the others on the list a Merry Christmas!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
MySQL 3.23.54 which fixes these
vulnerabilities.
/cite
Doesn't look like the MS way to me. See for yourselves:
http://security.e-matters.de/advisories/042002.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
));
This will only make sense if the first 10 characters can tell the difference
between different records. If not, you can experiment setting the index size
to 20, 30, ...
I hope this will give you some ideas on how you can improve performance.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO
ON custid = customerid
WHERE shipmentid IS NOT NULL
or:
SELECT custid, name FROM customers INNER JOIN shipment ON custid =
customerid
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0
on
the column in question.
I called this effect pre-sorted comparison, but maybe someone else will
have a better explanation.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30
standard should be punished with a life sentence, cleaning up our customer's
mess ;-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original
to be an executive summary overview so that it didn't my
eyes bleed, though :-)
Why don't you start here:
http://www.mysql.com/documentation/mysql/bychapter/index.html#Column_types
;-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
150 (unknown error). Commenting
out the FOREIGN KEY lines solves the problem, but then again, I have no
f.k.restraints :(
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
sing_InnoDB_tables
Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimisation. Table and index reserved
sizes in bytes are accurate, though.
HTH!
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
, but the response is can't create
'.\projekt\teilnehmer.frm' with error 150 (unknown error).
I had the same problems with 4.0.4 on Win2K.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax
:Not in use
Server version: 4.0.5-beta-max-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
I can even use the pipe and socket option to mysql, and it will still use
TCP/IP ... Can someone explain this?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO
!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL
Dear Satish,
Thank you for your help.
Your welcome.
I used MyODBC 3.51, and successfully migrated to MySQL.
Is this a MySQL user stories case, or just a small migration?
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
for
the inconvenience
Has anyone observed something like this before? I keep getting unsubscribe
mails from the list (at least five times this month only).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
was 500 MBytes, and it took 4 minutes on a 2 GHz machine running Win2K
(table create definition and import of all data).
HTH,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30
and is very likely
to change in the near future (when you can configure/use multiple charsets).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original
this transaction safe, you can use InnoDB tables. Issue BEGIN
before the SELECT statement and COMMIT after the UPDATE statement.
HTH!
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
installation). Import your own backuped data as follows:
shell mysql -uroot mysql_db.sql
This will install your old grant tables, too, overwriting the newly
installed mysql database.
Now, everything should be in the same state as it was before you downgraded.
HTH!
--
Stefan Hinz [EMAIL
have an even trickier solution, e.g. some registry entry).
HTH!
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Daevid Vincent
there
are lots of installations in production environments that have proven
stable) is August 2003. Any other guesses? Monty? ;-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
CEO / Geschäftsleitung iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49
301 - 400 of 504 matches
Mail list logo