hallo,
I try to skip logging on three special databases where a couple of
otherdatabases
should log their update in te binlog-file. The options in the
my.cnf-file
log-bin= /www/cmsdata/log/bin-log
binlog-ignore-db = db_1,db_2,db_3
don't work. Has anybody a solution?
I use mysql
- Original Message -
From: "Trask" <[EMAIL PROTECTED]>
> I'm trying to configure MySQL and PHP so that PHP can access MySQL for
> function calls and database access. It's my understanding that I need to
> use the command - "mysql_connect(, , );"
>
> I tried that and got a syntax error, I
Hi,
I'm trying to configure MySQL and PHP so that PHP can access MySQL for
function calls and database access. It's my understanding that I need to
use the command - "mysql_connect(, , );"
I tried that and got a syntax error, I tried:
[root@www phpBB2]# mysql_connect(localhost, root, mypassword
I am planning on setting up mysql server on a Mac OS 10.2.2 Server running
on a Xserve machine. It will be a development system for now, but I still
want end up with a good usability status. The server will run Perl, PHP,
Apache/Tomcat, Mysql to start with.
Are there any recommendations or experie
I am a grad student attempting to complete an assignment to research a DBMS
engine. Is the SQL implemented by MySQL based on relational algebra or
relational calculus? And if it's relational calculus (which I suspect it is
based on an archive search), is it tuple or domain calculus?
Thank you fo
Hi, mysql
I want to put a image into mysql database,but when I run program listed
below
<%
formsize=Request.TotalBytes
formdata=Request.BinaryRead(formsize)
set rs=server.CreateObject("adodb.recordset")
strconn="driver={mysql};dbq="&server.MapPath("test.mdb")&";uid=root;pwd=l05m;"
sql="SELE
John Ragan wrote:
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id > 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
I don't really know how LEFT JOINS, INNER
> Im running the following query:
>
> SELECT
> user.nickname,
> user.id,
> user_detail.points
> FROM
> user,
> user_detail
> WHERE
> user.details = user_detail.id
> AND user.id > 101
> AND user.language = 'en'
> ORDER BY user_detail.points DESC
> L
--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 15:18, Hans Zaunere wrote:
>
> > Because it seems ineffncient to me, as MySQL must be doing more work to
> > calculate the range. Even EXPLAIN tells me this, by showing that a
> > less-than-optimal TYPE is being used. Although "
When you try to run WinMySQLAdmin.exe
on a system running WinNT4.0 Sp6a, you get
an alertbox telling you a missing reference to
CreateToolhelp32Snapshot in kernel32.dll.
Using the MS-Tool DEPENDS.EXE on a system
running WinNT4.0 SP6a it can be seen that
at least the latest mySQL-build 3.23.53 con
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
> -Original Message-
> From: Alex Behrens [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 22 November 2002 13:01
> To: MYSQL
> Subject: date convers
Hey All,
I'm storing date values for hockey game information using the DATE value and
they are stored as MMDD and when I retrieve them from the database they
are shown as: "2002-11-23" I was wondering if there was a way to have them
converted to November, 23, 2002 when they are displayed on my
Keith Spiller wrote:
> I am trying to figure out how to use the NOW() function with a MySQL
> Insert command on a Timestamp field.
Okey, either use NOW() on the DATETIME field, or use TIMESTAMP field
without inserting there value.
> Here is my mysql command:
>
> INSERT INTO $tablename
> (sender,
> INSERT INTO $tablename
> (sender, recipient, whenread, whensent, subject,
> messagetext, folder, priority, condition)
> VALUES
> ('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
> '$MessageText', 'Inbox', '$SetPriority', 'TO')
Easy as that!
j- k-
mysql, sql
--
Jo
Hello,
I am trying to figure out how to use the NOW() function with a MySQL Insert
command on a Timestamp field.
Here is my mysql command:
INSERT INTO $tablename
(sender, recipient, whenread, whensent, subject,
messagetext, folder, priority, condition)
VALUES
('$directorid', '$SendTo', '
We are trying to setup the following MySQL replication
MSSQL Server - Push replication to Server 1
Server 1 - (Receives push replication from MSSQL and is Master MySQL for
Server 2)
Server 2 - (Slave to Server 1, Master for Server 3)
Server 3 - (Slave to Server 2)
Okay to make a long story s
Hi,
Yes it works, but you can't insert and select data from the same table with
this syntax.
Regards,
Jocelyn
- Original Message -
From: "Mirza Muharemagic" <[EMAIL PROTECTED]>
To: "Eric" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 12:30 AM
Subject: Re: I
Hi Eric,
thats oracle function INSERT INTO ... SELECT. it doesn't work in
mysql.
Mirza
[EMAIL PROTECTED]
__
21.11.2002 22:13
> Hi,
> This should work, I think, but doesn't
> INSERT INTO holds (ord_num)
> SELECT orders.ord_num FROM orde
--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
>
> > I've played around with a couple different methods, but the only way I
> can
> > see to use the INDEX (according to EXPLAIN) is doing a query along the
> > lines of:
> >
> > ... WHERE thecolumn B
Dan, thanks for your reply.
When I changed the table definition to use the single index and
the multi-index I reloaded the data from scratch each time.
(I did the trials many times from scratch just to be sure and I
do get consistent results)
I also just did an optimize table as you suggest o
On 21 Nov 2002, at 15:18, Hans Zaunere wrote:
> Because it seems ineffncient to me, as MySQL must be doing more work to
> calculate the range. Even EXPLAIN tells me this, by showing that a
> less-than-optimal TYPE is being used. Although "WHERE thecolumn =
> '2002-11-17'" doesn't yield any resul
In the last episode (Nov 21), [EMAIL PROTECTED] said:
> Adding an irrelevant second column to an index instead of just a
> single column index gives an incredible speedup and I don't know why!
If you then remove the index, is it still fast? Maybe you are just
seeing the results of mysql rebuildin
On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
> I've played around with a couple different methods, but the only way I can
> see to use the INDEX (according to EXPLAIN) is doing a query along the
> lines of:
>
> ... WHERE thecolumn BETWEEN '2002-11-17' AND '2002-11-18'
You don't explain what you
At 04:41 PM 11/21/2002 -0600, Robert Citek wrote:
>So, now I know that "repair with keycache" is slower than "repair by
>sorting." What can I do about that? That is, how can I make the repair
>use sorting? I would have thought they would be part of the "alter table
>..." syntax, but I haven't
Hello,
Adding an irrelevant second column to an index instead of
just a single column index gives an incredible speedup and
I don't know why!
(server version: 3.23.53a running P133 32 megs ram - not a speedy
machine)
I have a bunch of records with the relevant columns being:
idbigint
At 22:40 + 11/21/02, Jannie Qu wrote:
Hi, paul,
I got some error when using:
mysql> set foreign_key_check=0;
ERROR 1064: You have an error in your SQL syntax near
'foreign_key_check=0' at line 1
mysql> select version();
+-+
| version() |
+-+
| 3.23.53-log |
+--
Hello Jennifer,
Thanks for your reply.
At 02:07 PM 11/21/2002 -0800, Jennifer Goodie wrote:
>http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
I guess I have an older/different version of the doc's. I was using the
version that came with the Windows install of MySQL. Thanks for the URL.
>Rep
I have a DATETIME column, indexed, which I store both a date and time in, as
expected. However, I often want to select all rows for a given date,
regardless of time.
I've played around with a couple different methods, but the only way I can
see to use the INDEX (according to EXPLAIN) is doing a q
At 22:10 + 11/21/02, Jannie Qu wrote:
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert
back into production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the
following command at production.
shell> mysql -ujq
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert back into
production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the following
command at production.
shell> mysql -ujqu -pjqu1234@ dbname < bkp_dbname.sql
File
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Repair with keycache - The repair code is using creating keys one by one
through the key cache. This is much slower than Repair by sorting.
It is going to take a long time to build an index on a table that big,
especially if you still have questio
http://www.mysql.com/doc/en/INSERT_SELECT.html
You cannot select from the table you are inserting into. Insert into a temp
table and then insert into holds from that table.
-Original Message-
From: Eric [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 1:14 PM
To: [EMAIL PROTE
Thanks to all you for helping me, I still can't connect, but now i know that
it is an issue of the delphi. I'll keep trying and researching.
Patricio
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 1:07 AM
S
I don't know about "incorrect", but confusing, sure. It is easy to
predict what is going to be returned based on the documentation.
On Thu, 2002-11-21 at 14:19, Joe Siegrist wrote:
> I don't agree that mysql is 'right' here though, I realize that if you
> simply strip out the year for the date i
Hello all,
What does it mean to be in the "Repair with keycache" state, and how do I
fix this?
I am running MySQL v3.23.36 on a Red Hat 7.1 machine. One of my tables has
about 21,000,000 (21 Million) records in it. I am trying to index one of
the fields with the alter table command:
mysql> a
>> PHP handles this correctly -- if I do a date("W-y", $date)
>> for '2001-12-31'
>> I get '01-02', but in mysql you get the wrong year: '01-01'
>
>I don't know where you got this data from, but the second number would be
the year, that means mysql is showing the right year and php is showing the
> PHP handles this correctly -- if I do a date("W-y", $date)
> for '2001-12-31'
> I get '01-02', but in mysql you get the wrong year: '01-01'
I don't know where you got this data from, but the second number would be the year,
that means mysql is showing the right year and php is showing the wr
Mysql gives what I'd call incorrect output when outputing week and years at
the end of the year.
PHP handles this correctly -- if I do a date("W-y", $date) for '2001-12-31'
I get '01-02', but in mysql you get the wrong year: '01-01'
Here's the an example (the second one is not what I'd expect):
Hi There,
In my ongoing project one of my application is
building reports and Printing them from a Remote
access Machine..
Actually i have done the whole project in ASP, IIS,
Access-2000. but the problem is IIS has Restricted
number of users(10) on WIN 2000 prof.
So, instead of buying an MS Serve
How do I set the cache limit? Any suggestions on optimizing mySQL?
At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote:
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated d
Hi,
Can anyone tell me how to set the following parameters in mySQL 3.23? I'm
new to MySQL and am setting up a BBS. MySQL is installed and running OK.
Database Server Hostname / DSN:
Database Name:
Database Username:
Database Password:
Prefix for tables in database:
--
Victoria,
So I looked deeper in my PHP code (I wrote it in February 2002) and saw
I use a REPLACE statement:
class persistent
{
// put method to save properties into the DB
function put($thePrefix)
{
// job no
What causes the following error and what can I do to keep it from happening.
mysql:Out of memory (Needed 5961744 bytes)
The number of bytes needed varies. The error sometimes occurs when sending a large
number of INSERT requests using batch mode, e.g., mysql -u user -h hostid <
file.with.lots.o
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id > 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
It basically lets me know the top 5 contributors to my website.
You have to send the SELECT queries directly to the slaves. Your code
must know to connect to an appropriate machine for the type of work it
wants to do: If it's only reading data (SELECTs), it should connect to
one of the slaves. If it must alter data (INSERT/UPDATE/DELETE) or must
both read AN
Even if you have more than 4 Gb of physical RAM, a single process
cannot address more than 4 Gb of memory (a P4-Xeon is still a
32 bits processor :( ). You have also to take into account that
a process cannot use these 4 Gb for data since some memory is
used for code, stack,... The exact amount ava
Just a small comment to this thread:
If you follow this link you'll see that you are searching on two words which
both are only two chars long.
Just press the 'søk' bottom and you will be doing a search on the
booktitles, in a database containing 1.4mill books, running Mysql
4.0.4-beta.
I dropped
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated database server, it has
only 2 Gb. mysqld itself is using around 600Mb the rest is used
by the OS mainly for file caching
Egor Egorov
Sir, I understand how intimidating the manual may seem, especially when
you are starting out.
Don't give up, and here is a suggestion that I found to help a lot.
(Although some around here might laugh.)
I got a book called MYSQL and PHP for Dummies. It does a fantastic job of
giving
I have an applet and I'm trying to use Connector/ J 3 to connect to my
database.
I have uploaded the applet to my web server.
I have uploaded the mysql-connector-java-3.0.2-beta-bin.jar file to the same
dir as the applet
I have made a reference to the mysql.jar file in the html file like so
But w
Keith C. Ivey wrote:
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.
Apologies if this is off topic ... please let me know what a more
appropriate forum is if so.
Quick question: since there is normally a per-process limit of 4GB on
32-bit linux/intel platforms is there any point to installing more than
4gb in an sql server that is only running running 1 instance
I have a few servers running MySQL and regularly (almost every web page!)
connect from one to the other to update or query a remote database. I have
never had any problems (love that mySQL) until I upgraded one of the systems
and re-loaded the websites etc.
Now, when I try to connect to the new sy
On Thu, 2002-11-21 at 09:47, Johannes Ullrich wrote:
> And more difficult, try to look at your application design and try
> to come up with 'cache tables' that are generated by a cron job
> periodically and are used for most queries.
This is an excellent suggestion and may make you think about yo
I've actually just started playing with full text indexes and have been
following this thread along with searching the internet. I'm not using
MySQL 4 yet, so my options are limited. I do have a need to search on
three letter words (i.e. C++,ASP,AIX,awk, XML).
What I am doing now, which seems to
Juan,
Thursday, November 21, 2002, 12:46:55 PM, you wrote:
JCPG> Iam using MySQL version 4.0.5 in Windows and I want to make a JOIN between
JCPG> two tables that have approximately 20,000 records and 20 columns. As all
JCPG> the records
JCPG> from one of the tables must appear in the result of th
BPF,
Thursday, November 21, 2002, 4:36:58 PM, you wrote:
BW> CREATE TABLE `reg_member` (
BW> `account` bigint(20) NOT NULL auto_increment,
BW> `userid` varchar(48) NOT NULL default 'Your name',
BW> `uilogin` tinyint(4) NOT NULL default '0',
BW> `id` varchar(48) NOT NULL default '',
BW> `password`
>Description:
When mysql is installed via linux rpm file, it does not install
mysqladmin command?
>How-To-Repeat:
just install mysql from redhat linux rpm.
>Fix:
?
>Submitter-Id:
>Originator:MikeL
>Organization:
>MySQL support: [n
> MySQL 3.23.51
> Linux Kernel 2.4.16
> we do have 1 GB of RAM
> the main problem seems to be a table with about 8.597.146 records.
Similar situation here (>100 Million rows).
things I found that help:
- be selective on what rows to index. Try to limit yourself to one
row.
- increase the ke
My delayed_insert_timeout is the default 300 seconds. Why then would I have
DELAYED threads that have been idle for 14+ hours?
+--+--+---+++---+---
-+--+
| Id | User | Host | db | Command
Lars,
uhm, installed that package and it confirms your suspicion:
Total memory: 612 Megabytes
Kernel Memory: 60 Megabytes
Application: 89 Megabytes
Executable & libs: 32 Megabytes
File Cache: 419 Megabytes
Free, file cache: 6 M
I am in college and doing a comparison of Oracle and
MySQL (term paper). One of the items that must be
included is whether or not they support user defined
data types. What I found on the web is below this my
name and discusses Oracle8, which would indicate the
article is old. Has anything chang
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
> When I make the LEFT JOIN between the two tables, it takes a long time,
> and it seems that the machine is crashed , because everything I try to make
> in the machine is extremely slow, so I have to reset it manually.
Do you have indexes on t
Thanks. I'll try immediatly.
-Messaggio originale-
Da: Johannes Ullrich [mailto:[EMAIL PROTECTED]]
Inviato: giovedi 21 novembre 2002 16.17
A: Massimo Bandinelli
Cc: [EMAIL PROTECTED]
Oggetto: Re: R: R: Mysql Replication
> I have an hosting server and it contains many domains (100.000).
: )
excellent. i envy you.
i'd noticed the same thing about oracle. seems
to be a resource hog. the only thing worse that
i've seen is ms access. they make mysql look
very efficient.
hate to say much, since it appears that you know
what you're doing, but you might also take a look
at r
I am having 'issues' with MySQL running on Redhat Advanced Server
on a 8 Gigbyte machine (dual P4-Xeon).
After large imports ('load data infile', file size about 1 Gigbyte) into
a large table (20-30 GByte, > 100 Million rows), the database crashes.
I did try several key_buffer_size settings. The
I should have been more specific in my previous post. I am actually after
the syntax to get the data out of a table and into a file. I couldn't quite
work this out from the stuff I read in the manual.
mysql
This e-mail is intended for the reci
Hi Markus,
I just missed something in your original Mail,
I guess its not the mysql server growing to 1gig (check with ps -ely)
its simply the system memory showing no free mem.
If you have root access to the maschine its probably a good idea to
install the prtmem command (ftp://playground.sun.co
le 21/11/02 15:38, Danny Haworth à [EMAIL PROTECTED] a écrit :
> I assume you are using mysql_pconnect()? That way, PHP will reuse old
> connections instead of opening up a brand new one each time.
Now, we do not use persistent connections but me have set thread_cache=25 to
have enough connectio
I took a look at the command but I don't see where you tell
mysql which specific field to use within a specific column. The
rest of the column is fine and I understand the id=# points at the
column that I want.
Thanks for the response btw,
Mike Wendell
At 01:07 PM 11/21/2002 +0200, you wrote:
Renaud Raffier wrote:
Hello,
I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49.
All messages are stored in one table (850 000 messages) and I have some
other tables but smaller. My posts table is 500 Mo large, index is also big
because of full text index.
I now have problems
My problem is this:
I have an hosting server and it contains many domains (100.000).
It supports php and mysql and I don't want to tell my users to use different hosts for
select and update.
However, thanks.
-Messaggio originale-
Da: Johannes Ullrich [mailto:[EMAIL PROTECTED]]
Inviato:
Sure:
CREATE TABLE `reg_member` (
`account` bigint(20) NOT NULL auto_increment,
`userid` varchar(48) NOT NULL default 'Your name',
`uilogin` tinyint(4) NOT NULL default '0',
`id` varchar(48) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
`joined` bigint(20) default NULL,
`expire
The problem was with the ending record/line break character.
I added:
LINES TERMINATED BY '\r\n'
and the import worked wonderully! And only took a little over ten
minutes to process.
Thanks for the help.
-Original Message-
From: Roger Abrahamsson [mailto:[EMAIL PROTECTED]]
Sent
Hi,
Could you give us SHOW CREATE TABLE your_table ?
Greetings from France too ;)
Jocelyn
- Original Message -
From: "BPF Webmaster" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 2:25 PM
Subject: Duplicate key delete record with same key
> Usin
Lars,
the amount used increases until all free memory is used plus a fair amount of
swap. On a machine with 2GB memory this can well grow up to 1GB.
Any chance to get the current size of the malloc pool to check if this
causes the effect?
thx so far,
Markus
On Don, 21 Nov 2002, Lars Heidieker
Using PHP 4.2.3 with MySQL 3.23.52
Report:
---
- Table has 2 keys: 'account' as PRIMARY and 'id' as unique
- I make an SQL update on an existing a record with id="anid" setting
id="anotherid" but another record exists with id ="anotherid"
- The update is performed and the record already existi
Does the memory amount used increases any further if repeating the dump
import.
If so there is a leak if not you just got fooled by the standard malloc
of solaris which wont return memory free(d) to the system but instead
the memory will be kept in a pool for the next malloc.
Lars
On Donnerst
Hello,
I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49.
All messages are stored in one table (850 000 messages) and I have some
other tables but smaller. My posts table is 500 Mo large, index is also big
because of full text index.
I now have problems with my board: the post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 21 November 2002 13:49, Sönke Ruempler wrote:
> make[2]: Wechsel in das Verzeichnis
> Verzeichnis »/usr/src/mysql-3.23.53/libmysql«
> /bin/sh ../libtool --mode=compile
> ME="\"/usr\"" -DDATADIR="\"/usr/var\""
>
Hello all,
Is there a mysql function that extracts sub matches from regular
expressions. for example in perl when you match a string to a regular
expression like /\s+(\S+)\s+(\S+)/ the submatches (strings matching the
part of the expression between parenthesis) are available in variables
$1, $2
>Description:
Dump several big tables or entire databases with mysqldump, then
import to same or another database with mysql -f db How-To-Repeat:
Dump a database with around 250.000 to 3.000.000 records, record size
is around 200 bytes.
Import dump file and s
> Then, the master write, update, delete, ecc..
> the slaves answer SELECTs
>
> If this is impossible, which is the utility to have slaves???
it is possible. Follow the manual for a good start. A couple
caveats:
- your application has to be able to send the selects to the different
(read only
> i'm running an oracle enterprise server in a test
> environment for corereader, and i've noticed
> that, although oracle sometimes takes a while to
> wake up, after you have its attention, it throws
> data at you very fast. sometimes a developer
> does not use connections properly. in your case
make[2]: Wechsel in das Verzeichnis
Verzeichnis »/usr/src/mysql-3.23.53/libmysql«
/bin/sh ../libtool --mode=compile
ME="\"/usr\"" -DDATADIR="\"/usr/var\""
-DSHAREDIR="\"/usr/share/mysql\"" -DUNDEF_THREADS_HA
CK -DDONT_USE_RAID -I./../include -I../inc
I just want to add that unlike what it is printed ("Download BitKeeper from
http://www.bitmover.com/cgi-bin/download.cgi. You will need Bitkeeper 2.0 or
newer to access our repository."), Bitkeeper 3.x seems to be needed.
Perhaps the manual should be updated :)
Regards,
Jocelyn
- Original M
Mark,
Wednesday, November 20, 2002, 4:52:24 PM, you wrote:
MC> I would like to export the full contents of one particular table in a
MC> database to a csv file once every day. I will then email this file I am
MC> running MySQL 3.21 on a RedHat 7.2 server. Is there an automated way of
MC> doing th
Listen,
Wednesday, November 20, 2002, 7:31:27 PM, you wrote:
LH> thanks for your great advice, finally pointing out the reason for the
LH> problem.
>> SH> mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
>> SH> PRIMARY KEY;
>> SH> ERROR 7: Error on rename of '.\trainee\auftra
On Thursday 21 November 2002 12:58, Daniel Kiss wrote:
> Hi all,
>
> Where can I download MySQL version 4.1 source code?
http://www.mysql.com/doc/en/Installing_source_tree.html
Regards
Georg
-
Before posting, please check:
h
Dobrý den,
quinta-feira, 21 de novembro de 2002, 09:58:47, napsal jste:
IS> Hi all.
IS> The example mysql configuration files included in support-files directory of
IS> MySQL distribution are optimized for MyISAM table type.
IS> I want to tunnig the server optimized for InnoDB because I won't us
On Thu, 21 Nov 2002, Daniel Kiss wrote:
> Hi all,
>
> Where can I download MySQL version 4.1 source code?
Hi,
There are no 4.1 source distributions yet, see this:
http://www.mysql.com/doc/en/Installing_source_tree.html
You need to download the bits via BK.
=
Hi all.
The example mysql configuration files included in support-files directory of
MySQL distribution are optimized for MyISAM table type.
I want to tunnig the server optimized for InnoDB because I won't use MyISAM
table type except for mysql database and *.frm files.
I want to know which vari
> Where can I download MySQL version 4.1 source code?
http://www.mysql.com/downloads/mysql-standard-4.0.html ahhh?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
Take a look here :
http://www.mysql.com/doc/en/Installing_source_tree.html
Regards,
Jocelyn
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 11:58 AM
Subject: Where is 4.1 source
> Hi all,
>
> Where can I downl
Hi all,
Where can I download MySQL version 4.1 source code?
Thanks,
Daniel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Hello, I am new to the list, I've subscribed in last ressort when I couldn't
find an answer, neither the web or the list archives...
I've had a question from a client that I've answered in this way :
"
> One other question, when you have built the
> database, will it be
> expandable to the size fo
Hi,
Suppose my data contain 2 column
column A for code
column B for detail
data like this
row A B
1 100 AA
2 100 BB
3 20
Trystano,
Thursday, November 21, 2002, 2:52:54 AM, you wrote:
Taadc> Hi, this is my first dabble of using MySQL and am having trouble setting a
Taadc> password.
Taadc> I have installed MySQL on Windows XP. I've gone through the manual, but I
Taadc> can't really find how to do it. If you could pos
theapparatus,
Thursday, November 21, 2002, 5:35:04 AM, you wrote:
tandn> I just have a quick question. I've been setting up a
tandn> website using a MySQL database loaded with a large
tandn> number of articles but I'm having a problem.
tandn> Some of the articles did not load correctly into the
Steven,
Thursday, November 21, 2002, 7:29:41 AM, you wrote:
SR> There seems to be nothing in the Manual about a lot of things. For
SR> example, the utilities mysqldumpslow, and mysqlcheck, etc.
As to mysqlcheck:
http://www.mysql.com/doc/en/Using_mysqlcheck.html
As to others you can write comm
1 - 100 of 114 matches
Mail list logo
