Hello all,
On 19 January 2002 09:28, Jeremy Zawodny wrote;
>
> On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote:
> > Hello all,
> >
> > To both above topics there have been answers, thank you, but these
> > answers are not clear at all.
>
> That's because preicting the futu
On Fri, Jan 18, 2002 at 03:12:22PM +0100, Myk Melez wrote:
>
> Is it possible to replicate between two databases on a single
> server, and if not, then what is the next best solution?
It is possible, yes.
> Is there a way to use MySQL's built-in replication to replicate two
> databases residing
hello someone can explain what is database overhead why happen...?
thanks, everton.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote:
> Hello all,
>
> To both above topics there have been answers, thank you, but these
> answers are not clear at all.
That's because preicting the future is rather difficult. It's a fuzzy
system, so there are few clear answe
Hi,
Yes, the reason for the time difference is that for distinct query, as
Sinisa noted, it has to reiterate.
For the output to generate, first the rows have to be ordered ( in this
case since count(*) is given every column
should be present in the comparison.) using a temp table (or any other
On Fri, Jan 18, 2002 at 08:18:29PM +0200, Victoria Reznichenko wrote:
> Hello Steve,
>
> Friday, January 18, 2002, 5:33:38 PM, you wrote:
>
> SS> REALFROM: Steve Suehring <[EMAIL PROTECTED]>
> SS> HOUR: 2002011817
>
> SS> Hello-
>
> SS> I've done some searching through archive and the website
On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote:
> Hello
>
> Time to time I see strange overload of MySQL on dedicated
> server. The server is powerful enough to handle ~ 500 req/s. MySQL
> version is 3.23.40 and runs on Linux 2.4.16-SMP. The overload which
> I mean leds to stop a
Hello all,
To both above topics there have been answers, thank you, but these answers
are not clear at all.
---
On 19 January 2002 00:09, Jeremy Zawodny wrote;
> To: Steve Suehring
> Cc: [EMAIL PROTECTED]
> Subject: Re: Version 4 Schedule
>
>
> On Fri
On Fri, Jan 18, 2002 at 01:11:09AM -0500, James Riordon wrote:
> We have a RaQ4i 400MHz server with 512MB of RAM running
> PHP4.03p1 and MySQL 3.23.43 if memory serves correctly.
>
> We are looking at bringing on a client who uses 1 MySQL
> database and PHP to host a news site simila
In searching for multimedia-content and multimedia related webistes/content we
recently came across your site MySQL | Documentation | MySQL | Full -
http://www.mysql.com/documentation/mysql/full/index.html
MySQL | Documentation | MySQL | Full - http://www.mysql.com/documentation/mysql/full/
MyS
Does anyone have a sample Makefile for building
a simple MySql++ CGI application on Linux (using
appropriate headers and libraries) that they would be willing to
send me (Linux 2.4 kernel) ? The one distributed with the release
doesn't work for me. Any help would be very much appreciated!
Tha
> I am running MySQL on Redhat and when I use the script that
> comes with MySQL
> (mysql.server) or safe_mysqld the command runs and starts the server.
> However; the prompt does not return. I have to switch
> consoles. (bash)
> Does anyone have any idea how I can avoid this? (the script
>
I just install MySQL on my FreeBSD 4.4 box using pkg_add -r mysql-host.
When it finished, it prompted with the info below. It is prompting me to do
a new password so I type in:
/usr/local/bin/mysqladmin -u root -p password 'passwordhere'
and it prompts me for a password. I repeat the password 'pas
I am running MySQL on Redhat and when I use the script that comes with MySQL
(mysql.server) or safe_mysqld the command runs and starts the server.
However; the prompt does not return. I have to switch consoles. (bash)
Does anyone have any idea how I can avoid this? (the script from the rpm is
n
update user set Password = PASSWORD('mypassword') where User = 'myuserid';
http://www.mysql.com/doc/P/a/Passwords.html
C:ya
-Original Message-
From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Change password
Hi:
The adm
Hi:
The administor created a mysql database "library" for me at my home
directry. He didn't set a password for me. I don't know how to set my
password for my database. I tried using:
->mysql library
mysql -> set PASSWORD=PASSWORD('mypassword');
in the command but it didn't work. I need a help!
Hi:
The administor created a mysql database "library" for me at my home
directry. He didn't set a password for me. I don't know how to set my
password for my database. I tried using:
->mysql library
mysql -> set PASSWORD=PASSWORD('mypassword');
in the command but it didn't work. I need a help!
When I try to use MySQL 3.23.38 on my RH7.0 Alpha system, the only way I can
create and access tables is as a root user. BUT --- I don't need to be
logged in as root to become root user, it will let anyone be root with the
command: mysql -u root
I tried granting permissions for users, but it
At 15:30 -0600 1/18/02, Rick Emery wrote:
>Is this a bug? I can't find an answer to this question in FAQs or archives.
>
>CREATE TABLE aa ( a int);
>INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3);
>
>the following :
>mysql> select a,count(*) as z from aa where z>1 group by a;
>
>displa
At 14:20 -0800 1/18/02, Stuart Scamman wrote:
>What is the syntax to make '\\' work with like statement ?
That depends on what you're trying to match. Please specify.
>
>This example is always empty:
>
>SELECT * from table where field LIKE '%\\mydir\\myfile%'
-
'\' is an escape character... so to escape it you must :
SELECT * from table where field LIKE '%mydirmyfile%'
Mike
- Original Message -
From: "Stuart Scamman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 5:20 PM
Subject: Like and '\\'
> What is t
> 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.bitbybit.dk/mysqlfaq
> Is this a bug? I can't find an answer to this question in FAQs
> or archives.
>
> CREATE TABLE aa ( a int);
> INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3);
>
> the following :
> mysql> select a,count(*) as z from aa where z>1 group by a;
>
> displays this error:
> ERROR 1054: U
What is the syntax to make '\\' work with like statement ?
This example is always empty:
SELECT * from table where field LIKE '%\\mydir\\myfile%'
Thanks
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database:
On Fri, Jan 18, 2002 at 09:33:38AM -0600, Steve Suehring wrote:
> Hello-
>
> I've done some searching through archive and the website but can't
> seem to find a semi-concrete answer. What's the schedule, if any,
> for version 4.0 to go stable?
It's stable when the MySQL folks are relatively con
I agree with the below. That you probably won't be able to take advantage of
more than one CPU. Except maybe to off load some OS tasks. But you should not
assume that a 1.4 GHz CPU will be faster than at 900 MHz CPU.
If the 1.4GHz CPU is a Pentium IV and the 900 MHz CPU is a Pentium 3 Xeon. You
You may want to try...
http://www.codebydesign.com/DataArchitect
Its not perfect but its quite useful. Inspired by PowerDesigner.
Peter
On Friday 18 January 2002 12:09, Alok K. Dhir wrote:
> Unfortunately Mascon doesn't have any ER diagramming tools for schema
> modeling. I bought Heraut S
count(*) works if I do not alias it with z, and do not use WHERE clause:
mysql> select a,count(*) from aa group by a;
+--+--+
| a| count(*) |
+--+--+
|1 |2 |
|2 |2 |
|3 |2 |
|4 |1 |
|5 |1 |
|6 |1 |
is there a max row length for MyISAM tables? I'm having a hard time finding
it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Hello,
I'm experincing a problem with my database locking up on some queries.
Any explanation or solutions anyone can provide will be much appreicated.
-
##Scenario: 3 tables: company, co_type_assoc, co_type
##with d
Hi,
Try :
SELECT a,COUNT(*) AS z FROM aa GROUP BY a HAVING z>1;
Regards,
Jocelyn
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 10:30 PM
Subject: Column Alias Bug??
> Is this a bug? I can't find an answer to this qu
Is this a bug? I can't find an answer to this question in FAQs or archives.
CREATE TABLE aa ( a int);
INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3);
the following :
mysql> select a,count(*) as z from aa where z>1 group by a;
displays this error:
ERROR 1054: Unknown column 'z' in 'w
Islam, Sharif wrote:
> I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in
initial
> start up . So I thought i would reinstall it. I downloaded the rpm for
> 3.23.47. And ran the rpm installation.
>You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an
Yes
Islam, Sharif wrote:
> I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial
> start up . So I thought i would reinstall it. I downloaded the rpm for
> 3.23.47. And ran the rpm installation.
You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an
upgrade
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At 03:44 PM 1/18/2002 -0500, you wrote:
>We use mysql heavily in production with tables over 30GB. We are going
>to purchase a new db server soon and the decision to be made now is
>whether we should go with a 4 cpu 700-900MHz system or a 2 cpu 1.4G
--j2AXaZ4YhVcLc+PQ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
We use mysql heavily in production with tables over 30GB. We are going
to purchase a new db server soon and the decision to be made now is
whether we should go wit
Hi!
On Jan 18, Gordan Bobic wrote:
> Hi.
>
> I thought it would be useful to share my findings. They all relate to the
> 4.0.1 release. It would be nice to have some clarification on whether this is
> expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
> index, etc), and
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial
start up . So I thought i would reinstall it. I downloaded the rpm for
3.23.47. And ran the rpm installation. I am not sure if it did the whole
install. Now I have a safe_mysqld and 2 other mysqld process runinng. But I
ca
Unfortunately Mascon doesn't have any ER diagramming tools for schema
modeling. I bought Heraut Solutions' Dezign for Databases for this
purpose a while back, but its somewhat clunky, unprofessional look/feel
has been a bit of a turn off. I've enjoyed using Sybase' Powerdesigner
for this purpos
Hi.
I thought it would be useful to share my findings. They all relate to the
4.0.1 release. It would be nice to have some clarification on whether this is
expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
index, etc), and what you guys think could be causing it.
1.1) F
>Description:
When attempting to run mysqld, it says 'Can't create gc thread'.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all
> Hi ppl,
>
> When I set database and user host to "%" I can't connect to
> database when using localhost - authorization fails.
> When I connect using domain name, every things works fine.
>
> Q1: What is the problem using localhost?
No problem - just a different type of connection. When
you
Hi ppl,
When I set database and user host to "%" I can't connect to database when using
localhost - authorization fails.
When I connect using domain name, every things works fine.
Q1: What is the problem using localhost?
Q2: How can I set default localhost to domain name?
Thank You.
Best Re
Did you get an answer to this problem. I'm experiencing the same behavior.
Mike Wexler wrote:
> When I do
>
> EXPLAIN
> SELECT status.itemKey, status.auctionUrl,
> status.hideItem, status.auctionId, status.action,
> status.auctionHouse
> FROM auction.status, inventory.thisItem
> WHERE s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a problem compiling an app that uses the MySQL C API. My program
itself is C++ using Visual C++ 6.0 in Windows 2000, but the C api is plenty
sufficient for me. I suspect the problem comes because when I include C++
streams, I use the ANSI
Kevin,
The Mysql documentation suggests you use no more than 75% or 80% of
physical memory to allocate for key_buffer. As Heikki and Jeremy
confirmed for me this week, sort_buffer and record_buffer are the ones
that grow per thread - Heikki suggested 1Mb for each of those. Using
swap as RAM (
> How do I seperate them
> so I can display a fixed number per page and allow
> record navigation on my website?
Use LIMIT in your database query, keeping track of the offset with a
variable. A simple example here (I am sure there are many more out there):
http://www.it-development.de/scripts/de
> original platform. I can see where this kind of design is useful... if you
> KNOW you are going to port to MySQL in the future. But in that case, why not
> design there in the first place?
I have no idea and I didn't suggest this was a good solution, but the
question was posed, so I simply sta
> You
> can easily develop a system that uses the proper datatypes
> and does NOT
> use MSSQL-specific extensions. This type of system can
> easily be ported.
Yes, and such an application is likely not to be nearly as efficient on the
original platform. I can see where this kind of design is u
If you only have 2GB of RAM and you are allocating 5120M (=5GB) for the
key_buffer, you have a problem. That should make your system swap like
mad and everything slow to a crawl. Also, note that some of these config
options may effect per-thread allocation. I don't know which ones off the
Nasser,
Friday, January 18, 2002, 12:26:09 PM, you wrote:
NR> I tried to install MySQL in my linux box (redhat 7.2) by using the rpm
NR> files.
NR> Where should the files get after installation.
NR> In mine the get to /usr/bin and when i use MySQL with som appliction,i get
NR> error message wh
Hello Steve,
Friday, January 18, 2002, 5:33:38 PM, you wrote:
SS> REALFROM: Steve Suehring <[EMAIL PROTECTED]>
SS> HOUR: 2002011817
SS> Hello-
SS> I've done some searching through archive and the website but can't seem to
SS> find a semi-concrete answer. What's the schedule, if any, for vers
hi list!
I have been working with mysql and php for sometime
now and I have this problem:
I query the server for records and I know the result
is more than a thousand records. How do I seperate them
so I can display a fixed number per page and allow
record navigation on my website?
I hope the
I've had a similar error when creating innodb tables, using a 4.0.1 client,
and a .47 server, if I loaded my create statement from a text file, the
innodb table wouldn't create. Change the type to myisam and it worked fine.
If I wound up creating it line by line, it worked fine. This might g
Philip,
DROP TABLE always succeeds even if you would have child rows referring to
it.
Thus the way is dump + DROP + CREATE + import
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and la
> So basically, if you already own Mascon (or buy it from
> http://www.scibit.com/ for $49.00), and download the latest
> installable
> binary releases of MySQL, Apache, etc, you've got the "MySQL Studio",
> and as a bonus, it features a clean, standard UI, with the standard
> Windows style widg
> Are you seriously saying you could sit down in front a reasonably sized DB
> you had never seen before and understand all the business issues and pick it
> up and ship to a new RDBMS and platform, rewrite the document, replan what I
Absolutely not. I am saying that if I am tasked with developi
I wasn't talking about migration of a 30gb DB2 system. I was talking
about porting a system that was specifically designed to be ported. If
you design it correctly up front, you can port it very painlessly. You
can easily develop a system that uses the proper datatypes and does NOT
use MSSQL-sp
I would say it would take a month at least to complete the job
correctly. I have seen some top OLAP developers take 3 months to
complete a 30gb DB2 to an Essbase migration including all documentation
and politics involved. Two hours? You should be fired for just
thinking that! Just kidding. T
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 4:10 PM
Subject: Re: Porting from MS SQL to MySQL
> > Unless they are saying they doubt that mySQL is upto, it so i
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 4:07 PM
Subject: Re: Porting from MS SQL to MySQL
> > Porting a DB takes more 'than a couple of hours'. What about
Is there a way to disable foreign keys temporarily? Specifically,
I'm running 3.23.47 with InnoDB tables, and I need to periodically
dump and reload a table that has foreign key dependencies on it.
Thanks,
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
Guy-Maurice Lepoutre writes:
> Hello,
>
> I have troubles compiling this program:
>
> #include
> #include
> #include "c:/sqlplus/sqlplus.hh"
>
> int main()
> {return(0);}
>
> As you can see, the program itself isn't very
> complicated.
> When I run this program (using MS Visual C++), here
>
I agree.
I have more experience with MS SQL than mySQL, but there are some MS SQL
specifics that can cause hiccups. But these hiccups can be avoided with
a bullet proof project plan and excellent documentation. You may not be
able to automate all the project procedures and a lot of the database
These two queries were execute one after the other. I am the only one
who updates this table. I have seen this happen before, and people have
said that perhaps it's a problem with softupdate. I haven't been able
to address it.
I am on FreeBSD 4.2 FreeBSD 3.23.35
There is quite a bit of load o
> Unless they are saying they doubt that mySQL is upto, it so it's no good
> quoting. They may have a room full of SQLServer people twiddling their
> thumbs in which case I agree with you, they are not bucking for the customer
> here. On the other hand they have very real doubts that mySQL is up
Hallo,
I am developing a database application using Kylix
ver.1 and MySQL 4.23.41-log .
I can connect and execute the query but the problem is
my DBGRID only displays " (MEMO) ".
Some of my friends said that perhaps it is caused by
the datatype of the field but I tried to change the
datatype o
> Porting a DB takes more 'than a couple of hours'. What about the written
> procedures, the security mappings, the back up and recovery procs, the
> fallback arrangements, the testing etc.
Yes, porting a database that was written for MSSQL with no intention of
porting can be a painful propositi
you could use:
file /path-to/mysqld
the output will tell you if mysqld is a 32 or 64 bit ELF executable.
Hatton Steven wrote:
>
> Sorry about the previous, seemingly stupid question asking for clarification
> on the LDFLAGS. I was not able to hit
> http://home.earthlink.net/~jaymzh666/mysq
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 3:34 PM
Subject: Re: Porting from MS SQL to MySQL
> SNIPSNIP:)
> > > I agree. If they are a seriuos company they should build it after the
> > > c
Carsten Hammer writes:
> Hi,
> I just experienced the following bug in tables created as berkeley
> tables:
>
[skip]
>
> Is it in general dangerous to use bdb tables?
> Best regards,
> Carsten Hammer
No, it is not dangerous to use bdb tables.
Can you upload gzipped dump of the tables to :
ft
Hatton Steven writes:
> Sorry about the previous, seemingly stupid question asking for clarification
> on the LDFLAGS. I was not able to hit
> http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that
> answer was there. I now seem to have a successfully built MySQL 3.23.47
>
We are running an extremely large instance of mysql version 3.23.41 on
Solaris 2.8 and have been experiencing memory related server crashes.
The behavior suggests that we are running out of memory / swap, but we have
over 2 gig of memory and 10 gig of swap free.
Our server settings are:
key_buf
Hello-
I've done some searching through archive and the website but can't seem to
find a semi-concrete answer. What's the schedule, if any, for version 4.0
to go stable?
Thanks for any help or pointers.
Steve
-
Before posti
Hello,
I have troubles compiling this program:
#include
#include
#include "c:/sqlplus/sqlplus.hh"
int main()
{return(0);}
As you can see, the program itself isn't very
complicated.
When I run this program (using MS Visual C++), here
are the errors I get. Can anybody help me please. I
would r
SNIPSNIP:)
> > I agree. If they are a seriuos company they should build it after the
> > customers wishes
> > i.e if you want mysql the company should build it with mysql.
> >
> > For 18,000 euro i could build the system myself:)
> >
> > My two cents
> > /PM\
>
> What about the customer who asks
On Fri, 18 Jan 2002, Markus Lervik wrote:
>
> Hello all!
>
> We've requested a database from different companies, and specifically
> said we wanted MySQL or PostgreSQL because of the open source angle
> and we're a library.
> One company offered MS SQL as the platform and said that they can later
I understand it has to re-iterate if the number of rows in the result
without DISTINCT is greater than the limit clause, but if the result without
DISTINCT is lower, it should be faster to perform the DISTINCT on the result
directly (or perhaps I'm missing something ? ;)).
- Original Message -
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> Yes it is 4.0.1.
> But the first query has also to make a temporary table with 2 million rows,
> it's why I don't understand the delta between the query without DISTINCT and
> the query with DISTINCT.
> The "remove duplicates" doesn't occurs after
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 2:14 PM
Subject: Re: Porting from MS SQL to MySQL
>
>
> Jeremy Zawodny wrote:
> >
> > On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
> > >
> > > H
-Original Message-
From: Markus Lervik [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 8:08 AM
To: [EMAIL PROTECTED]
Subject:Fwd: Re: compiling and/or running 64-bit MySQL on Solaris
8/sparc?
On Friday 18 January 2002 13:57, you wrote:
[BIG snip]
> checking
Sorry about the previous, seemingly stupid question asking for clarification
on the LDFLAGS. I was not able to hit
http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that
answer was there. I now seem to have a successfully built MySQL 3.23.47
using what I believe is a 64-bit
Chris Allum writes:
> Hi,
>
> I'm trying to use the mysql++ API on MacOS X with Project Builder, but I am
> not sure what to do to get started.
>
> Any suggestions?
>
> Thanks,
>
> - Chris
>
> --
> Christopher Allum [EMAIL PROTECTED
Hi,
Yes it is 4.0.1.
But the first query has also to make a temporary table with 2 million rows,
it's why I don't understand the delta between the query without DISTINCT and
the query with DISTINCT.
The "remove duplicates" doesn't occurs after the join was performed ?? (it
should be really fast i
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> I've notice sometimes DISTINCT clause take a really high amount of time to
> remove duplicates whereas it should be really quick (I assume it should be
> ;))
>
[skip]
>
> Why does it take so much time to remove duplicates in only 58 rows ??
>
It will write a status message over the '#" prompt.
Hit enter. Does the prompt return?
Larry Brown wrote:
>I just double checked and the & doesn't make a difference. It still just
>hangs there after executing "safe_mysql &".
>
>Larry S. Brown
>President/CEO
>Dimension Networks, Inc.
>Member I
My concern would be, what is the mysqld without a database going to do.
Wouldn't it need some
kind of dummy data dir. I'm sure the daemon does some random checks of its
data to ensure that
it is still there.
If this is not a problem then this seems fine.
As far as the OS goes, I would like to s
I can't say that I am a database specialist, but I still think that there
will be some problems porting a MSSQL to mysql, and this because it seems
that MSSQL is very linked to the operating systems it runs on, i.e. Windows
(only think to the security for MSSQL).
-Original Message-
From:
Hi,
I just experienced the following bug in tables created as berkeley
tables:
on bdb tables:
mysql> SELECT
jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
jobs.verarbeitung) order by jobs.number;
+
Is it possible to replicate between two databases on a single server,
and if not, then what is the next best solution? I administer a
Bugzilla installation with about 1.8GB in a MySQL database. Bugzilla
has a built-in replication solution that copies data from a primary
database optimized fo
Jeremy Zawodny wrote:
>
> On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
> >
> > Hello all!
> >
> > We've requested a database from different companies, and
> > specifically said we wanted MySQL or PostgreSQL because of the open
> > source angle and we're a library.
> >
> > One
If you know you're going to port it, it really shouldn't be too difficult.
In fact, if you're creating it with the intention of porting it, you can
(and should) use MSSQL datatypes that are compatible with MySQL. If you
do this, porting is a trivial task at best.
18,000 euro seems a bit steep fo
On Friday 18 January 2002 15:58, you wrote:
> On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
> > We've requested a database from different companies, and
> > specifically said we wanted MySQL or PostgreSQL because of the open
> > source angle and we're a library.
> >
> > One comp
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
>
> Hello all!
>
> We've requested a database from different companies, and
> specifically said we wanted MySQL or PostgreSQL because of the open
> source angle and we're a library.
>
> One company offered MS SQL as the platform and
Hi
first of all it is ridiculus of the company to offer something
other than your specifications.
if they want to offer you a solution other than what you need,
they have to change the software at their cost not at yours.
in my opinion it is better to not accept this solution at all
and look fo
Hello all!
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later on
port it to MySQL. For this they wanted 18 000 eur
you should make a self-join to find the duplicates in one table.
-Original Message-
From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 2:00 PM
To: [EMAIL PROTECTED]
Subject: find double
hi,
i have a mysql table with 10 millions rows. Response time is pe
Forgot to CC to the list. Here it goes, in case anyone else has these
problems:
-- Forwarded Message --
Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Date: Fri, 18 Jan 2002 15:06:57 +0200
From: Markus Lervik <[EMAIL PROTECTED]>
To: Hatton Steven <[EMAI
Brad Teale writes:
> I found the answers to my previous question about MySQL in the manual. Doh!
>
> However, when I tried to compile MySQL, I ran into the following error:
>
[skip]
> processors
> "hash.c", line 189: reference to static variable "hash_key" in inline extern
> function
> "hash.c
Brad Teale writes:
> A couple of questions about compiling on Solaris.
>
> 1) Are the Sun Workshop 6 compilers supported for MySQL and MySQL++?
>1a) Can you use the -native flag without problems?
>
> 2) Is the binary distribution compiled with Sun or GNU compilers?
>
> Background Info:
>
1 - 100 of 129 matches
Mail list logo
