On Sat, Jun 16, 2001 at 08:00:04PM -0500, Dan Nelson wrote:
> In the last episode (Jun 16), Jeremy Zawodny said:
> > Err, I forgot to mention that there's a "Using filesort" in the
> > output as well. That makes me believe it wants to write to disk (even
> > if there may be sufficient RAM).
>
> I
i had some others that i browsed into phpmyadmin and they seemed to
work, but others, like this one, showed a Query error -but that
"method" of "imported population" was probably wrong anyway, i guess.
thanks here's the file:
# MySQL dump 6.8
#
# Host: localhostDatabase: netsloth
#
Hi all,
I read in DuBois's MySQL, Perl DBI API Reference part, it is written:
$rv = $sth->rows();
Return the number of rows affected by the statement associated with $sth
or -1 if an error occured. This method is used primarily for statements
that do not return rows. For SELECT statements, you sh
What format are they in? Please paste a few sample lines.
> hello,
>
> i have some files from a Cd that are .dump files, how do i get these
> db into mysql? (is it possible using phpMyAdmin).
>
> again, these are ".dump" files, not ".sql" files.
--
hello,
i have some files from a Cd that are .dump files, how do i get these
db into mysql? (is it possible using phpMyAdmin).
again, these are ".dump" files, not ".sql" files.
thank you.
-
Before posting, please check:
htt
> Looks correct to me. Try running this query from the mysql program
> to verify that you're really matching the password of some entry:
>
> mysql> SELECT *, password('mypass') FROM user;
Hi guys,
I've solved the problem, but it was something related to the password
function.
In my user table,
I think the problem goes here:
> PHP4> $result = mysql_query("insert into user values ('$username',
> password('$password'), '$email')");
Please ensure $password is correct, and with no problem..
( eg. space/ at the enter of the string ... etc.. )
--
At 12:29 PM +0100 6/15/01, Michael Garthwaite wrote:
>I'm new to mysql and relatively new to java. I've downloaded a type
>4 driver from mm.mysql. I've put the folder containing the driver in
>my classpath and included the driver in my code as per the
>instructions as follows:
>
>try{
> Cla
At 9:30 PM -0400 6/16/01, William Wong wrote:
> > >PHP4> mysql_query("select * from user where username='myname' and passwd
>=
>> >password('mypass')");
>>
>> Define "doesn't work". Fails to return rows? PHP generates an error
>>message?
>
>Hi Paul,
>
>Sorry bout that. Yes it doesn't return
> >PHP4> mysql_query("select * from user where username='myname' and passwd
=
> >password('mypass')");
>
> Define "doesn't work". Fails to return rows? PHP generates an error
>message?
Hi Paul,
Sorry bout that. Yes it doesn't return any rows despite the fact that the
correct username and pass
At 8:49 PM -0400 6/16/01, William Wong wrote:
>Hi there,
>
>For some reason, this query doesn't work:
>
>PHP4> mysql_query("select * from user where username='myname' and passwd =
>password('mypass')");
Define "doesn't work". Fails to return rows? PHP generates an error message?
>
>WHILE this
In the last episode (Jun 16), Jeremy Zawodny said:
> Err, I forgot to mention that there's a "Using filesort" in the
> output as well. That makes me believe it wants to write to disk (even
> if there may be sufficient RAM).
I'm not sure "Using filesort" actually means it is going to create a
file
Hi there,
For some reason, this query doesn't work:
PHP4> mysql_query("select * from user where username='myname' and passwd =
password('mypass')");
WHILE this one does work:
PHP4> mysql_query("select * from user where username='myname' and
password('mypass')");
Notice the lack of "passwd = "
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote:
>Hello. I installed on my computer Red Hat Linux 7.0. After that I
>started configuring
>mysql. I upgraded mysql, added all necessary packages and I wanted
>to run mysql server.
Are you using RedHat's MySQL RPMs? If so, you should uninstal
I'm new to mysql.
I developed a unix korn shell script that performs three queries on our
database. Our DBA found corruption problems coincidental to my script
development. Is it possible that I could have corrupted the data with three
SELECT queries?
We are pretty fast-and-loose with security a
"Malkhaz Mangoshvili" <[EMAIL PROTECTED]> writes:
> Hello. I installed on my computer Red Hat Linux 7.0. After that I started
>configuring
> mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
>server.
> Whenever I type mysql it gives me such an error message: "
Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: "ERROR 2002: Can't connect to
MYSQL server through socket /v
Tobias Kjær Tobiasen wrote:
> Hello
> I have installed 2.23.32 from source - and I want to upgrade to the
> latest *rpm* (redhat 6.2@intel). How to do this? The database is in
> production so downtime should be avoided.. Can I do this:
> 1) Install the rpm on top of the source installation (
My application needs to insert between 200-500k rows about once a day...
When using MyISAM tables I determined the best way to get this done (while
still allowing users to perform select statements from the table) was to use
mysqlimport with --low-priority. This way all the inserts get bundled up
Hello,
Has anyone managed to compile the BETA version of MySQL 4 for Windows?
I have downloaded the source however, it appears to be for LINUX or UNIX.
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
On Sat, Jun 16, 2001 at 12:35:52PM -0500, Dan Nelson wrote:
> In the last episode (Jun 16), Jeremy Zawodny said:
> > Ah, thanks. The funny thing is that I *did* think to check the source
> > code for a different problem I ran into severl minutes later.
> >
> > I'll have to poke at this some more.
On Sat, 16 Jun 2001 14:33:44 -0500 (CDT), Don Read <[EMAIL PROTECTED]> wrote:
A heck of alot easier with Perl!(Just my opinion) :) Just disable RaiseError and
enable PrintError when using DBI
>>
>>On 16-Jun-01 Dawn H wrote:
>>> How do I make an error display, but still continue the script? Th
Ah. The subroutine bail_out() that I'm using is using die. Aha! :-)
Thanks,
=Dawn
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 16, 2001 2:39 PM
To: Dawn H
Cc: MySQL Email List
Subject: RE: Display error but continue script
On 16-Jun-01 Dawn H wrote
Hi,
I just installed Mysql from source for Linux. When I type the following command:
mysqladmin -u root password mysql
I got this error:
mysqladmin:connect to server@"localhost' failed
error:'access denied for user:'root@localhost'(using password:NO)'
Can some tell me how to correct this prob
On 16-Jun-01 Dawn H wrote:
> I'm using Perl
>
are you displaying your message with warn() or with die() ?
> Filter fixer: database,sql,query
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neigh
On 16-Jun-01 Dawn H wrote:
> How do I make an error display, but still continue the script? The error
> subroutine does not exit, but the original subroutine that calls it doesn't
> continue
> after the error message, it just quits.
>
A look at the code that does that would help ...
but:
$deb
I'm using Perl
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
MikeBlezien
Sent: Saturday, June 16, 2001 2:06 PM
To: Dawn H
Cc: [EMAIL PROTECTED]
Subject: Re: Display error but continue script
On Sat, 16 Jun 2001 13:47:29 -0500, "Dawn H" <[EMAIL PROTECT
How do I make an error display, but still continue the script? The error
subroutine does not exit, but the original subroutine that calls it doesn't
continue
after the error message, it just quits.
=Dawn H
http://www.rdcss.com/ - R&D Computer Solutions
http://wow.cooncheese.com/ - WOW.CoonCheese
Is it 'exactly' once every 10 times ??
You should check to make sure it's not an 'external' issue.
- Do you have a 'series' of DNS servers (like 10) that you use to lookup
system names (and 1 of them isn't working properly ?)
Try some other service (like 'pinging' the MySQL server from the P
Yeah I know, I'm googling and yahooing and etc for the last 3 days
but my math knowledge is still insufficient to write a PHP code for
this. Any kind soul who can stop my pain?
Vahan
Gary Huntress wrote:
>
> Here is the text of an email that I googled (eeek! its a verb!)
>
> The algorithm yo
Yes the server must be able to open the file. I dont know how you would
write a file path that accesses another machine heh.
ryan
> In order to add data to mysql, using LOAD INTO, am I right in thinking
> that this file has to be local to the machine. Therefore I have to ftp
> the file I want
Here is the text of an email that I googled (eeek! its a verb!)
The algorithm you need is called "single-source, shortest path", also
known as "Dijkstra's algorithm". Here's one way to implement it, in
pseudo-code.
Shortest route on graph of locations in Inform
In the last episode (Jun 16), Jeremy Zawodny said:
> Ah, thanks. The funny thing is that I *did* think to check the source
> code for a different problem I ran into severl minutes later.
>
> I'll have to poke at this some more. I just restarted with a 64MB
> maximum and one of my more common quer
Greetings All!
I'm looking for a code which will find the shortest route between 2 cities, with
data
being stored in SQL tables listed below. Anyone has coded such a task ever?
I'm including the structure of tables used.
CREATE TABLE Cities (
cityID int(4) unsigned NOT NULL auto_increment,
> I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
> machine. I also have PHP 4.0.5 installed. When I run mysql through PHP
> on my web server, I get a "Can't connect to MySQL server" warning error
> once every ten times I try to access a database. Is there something I
>
- Original Message -
> In the last episode (Jun 15), SDiZ Cheng said:
> > When i use mysqldump,
> > seems that MySQL will open all the tables in the database.
> > But, what i have is: a database will over 10,000 tables ..
> > I get a "Too much opened file" error on this..
> > I think incre
I would like to note that bug reports should only be sent out if you are
using the latest version, which now is 3.23.39.
--On Friday, June 15, 2001 17:37 -0600 Chris Bolt <[EMAIL PROTECTED]>
wrote:
>> After creating a new database, I ran:
>>
>> update user set password = 'SomeJunk' where user
The answer to ALL your 'where can I get it' questions is -
1) Freshmeat. www.freshmeat.net (Search for 'cscope'.)
2) Google. www.google.com (Repeat search)
Seaarch 1 results in this url: http://freshmeat.net/projects/cscope/
-Sander
> -Original Message-
> From: [EMAIL PROTECTED] [mailt
A better tool is Source Navigator,
available at Red Hat site.
It's Cscope on steroids!
Kevin
[EMAIL PROTECTED] wrote:
>
> On Fri, 15 Jun 2001, Dan Nelson wrote:
> > 30 seconds of cscope browsing on the mysql source shows the follwing
> ^^
>
On Fri, 15 Jun 2001, Dan Nelson wrote:
> 30 seconds of cscope browsing on the mysql source shows the follwing
^^
What is cscope? Where can I get it? =)
Sincerely,
Jan
--
Mr. Jan-Aage Bruvoll IT Project Manager
20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich
O
[EMAIL PROTECTED] writes:
> count() gives 0 but count(distinct) gives 1. is this correct or
> a bug or is there something wrong with my SELECT?
>
> mysql> create table t1 (f1 int);
> mysql> insert into t1 values (1);
> mysql> create table t2 (f1 int,f2 int);
> mysql> select t1.f1,count(t2.f2) fr
Mark W. de Raad writes:
> Good afternoon,
>
> We have an not-so-unusual problem where people are accessing a database from
> different countries (in this example, Germany and the UK). One of the search
> terms commonly used is: gehäuse (housing), which the UK types in as gehause
> and Germany (ri
sir,
i have a problem.can u please tell me the
process how i can transfer my database from MSSQL to
MYSQL.Is there any Wizard like import,export im MSSQL.
Please send me the details.
__
Do You Yahoo!?
Spot the hottest trends in music,
In order to add data to mysql, using LOAD INTO, am I right in thinking
that this file has to be local to the machine. Therefore I have to ftp
the file I want inserted to the machine running the MySQL server;
Correct?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
---
Pablo Prado writes:
> Hi all,
>
> I downloaded the both
> mysql-3.23.39-sun-solaris2.7-sparc.tar.gz
> mysqlgui-solaris-2.7-sparc-static-1.6
> a few days ago.
>
> While the sql server is running fine, I cannot get the gui to work.
> I gunziped it and made it executable using chmod u+x filename.
Hello
I have installed 2.23.32 from source - and I want to upgrade to the
latest *rpm* (redhat 6.2@intel). How to do this? The database is in
production so downtime should be avoided..
Can I do this:
1) Install the rpm on top of the source installation (I seems to me
that they are using diffe
Tim Williams writes:
>
> I've downloaded the mysql++ api and I'm trying to compile the examples
> but I keep getting these warnings I don't understand. When I compile ,
> using the Makefile provided I get the following warnings:
> custom1.cc:8:1 : warning: pasting "~" and "stock" does not g
count() gives 0 but count(distinct) gives 1. is this correct or
a bug or is there something wrong with my SELECT?
mysql> create table t1 (f1 int);
mysql> insert into t1 values (1);
mysql> create table t2 (f1 int,f2 int);
mysql> select t1.f1,count(t2.f2) from t1
-> left join t2 on t1.f1=t2.f
Hello Matthew,
Thursday, June 14, 2001, 12:18:08 AM, you wrote:
MR> Try this: update your ports, then build the mysql port with
MR> "WITH_LINUXTHREADS=1". This should result in a FreeBSD native binary
MR> linked against linuxthreads instead of libc_r, so it should use multiple
MR> processors.
H
On Fri, Jun 15, 2001 at 10:03:57PM -0500, Dan Nelson wrote:
>
> 30 seconds of cscope browsing on the mysql source shows the follwing
> comments right before calls to create_tmp_table():
>
> /* Create a tmp table if distinct or if the sort is too complicated */
> /* group data to new table */
>
At 08:00 AM 6/16/01 +, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>database,sql,query,table
>
>If you just reply to this message, and inc
51 matches
Mail list logo
