At 23:38 15/01/2001 -0800, you wrote:
>On Tue, Jan 16, 2001 at 08:29:52AM +0100, Gustav Wiberg wrote:
>
> > Thanks you all for telling me about MySQL under Windows Me. About
> > Subquerys. Anyone knows when sub-querys will be supported in MySQL?
>
>Probably in version 4.1 or so.
Is that a fact.
I use php 4.0.3 with persistent connections. MySQL is installed on Linux
RedHat 7.0.
The problem is that the Mysql exists and I don't know exactly what appends
to the php process
Denis
At 19.21 15/01/01, Maciek Uhlig wrote:
>Could you describe what exactly software connects to MySQL in you
I have linux redhat 7 and a problem with installation of mysql! When I type
safe_mysql & the deamon start and end quickly! In the log file the error is
the following: Can't find host.frm!
What is the problem?
-
Before posting, p
Hi,
I'm a relative newbie in mySQL. I have 10 mySQL databases. At the moment
I'm only using 1 of the databases. I was wondering if it's possible (and
how) to setup some sort of replication/load balancing between all 10
dbs. Basically I want the information in one db replicated across the
other
On Tue, Jan 16, 2001 at 08:29:52AM +0100, Gustav Wiberg wrote:
> Thanks you all for telling me about MySQL under Windows Me. About
> Subquerys. Anyone knows when sub-querys will be supported in MySQL?
Probably in version 4.1 or so.
http://www.mysql.com/doc/T/O/TODO_future.html
Jeremy
--
On Mon, Jan 15, 2001 at 11:41:39AM -0800, Arthur Radulescu wrote:
> Hi!
>
> I have 2 questions!
>
> 1.What is more eficient to keep some images into a table or to keep
> 1.their names in the table and images separated in a directory?
If your main concern is effiency, keep the images in the file
Hi guys,
I am looking some tutorial step by step using replication. I had a look the
documentation about replication but I am not so clear where to find some of files and
some other points.
Do you know any url or real sample for replication for MySQL?
Thank you
Canario
On Tue, Jan 16, 2001 at 11:11:53AM +0900, À±±¤Èñ wrote:
> Hi.
>
> I'm running mysql in solaris 2.6 has serveral lan card and
> have a problem in using JDBC.
>
> when i trying to create JDBC connection to URI jdbc:mysql:///test,
> access denied. so i telneted every ip address that solaris have.
Hi,
My license number is 7697. I don't know what the expiration date is. I'm running
3.23.28-gamma msqld-opt under w2k.
I'm trying to use a HEAP table to speed up data access, but every select I do which
references an indexed column gives me:
ERROR 1030: Got error 124 from table handler
O
Thanks you all for telling me about MySQL under Windows Me.
About Subquerys. Anyone knows when sub-querys will be supported in MySQL?
/Gustav Wiberg
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Hi,
Another thing to try can be the myisampack table compressor,
since you say you need just read-only access to the tables.
If the tables get smaller, they could perhaps fit in the OS buffer cache.
MySQL does a memory-map of compressed tables,
which should be quite like having a ramdisk that mig
At 07:49 16/01/2001 +0100, Gustav Wiberg wrote:
>Hello there
>
>I'm a teacher who has MySQL as base for learning basics of databases. I
>just got a question about how you install MySQL under Windows Millenium. I
>don't have a clue. I haven't used Windows Millenium.
Forget about ME. MySQL runs e
Hi,
I am not subscribed to the list itself, so if you can
generously reply to [EMAIL PROTECTED], that would
be very helpful.
I am currently trying to compile program controlling a
database used for a simulation. However, everytime I
try to compile it, I get errors like the following:
obj/int
Hi
This is not an Oracle Mailing List. So why you asking such question which
are totally unrelated to MySQL
Please note MySQL != Oracle
At 13:41 16/01/2001 +1100, Solomon Sokolovsky wrote:
>Hi,
>
>I am interested if anyone has experience in building ASP pages to access an
>Oracle Database on an
Hi
Sub-Selects are not supported, yet, regardless of OS
At 02:25 16/01/2001 +, SED wrote:
>Hi,
>
>I'm trying to execute the following (as told in MySQL-Manual):
>
> mysql> SELECT article, dealer, price
> -> FROM shop
> -> WHERE price=(SELECT MAX(price) FROM shop)
>
Hello there
I'm a teacher who has MySQL as base for learning basics of databases. I just got a
question about how you install MySQL under Windows Millenium. I don't have a clue. I
haven't used Windows Millenium.
The pupil says that DOS "nearly" doesn't exist under Windows Millenium. Is that tr
On Tue, 16 Jan 2001, ±i®p»Ê wrote:
>
> Hi, happy new year!!
>
> Yesterday morning, I operated MySQL (3.23.28)
> insert some data into a table ,
> I found a error and could not find any one can help
> with:
> -
> Welcome to the MySQL mo
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 11:20 AM
Subject: WELCOME to [EMAIL PROTECTED]
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> Acknowledgment: I have added the address
>
>[
As I said, I am not familiar with JDBC but it would help if you provided
sample code with error messages. I have a feeling it may not be privileges.
Cheers
Rolf
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "À±±¤Èñ" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 200
I'm using SELECT ... INTO OUTFILE to create a comma delimited file from the
contents of several different tables. The file that's created will be
imported into another program.
The problem I've got is that some of the empty fields are fine, showing just
"" in the output file, but others have /N i
MySQL is a great database, Please spam some place else.
Solomon Sokolovsky wrote:
> Hi,
>
> I am interested if anyone has experience in building ASP pages to access an
> Oracle Database on an NT Server?
>
> Thanks
> Solomon
>
> ---
Hi,
I am interested if anyone has experience in building ASP pages to access an
Oracle Database on an NT Server?
Thanks
Solomon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hi, happy new year!!
Yesterday morning, I operated MySQL (3.23.28)
insert some data into a table ,
I found a error and could not find any one can help
with:
-
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection
At 10:50 AM +0800 1/16/01, Rolf Hopkins <[EMAIL PROTECTED]> wrote:
>
s¶~ß÷º÷, *\þµo] (Sorry, not sure of some of the characters)
>
>My guess is you have an autoincrement column and it may have gotten screwed
>up. Try repairing your tables with myisamchk.
>
>Cheers
>
>Rolf
Another possibility
·s¦~§Ö¼Ö, ¥\³ßµo°] (Sorry, not sure of some of the characters)
My guess is you have an autoincrement column and it may have gotten screwed
up. Try repairing your tables with myisamchk.
Cheers
Rolf
- Original Message -
From: "±i®p»Ê" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mo
Stupid me, I didn't read the text properly as the following text explains:
Find number, dealer, and price of the most expensive article.
In ANSI SQL this is easily done with a sub-query:
SELECT article, dealer, price
FROM shop
WHERE pr
Hi,
I'm trying to execute the following (as told in MySQL-Manual):
mysql> SELECT article, dealer, price
-> FROM shop
-> WHERE price=(SELECT MAX(price) FROM shop)
-> ;
But I get the following result:
ERROR 1064: You have an error in your SQL syntax nea
Hi.
I'm running mysql in solaris 2.6 has serveral lan card and
have a problem in using JDBC.
when i trying to create JDBC connection to URI jdbc:mysql:///test,
access denied. so i telneted every ip address that solaris have.
it finded out that only a ip address response there is mysql.
Hi, happy new year!!
Yesterday morning, I operated MySQL (3.23.28) insert some data into a table ,
I found a error and could not find any one can help with:
.
Hi!
> "root" == root <[EMAIL PROTECTED]> writes:
>> Description:
root> In certain cases the select fails (ie (a) does not return required rows, or (b)
returns non-wanted rows (cannot repeat (b)))
root> The problem seems to be related to negative values in decimal type fields and in
query
Hi,
I'm a relative newbie in mySQL. I have 10 mySQL databases. At the moment
I'm only using 1 of the databases. I was wondering if it's possible (and
how) to setup some sort of replication/load balancing between all 10
dbs. Basically I want the information in one db replicated across the
other 9.
Hallo
- Just out of interest .
Did you install MySQL on FREEBSD using www.freebsd.org/ports
if you didnt I highly recom,mend you should.
Looking forward to your feedback.
dannyh
[EMAIL PROTECTED]
On Tue, 16 Jan 2001, Nicolai Gylling wrote:
> Hi
>
> I'm currently running a FreeBSD4.2-Sta
Look in the MySQL manual for mysqldump
you should find the correct syntax
On Mon, 15 Jan 2001, sanaa wrote:
> hi
> I want to know how to backup and restore databases in mysql.
>
>
> thanks for help
>
> -
> Before posting, pl
On Mon, Jan 15, 2001 at 05:05:27PM -0800, Lonnie Cumberland wrote:
> Hello All,
>
> I have been reading the manual on encode(), decode(), and encrypt()
> but have not been able to find a decrypt() function.
>
> I thought about using encode() and decode() but it returns a binary
> string that is
Read the bottom of your e-mails.
- Original Message -
From: "Frank Ruggiero" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:03
Subject: Remove from list
I am beening bombarded by emails...can you please take me off your list
Thank you
Frank
[EMAIL PROTEC
Hello All,
I have been reading the manual on encode(), decode(), and encrypt() but have
not been able to find a decrypt() function.
I thought about using encode() and decode() but it returns a binary string that
is not printable, which encrypt() does.
Does anyone of a decrypt() function that wo
Whenever I try to query a table on my database with "SELECT" using PHP, I get
an error message that says: " 0 is not a MySQL result index". I can query
other tables and they work fine. Please help me. Thank you.
[EMAIL PROTECTED]
-
Please tell us the basic layout of your tables (field types, primary keys)
and the query your using
We can not do anything with the information you have given us.
- Original Message -
From: "Rekha Das" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 2:51 PM
Sub
At 3:20 PM -0800 1/15/01, Matt Thoene wrote:
>Hello,
>
>I've just installed and am running MySQL for a web site that was recently
>moved to this box. The previous webmaster did a mysqldump of a database we
>need and it has a .sql extension. I've read in the manual where you can
>import from a te
Ok, since my quries aren't responding, I've been told to drop the table, create the
table again, and then import the data. The only index on the table is the primary key.
Will it help to add an index for every column to optimize the table? I have queries
that pull data from different columns on
Hello,
I've just installed and am running MySQL for a web site that was recently
moved to this box. The previous webmaster did a mysqldump of a database we
need and it has a .sql extension. I've read in the manual where you can
import from a text file but can't seem to find how to import a .sql
does anyone have further thoughts on this? based on some suggestions i
received, i have tried:
- running as root (mysqld --user=root)
- creating a new user and giving it ownership of the whole mysql/*
directory
- reinstalling
- making sure that the user starting mysql always has rwx permissio
I have two tables named a and b having around 2000 records each. I have
written a query to retrieve records from these two tables. I have a left
outer join in my query.
My problem is that my query is very slow. It takes around 2 minutes to fetch
all the records. What can I do to make it fast ?
--
Primary key by definition is a unique index.
At 02:33 PM 1/15/2001 -0800, Rekha Das wrote:
>I need to know whether the primary key field already has a index on it or we
>need to create one.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 -
In the last episode (Jan 15), Rekha Das said:
> I need to know whether the primary key field already has a index on
> it or we need to create one.
In mysql, a "Primary key" is simply implemented by putting a UNIQUE NOT
NULL index on the field. So no, you don't need to explicitly add an
index.
-
I need to know whether the primary key field already has a index on it or we
need to create one.
-Rekha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
MySQL only supports constant default values. You'll have to insert
the date explicitly when you create the record if you want to simulate
initialization to now().
Timestamps will update themselves whenever any other field in the
record changes, unless you explictly tell them not to. So they are
* Petras Virzintas <[EMAIL PROTECTED]> wrote on 15.01.01 23:55:
> The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I
> wouldn't mind if it was a rounding issue but the value 66.66 becomes
> 66.69 and 77.77 becomes 77.75!
Sounds to me like a typical binary rounding
The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I wouldn't mind if it
was a rounding issue but the value 66.66 becomes 66.69 and 77.77 becomes
77.75!
To reproduce the problem follow the steps below:
Step 1: Creat Table
create table TestAmt
(
id int(8) not nu
Use the timestamp datatype, not date.
At 02:43 PM 1/15/2001 -0600, Apolinaras \"Apollo\" Sinkevicius wrote:
>I would like to set a default value in DATE type column to Date(), but it
>doesn't work. Is there a way to do it through column format?
>If not, what should I enter in the VB code below (
See section 7.39 of the manual. 'when' is a reserved word in 3.23.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Alan Halls [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 15:15
> To: [EMAIL PROTECTED]
In the last episode (Jan 15), Aaron Schlesinger said:
> I've noticed that most of the really cool new features in MySQL use
> myisam tables. My tables are from an earlier version, and are only
> ISAM.
>
> 2 Questions:
>
> 1) How do you convert the tables?
Run mysql_convert_table_format, which w
Any idea why I get this error when I try to create this table on a clean
3.23.30 install on a BSDI box.
This was the output from a mysqldump from version 2.22.32 on a working
database. It will not allow me to recreate my database on the new version.
mysql> CREATE TABLE pp_additional_features (
Aaron,
I sugest that you use this app,
http://www.ocsny.com/main/index.ocs?url=mysqlbackup and then use the dumped
files on the new server to rebuild you db you could quite conceivably br up
within 2 hours...
Cheers,
Mikel
Aaron Schlesinger wrote:
> I've noticed that most of the reall
I don't use DBI, but when I connect via 'localhost', the client does not
use an IP
port, but rather uses the MySQL socket file. You must be sure to have
the
second instance of your MySQL server come up with its own socket file,
and
connect to that socket instead of the default one.
The other sol
I would like to set a default value in DATE type column to Date(), but it
doesn't work. Is there a way to do it through column format?
If not, what should I enter in the VB code below (place where I need help
will have )
Private Sub okButton_Click()
Dim db As Database
Dim r
I've just done this myself, and had no problems whatsoever. I upgraded
from 3.22 to 3.23...
1. Compile mysql 3.23
2. Shutdown mysql 3.22 server
3. (Carefully) do a make install of 3.23, ensuring your data files in
~mysql/var are not over-written
4. Restart mysql server (3.23)
5. Go through each t
I just downloaded and installed the following files:
MySQL-3.22.32-1.i386.rpm
MySQL-client-3.22.32-1.i386.rpm
MySQL-shared-3.22.32-1.i386.rpm
After installation I ran the mysql__install_db script.
mysqld will not start. The error log is as follows:
/usr/sbin/mysqld: can't create/write to file '
I've noticed that most of the really cool new features in MySQL use myisam
tables. My tables are from an earlier version, and are only ISAM.
2 Questions:
1) How do you convert the tables?
2) Will my data be changed or corrupted by doing #1?
Aaron
-
Go look at an example in the documentation on how to create an index and
create one on the ID column.
On 15 Jan 2001 20:57:55 +0100, Tobias Talltorp wrote:
> I have a table with 2 fields which I, every fifteen minutes, load new data
> into. The data is not formatted by me. It comes from an exter
I have a table with 2 fields which I, every fifteen minutes, load new data
into. The data is not formatted by me. It comes from an external source, so
when the data is added to the table, the ID doesn´t come in the right order.
The table looks like this:
+-+--+
| ID | headline
I am beening bombarded by emails...can you please take me off your list
Thank you
Frank
[EMAIL PROTECTED]
"Yury V. Bukhman" wrote:
[...]
> Question:
> what is the best way to put an entire database into RAM? I thought of
> using HEAP tables, but they seem to have some limitations, e.g. not
> allowing text column type. Is it possible to just copy an entire data
> directory into RAM? Are there operat
I've been very happy with mascon (scibit.com). Payware with a limited free
version that I think covers all your requirements. I felt it was worth the
price for the real thing. Their support is excellent, as is the incredible
frequency of releaseing updates with significant new features.
Jamie
The urSQL Utility from http://www.urbanresearch.com/ursql allows you to
easily edit text columns in a multiline text box.
On Mon, 15 Jan 2001, Philip Mak wrote:
> Hello,
>
> What is your favorite Windows MySQL GUI client? I'm developing a database
> driven website and I'm looking for a program
Yury,
Can we see the code and queries in question? It may be a better solution to
clean up the queries(and code), perhaps change multiple queries into one
query ...
Indexing the tables would undoubtedly help as well. If they already are
indexed, when is the last time they were re-indexed and clea
While I'm much more a Perl devotee than PHP, I've been using phpMyAdmin
and am fairly happy with it. If you happen to have PHP available, I'd
give it a try.
On Mon, 15 Jan 2001, Philip Mak wrote:
> Hello,
>
> What is your favorite Windows MySQL GUI client? I'm developing a database
> driven web
Although it is not strictly speaking Windows MySQL GUI client, I'd like to
recommend PHPGen (http://opensource.aventus.org/phpgen/phpgen.html) .
It meets all your criteria, but it's not a client, but rather PHP client
program generator. If you happen to have PHP with your webserver, give it a
try
my.anse.de
Scott
At 01:08 PM 1/15/2001 -0500, Philip Mak wrote:
>Hello,
>
>What is your favorite Windows MySQL GUI client? I'm developing a database
>driven website and I'm looking for a program that I can use to maintain
>the database.
>
>One of my special requirements is that I need a client t
I currently have my database on a ramfs (supported by kernel 2.4.0) on a production
environment.
I have also used ramdisks, although they seem to have a 512Mb limit, even though you
can make more than one (before using ramfs I had 2 ramdisks).
Bye,
Enea
-Messaggio originale-
Da: [EMAIL
>I got a problem in converting the Jan 21 2001 format to 2001-01-21
>I always got a null as result when i do date_format('Jan 21
>2001','%Y-%m-%d')
>
>can anyone help me with this
Sir, off the top of my head, I don't think there's a function for
this. Date_format() converts from MySQL format to
I would like to log connections to a file (e.g. the connection info
provided using the --log option) but I don't want every query logged as
well, or at the very least would like them to go to a different file. Is
there any way to do this?
Jamie
---
Could you describe what exactly software connects to MySQL in your case?
Maciek
> -Original Message-
> From: Denis Gasparin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 6:00 PM
> To: [EMAIL PROTECTED]
> Subject: What does this mean ?
>
>
> From when I installed the mysq
From: Anthony Cooke <[EMAIL PROTECTED]>
Date: Mon, 15 Jan 2001 10:33:05 -0400
To: Arthur Radulescu <[EMAIL PROTECTED]>
Subject: Re: 2 questions!
Two answers!
1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let
the file system cache image files, store only the file name.
Hello Michael,
We used to handle around that much traffic a few months back. Our setup
consists of a MySQL backend with a mod_perl/PHP Apache front end. All our
pages have dynamic content and are built on the fly.
Right now we have a dedicated server with DellHost (D-3200) and it doesn't
eve
A RAM disk might work under the Linux 2.4 kernel. The subject was discussed on
Slashdot..
http://slashdot.org/askslashdot/00/09/19/0528207.shtml
...but what are you running this on? Is the DB server only serving the database?
Would be interested to know what you find out.
Donal
On Mon, 15
Hello,
What is your favorite Windows MySQL GUI client? I'm developing a database
driven website and I'm looking for a program that I can use to maintain
the database.
One of my special requirements is that I need a client that can edit text
blobs. So far the clients I've seen display the text b
Appreciate everyone's help...using the MEDIUMBLOB should suffice my
needs...actually I try to keep images under 50kb, so I thought the BLOB
would work. It did until I began using images over ~40kb. It would nice to
know if it is an OS reporting limitation or with mySQL.
Thanks Ben
Gerald E Buck
Thanks for your input Scott. My tables currently do not have indexes. Would
adding indexes to the tables fix the problem. Or do I need to drop the
tables and create them again with indexes. I tried to use the check command:
CHECK TABLE test_table FAST QUICK;
but it returned this error.
ERROR 10
Hello,
We are programming the Control Panel of an Internet Data Center. They are going to
install MySQL for each
user in ther domain and they will assign a port to each installation of MySQL. If it
possible to access the specific intallation of each user in a different port with PHP.
How ca
Rick Pasotto wrote:
>
> On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> > Rick Pasotto wrote:
> > >
> > > SELECT concat(last_name,", ",first_name) as name from members
> > >
> > > results in a column that is much wider than necessary. Adding trim() to
> > > the concat() nor to
Thanks for the fast reply, Neil.
This is exactly the answer I did not want to hear. Now I am afraid
that I have to ask for an "official" statement (Monty, Sinisa?)
If it helps, I can dig out my Licence serial number ...
Stefan
--
Stefan Schmiedl
EDV-Beratung, Programmierung, Schulung
Loreleystr
Stefan,
Your friend has the right idea; proceed with extreme caution. I have heard
(from colleagues that work on this product) that Terminal server(TS) is a
very different animal from the standard or enterprise NT. In fact they have
spent many long nights troubleshooting it. Often there are lots o
Hi!
Background:
I have a moderately-sized (0.9G) database which serves as a backend to a
search engine. The search engine is kind of slow, because it has to run
multiple database queries for each user request (don't ask me why). In
order to speed things up, I am thinking of copying the entire d
New to 3.23 is showing your priviledges when you describe a table. This
throws off the length of my screen. Without altering the source, is there
any way to remove this "feature"?
Thanks
Aaron
-
Before posting, please check:
To simplify
SELECT Field1, Field2, Field3 ORDER BY Rand() LIMIT 1;
At 10:01 AM 1/15/2001 -0700, Alan Halls wrote:
> On the site Adoption.com we have been using a mysql database to
> set up
>families who want to adopt. We have since redesigned our site and the old
>code is not working fo
Keep in mind as well that datafiles for anything earlier than 3.23 are
rarely compatible between different architectures...you'll need to do a
mysqldump unless you're myisam tables in 3.23.x
regards,
P
On Mon, 15 Jan 2001, Scott
Baker wrote:
> You can use MySQL dump. However, copying the file
From when I installed the mysql 3.23.30gamma I have mysql reporting these
warnings:
10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: 'user' host:
`www.host'
(Got an error reading communication packets)
010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user'
host:
If you're sure you have PERL installed just use rpm -i name.rpm --no-deps
At 04:25 PM 1/14/2001 +0100, Martin Borg wrote:
>I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
>I try to install the binary rpm-distribution i get an error saying that
>bin/usr/perl5 is needed. Th
On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> Rick Pasotto wrote:
> >
> > SELECT concat(last_name,", ",first_name) as name from members
> >
> > results in a column that is much wider than necessary. Adding trim() to
> > the concat() nor to the components makes any difference
Yes MySQL comes empty. You have to make tables.
At 05:36 AM 1/14/2001 -0800, jim.brown wrote:
>I installed MySQL on Win98 and acessed it from a SmartArrays program
>which uses ODBC with this connection string:
>
>DSN=sample-MySQL;DRIVER={MySQL}
>
>This worked. When I asked for the the list of ta
Sounds to me like your indexes got corrupted. You can try fixing them with
the table fixer thing. But since you have such small data, just drop them
all, and recreate them.
At 01:09 AM 1/14/2001 -0800, David Young wrote:
>Ok, here's the scoop. After 3 days of research, noone has been able to
Greetings,
I want to replace an Access database that kills a LAN with a lean and
mean MySQL/Delphi application.
The "sysadmin" of the site in question told me that they are not
running a "normal" NT but a Terminal Server, which sounds like
something very sick to me. ;)
His exact words were "Ter
You can use MySQL dump. However, copying the files SHOULD work as long as
they are the same version (major version) and you stop the MySQL service
before copying.
Scott
At 06:09 PM 1/13/2001 -0600, John W Cunningham wrote:
>Hello all,
>
>I have a few databases running on a Win2k MySQL server
Go buy Paul DuBois' book on MySQL it's a good explanation of both MySQL and
RDMS.
At 03:43 PM 1/13/2001 -0800, [EMAIL PROTECTED] wrote:
>I am a new user to MySQL.
>
>I am having a hard time understanding relational databases.
>
>Can anyone recommended any resources which helps explain
>relationa
On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I
The efficiency of your SQL will be an extrmely important factor. Spend AMPLE time
planning the structure of your database and make sure to optimize yor production SQL
code.
I have a server with 8 processors and 2 gigs of ram sitting on it and 2 or 3 bad join
statements made it work like an old
Use the "timestamp" datatype instead of date.
At 05:19 PM 1/13/2001 -0500, you wrote:
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?
>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work. But that's the idea.
---
Obviously the faster the better, but 60,000 page views a day is nothing. I
run a dual P2 450, Raid 5 HD array with 512 megs of RAM, which is a pretty
sizable server (nothing massive) and I get about 45,000 "hits" a day and
the CPU PEAKS at about 2-3%.
PHP/MySQL are pretty scalable. You have
Please forgive me. I have searched all over for help with this problem
to no avail. I have just installed from RPM mysql 3.23.22-6 on a RedHat
7.0 system. I keep getting the message mysqladmin: cannot connect to
server at 'localhost' failed
error; Can't connect to local MySql server through soc
1 - 100 of 139 matches
Mail list logo
