I think you took that the wrong way. I see it as more of a warning than
being "nasty". Of course, you don't have to set a password if you don't
want to but if other people are able to access it, then you only have
yourself to blame if someone gets in and destroys data. My test database
does not
Before you do, check out the Delphi components on the mySql home page.
I'm sure your aware that you can use Delphi components in BCB.
Sean
>From: "Justin C. Darby" <[EMAIL PROTECTED]>
>To: "Alain Morlans" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: help please!!
>Date: Wed, 10 Jan 2
I know it is not the list to make this answer, but i can find good info
anyware.
I usually work with myqsl and perl, but I need to do the same with perl and
oracle, and i don´t know how to conect to the oracle database, make a query
or an insert comand and return the values of the query to perl v
On Thu, 11 Jan 2001, Rolf Hopkins wrote:
> Fresh installation? Then you don't need -p option. If not, what password
> are you using when it ask you to enter the password. It's not newpassword
> as you typed in the prompt, it's your old password
Hi Rolf,
Thanks for your helpful comment. I am
Dear nair,
try to get an rpm from radhat site.
But my strongly sudjection is to compily the source codes
- Original Message -
From: "SATYAN NAIR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 7:21 AM
Subject: rpm requires perl5 on redhat 7.0
> dear friends
dear friends,
i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0
it says REQUIRES PERL5 at /usr/bin/perl5
and under /usr/bin i have perl as well as perl5.006
please let me know how do i install the rpm on linux!!
take care...
have a nice day...
_
* Carfield Yim <[EMAIL PROTECTED]> wrote on 11.01.01 06:19:
> MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball
> source, can't rollback.
>
> Do you mean that it is platform?? There are errors build with RedHat 7.0?
Hmm. It certainly does seem so as there have been a few repo
> Eric Fitzgerald writes:
> >
> >
> >
> > Also, might it be possible to move the manual comments to another
> > list? :)
>
> I have decided to stop the [DOCS COMMENT] flood. *Most* comments were
> completely useless... even though I added in BIG RED LETTERS that
> adding a comment to the manua
Quentin Bennett writes:
> Perhaps, along with the 'Please check the manual' message at the end of all
> messages, there should be a reference to a reliable archive, allowing list
> users who are referred to the archive an easy way of finding it!
Done.
--
__ ___ ___ __
/ |/ /_
Testing new trailer message.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
--
Well, finally I have launched full blown MySQL database. Speed is amazing (in
comparison with our previous monogenous M$Access database).
I am now tuning MySQL (3.23.30 on RH7.0/ PIII300 Dell server with 128RAM) server via
my.cnf
So far here is what I got:
1. ANSI mode tables
2. logs are off
3.
Ok, rule number 1. Check and make sure your building software is up to date
before you whine to the MySQL List. I'm still compiling, but it's much
further down the path then when it crashed before. While I wait for this
thing to compile I even helped a few newbies :)
Thanks for your help!
-
Fresh installation? Then you don't need -p option. If not, what password
are you using when it ask you to enter the password. It's not newpassword
as you typed in the prompt, it's your old password
- Original Message -
From: "Neil Zanella" <[EMAIL PROTECTED]>
To: "MySQL Mailing List"
Carlos Corzo writes:
> Hello,
>
> Other than installing the .pkg file into the server and running it
> through his interface, do I need to get the server admin to do anything
> else? I am afraid that I am running out of time with him, meaning, I am
> running out of time with root priviledges. I
Hello,
Other than installing the .pkg file into the server and running it
through his interface, do I need to get the server admin to do anything
else? I am afraid that I am running out of time with him, meaning, I am
running out of time with root priviledges. I am trying here. We have
tried a
Hello,
I need help. I am sitting here with our server administrator (a miracle
in itself) and the SQL manual and some scripts to follow. We just
finished installing the .pkg program on the RAQ3 and MySQL is up and
running. The next step to take to create the database according to
Andrew Chen's
Hello,
I have installed the RPMs and I am now trying to set the MySQL root
password as the output of the RPM files tells me to do...
[root@tulip /root]# su mysql
[mysql@tulip /root]$ /usr/bin/mysqladmin -u root -p password newpassword
Enter password:
/usr/bin/mysqladmin: connect to server at '
Eric Fitzgerald writes:
>
>
>
> Also, might it be possible to move the manual comments to another
> list? :)
I have decided to stop the [DOCS COMMENT] flood. *Most* comments were
completely useless... even though I added in BIG RED LETTERS that
adding a comment to the manual is not a good pla
> "MW" == Matt Wagner <[EMAIL PROTECTED]> writes:
>> As far as I know, just try building it on an i386 running BSDI 4.1
MW> Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he
MW> could give Aaron here some pointers.
Try using gmake for bsd systems. The makefiles are proab
MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball
source, can't rollback.
Do you mean that it is platform?? There are errors build with RedHat 7.0?
On Wed, 10 Jan 2001, goEbusiness.com Mail Lists wrote:
> MySQL 3.23.29a-gamma
> Solaris 7
>
> No problems here.
>
> On Wed, 27
[EMAIL PROTECTED] writes:
>
>
>
> >How-To-Repeat:
>As far as I know, just try building it on an i386 running BSDI 4.1
Sinisa,
Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he
could give Aaron here some pointers.
Matt
--
__ ___ ___ __
/ |/ /_
>Description:
After configure this happens:
% make
make all-recursive
Making all in include
Making all in Docs
Making all in readline
Making all in libmysql
Making all in client
Making all in strings
Making all in dbug
Making all in mysys
Making all in extra
Making all in
Good day all!
Please help me with charset adding. I have some strange trouble.
I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD
ports) and PHP 4.04.
As I understood Latin1 is a default charset. So, I wanted to add cp1251 or
koi8_ru.
Ok, I add --default-character-set=cp1251
[EMAIL PROTECTED] wrote:
>
> Hey there, I've written about this a few times now and haven't received very many
>ideas.
>
> I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1
>
> I currently have the latest build of Perl 5 on my system as well.
>
> When I do a make on A
Bob Hall writes:
> >This is the first time I've ever been directly in charge of adminstering a
> >mysql server. I have a few questions. Since I can't get mysql 3.23.X to
> >install, I'm stuck with 3.22.30 and I was wondering what I could do to
> >facilitate backups, and to be able to protect my da
Hey there, I've written about this a few times now and haven't received very many
ideas.
I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1
I currently have the latest build of Perl 5 on my system as well.
When I do a make on ANY version of MySQL 3.23.x, it always stops
[root@switch logging]# ls -lh ll*
-rw-r-1 root root 44M Jan 10 17:35 ll.MYD
-rw-rw1 root root 126M Jan 10 17:45 ll.MYI
-rw-r-1 root root 9.7k Jan 10 17:25 ll.frm
[root@switch logging]# myisampack ll
Compressing ll.MYD: (0 records)
- Calc
At 15:48 10/01/2001 +, Alain Morlans wrote:
Hi!
>Hi!
>
>I would like to coonect top mysql using Borland C++ builder on a windows
>plataform.
>
>Do you know what is the best way to do it?
There are several way to do it. The best, you decide according
with your preference:
- You can use the
> :(
>
> copy MYD and frm file to new table name. Copy MYI from wrong
> table to the new table name (oops). myisampack new_table.
> new_table.MYD is now 64 bytes.
I should have made a note: the bad MYI file copied over was for a compressed
table, so myisampack said it was already compressed and s
Hello,
I don't know whether or not the developers of MySQL are aware of this
but I got the following error three time when I installed the
MySQL-3.23.30-1.i386.rpm and MySQL-client-3.23.30-1.i386.rpm packages
on Red Hat Linux 6.2:
/usr/bin/mysql_install_db: test: integer expression expected bef
Have you tried looking at the data in your tables?
I would check that, and then, if it checks out, try to give us some more
information.
- Original Message -
From: "Mike Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 5:28 PM
Subject: Something went
You'll have to go through the script step by step printing out debug in
order to determine what's going on - it's a normal process of elimination
when troubleshooting
jason
> I had this query site working and showing the DB info depending on the
> Category.
> For some reason it just stopped wo
Hi Scott
-H outputs the file nicely as a HTML bordered table, but I was more looking for
a way to output the file as a "bordered" ASCII table (like a screen
print below)
any clues?
cheers
Mark Dale
-Previous Message-
>Have you tried the -H switch to output as HTML?
>
>see mysql -he
:(
copy MYD and frm file to new table name. Copy MYI from wrong table to the
new table name (oops). myisampack new_table. new_table.MYD is now 64 bytes.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
--
-
I had this query site working and showing the DB info depending on the
Category.
For some reason it just stopped working. Saying that I can't connect to the
server.
I fixed that script a little bit but now its showing doubles for some of
the records.
I don't know what is wrong! Nothing on the scr
On Wed, 10 Jan 2001, Michael A. Peters wrote:
> Try rpm --nodeps -Uh MySQL-3.23.30-1.i386.rpm
>
> I doubt that MySQL is dependant upon that particular file existing, if
> it wants perl (for benchmark package??) your local perl should work
> fine. If MySQL doesn't work- you can remove it, rpm -e
Perhaps, along with the 'Please check the manual' message at the end of all
messages, there should be a reference to a reliable archive, allowing list
users who are referred to the archive an easy way of finding it!
Quentin
> -Original Message-
> From: Eric Fitzgerald [SMTP:[EMAIL PROTEC
> I didn't wanted to make you upset. We still try to answer questions and
> value your time. Just some questions are repeating up to 3 times per
That's great coming from a great team.
Who knows ? There might be people who are tasked to frustrate you and this
group.
For the benefit of the open-sour
OK enough said. Lets get back to using the best database out there.
--
-
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a mes
Aaron Schlesinger wrote:
> I agree with Carlos's response below. Tõnu I appologize for singling you
> out, but if you push away those simple questions, you'll just force those
> who are just getting started to find more patient people and software to
> use.
Critics is good :). I try to be more p
Is there any way that the list in question can be broken up into two lists?
For example, ASP has two (actually, alot more) lists called ASPFreeForAll,
and ASPAdvanced which cater to the various knowledge levels of each list's
participants.
The ASPAdvanced list is moderated by the person who cre
Agreed!
Eric Fitzgerald wrote:
> Some people have looked at the manual's, yes, and it's pretty simple to
> determine when they have. If the question they ask can be copied/pasted
> into the mysql documention search and get the answer, then the person has
> not checked the documentation. Someti
Ya know, I've asked a few questions on this list already, and I've found it
really helpful. Some people just find it in their human nature to ask
questions first. What some people refer to as "dumb" questions could be
something really serious to a person who is just getting started. How many
peopl
At 05:58 PM 1/10/01, Carlos Corzo wrote:
>Some people have tried the manuals verbatim but are really confused
>because they are not at your intellectual level. If this list is for
>the "intelligent only", change the title please. Not everyone can
>decipher a manual. I may post questions but the
Carlos Corzo wrote:
> Some people have tried the manuals verbatim but are really confused
> because they are not at your intellectual level. If this list is for
> the "intelligent only", change the title please. Not everyone can
> decipher a manual. I may post questions but there are reasons
Some people have looked at the manual's, yes, and it's pretty simple to
determine when they have. If the question they ask can be copied/pasted
into the mysql documention search and get the answer, then the person has
not checked the documentation. Sometimes people miss things in the
documentati
Wow I didn't notice this. I believe this will solve my little permission
problem I've been having.
Thanks Neil.
-Matt
::-Original Message-
::From: Neil Zanella [mailto:[EMAIL PROTECTED]]
::Sent: Wednesday, January 10, 2001 3:05 PM
::To: MySQL Mailing List
::Subject: documentation error
try adding a -u (--user=) and -p, this will tell the mysql
server what user you are connecting as and it will prompt you for a
password.
It could be many other things though, depending on how you have set up
your access tables. It's usually a bad idea to not restrict connections by
either host o
> Possible fixes:
o Maybe (I know we've talked about this before), another solution is to have
the FT index in another file which could have its own cache size settings.
o Lastly, we could switch to using word tables that would use already
optimized caching of table and index data, but would req
On Wed, 10 Jan 2001, Don wrote:
> How do I set the initial root password once installation is complete?
> Sorry for the repetition.
mysqladmin -uroot password 'newpassword'
(mysqld has to be running for this to work)
--
-
Ple
Hello,
I am running Red Hat Linux 6.2 which is supposedly the platform on
which the latest MySQL RPMs were built. However there are problems
when I try to install the package even though I follow the instructions
in the manual:
[root@tulip /tmp]# rpm -i MySQL-3.23.30-1.i386.rpm
error: failed d
Hi ,
Here the situation :
Many of us , are using MYSQL in Web production , and in this case we have many
loadbalancing systems (Hardware like Alteon or foundry or software like LVS , and
hybrid like BigIP) so we can say that if you want an failsafe and scalable WEB cluster
it not a problem any
Hello,
There is a documentation error the MySQL manual:
--
4.6 Installing a MySQL Binary Distribution
9.Change ownership of the installation directory to the user that you will
run mysqld as:
shell> chown -R mysql /usr/local/
In the last episode (Jan 10), B. van Ouwerkerk said:
>
> >Well, enough ranting, now how about some ideas to help fix the problem :)
> >
> >Maybe if this list was moved from an open list to a moderated one we
> >would see a drop? Also, might it be possible to move the manual
> >comments to anothe
Some people have tried the manuals verbatim but are really confused
because they are not at your intellectual level. If this list is for
the "intelligent only", change the title please. Not everyone can
decipher a manual. I may post questions but there are reasons for
them. My time is just as
>Well, enough ranting, now how about some ideas to help fix the problem :)
>
>Maybe if this list was moved from an open list to a moderated one we would
>see a drop? Also, might it be possible to move the manual comments to
>another list? :)
This has been discussed before.
It seems I can't fi
LOAD DATA LOCAL INFILE '/path/myfile.txt'
INTO TABLE mytable
FIELDS TERMINATED BY '|';
If the text values are enclosed by double quotation
marks, you need to remove the semicolon in line 3 and
add:
ENCLOSED BY "\"";
If your myfile.txt was created in Windows, you *may*
need to remove the semicol
http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOAD_D
ATA
LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable FIELDS TERMINATED BY
'|'
- Original Message -
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 200
Well said. I have brought this up before in a mini rant of my own. I have
no gotten to the point that if a question is in the manual, I'm not going to
post a reply, simply because I can not take time from my day to give out
information that is quoted almost verbatim from (and linked to) the manu
The following comment was submitted to the MySQL Manual.
-
From: Ilia Lobsanov <[EMAIL PROTECTED]>
Regarding: http://www.mysql.com/manual.php?section=CREATE_TABLE
Would be nice if the DEFAULT parameter accepted a
lo
Maybe it is my depression and I see everything in black but please
read manual before posting questions in this list. Manual covers at
least 90% questions asked here. If manual does not cover them, we will
put new chapters in it. This is all because what we do in this list can
be called FREE
Hello,
can any one help me with my following mysqldump question.
I want to dump a complete database from one server to another server. I am
trying the following comment
mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase
when I tried, the remote host is failing with invalid log
Chris Matthews wrote:
>
> Okay, so no jokes about telling my client, Ron, to go buy more memory... =)
>
> error is: "MySQL Client Run out of Memory"...
>
> > We get this error about every 2 weeks or so... Restarting MySQL, purging
> > hosts don't fix it, we actually have to restart Apache to fi
63 matches
Mail list logo
