Ryan McDougall wrote:
when I do this this is what I get:
starting mysql with databases from /var/lib/mysql
This may be your culprit right here... not sure where the mysql_install_db
defaults its installs to, but I'm guessing its not /var/lib/mysql. And you
installed everything into
I wrote a sh script to use mysqldump to iterate through my databases and
dump them to .sql files, I am supplying no flags to mysqldump, and wonder,
is there a best way to dump your files, if the idea is they are backups
and to be used in the case of emergency.
Hello, Uttam;
We can simplify this, actually... any time L.idFilm is NULL (i.e., no
row in Loans is found), L.dateReturn will have to be NULL as well. So,
specifying the L.idFilm IS NULL condition is redundant. It's sufficient
to look only at L.dateReturn IS NULL in the WHERE clause.
Yours
John,
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box
using RPMs. The install seems to go well, but the log file
contains:
mysqld: Can't find file: './mysql/host.frm'
From the docs, I understand this happens because I haven't set up
the grant tables, but how can I do
use the -opt flag.
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:27 PM
To: MySql
Subject: Best way to dump for daily archiving
I wrote a sh script
On 01-Mar-2003 Scott Haneda wrote:
I wrote a sh script to use mysqldump to iterate through my databases and
dump them to .sql files, I am supplying no flags to mysqldump, and wonder,
is there a best way to dump your files, if the idea is they are backups
and to be used in the case of
on 03/01/2003 3:03 PM, Cal Evans at [EMAIL PROTECTED] wrote:
use the -opt flag.
Can you tell me how to add in the username as well, I get a
./bin/mysqldump: invalid option -- o error
Here is the pertinent line
/usr/local/bin/mysqldump -uUserName $db $location$db.sql
ExpiryDate
On 28-Feb-2003 Jeff Snoxell wrote:
Hi,
If I run a mysql query then work through the results of that query one at a
time, deleting the record sometimes eg:
while (my $href = $sth-fetchrow_hashref())
{
if ($href-{'ExpiryDate'} eq '2003-02-22 00:00:00') {
# Do something
On 28-Feb-2003 Stitchin wrote:
This is so simple and basic, I must be missing something
I have php code for displaying my embroidery designs on the web page. It's
going through the mySql database and the query to pull up all the designs
for a
chosen category works fine. I have two
Try ...
/usr/local/bin/mysqldump -uUserName --opt $db $location$db.sql
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]; MySql [EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 5:18 PM
Subject: Re: Best way to dump for daily archiving
on
Is there a function that I missed for calculating the number of days in a
month?
Steffan
MySQL
---
T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
[EMAIL PROTECTED]
At 17:13 -0700 3/1/03, Steffan A. Cline wrote:
Is there a function that I missed for calculating the number of days in a
month?
No, but you can calculate it. One way:
- Find the first of the month
- Add a month
- Subtract a day. That gives you the last day of the month.
- Extract the
On 02-Mar-2003 Steffan A. Cline wrote:
Is there a function that I missed for calculating the number of days in a
month?
TO_DAYS()
mysql set @b:='2003-02-01';
Query OK, 0 rows affected (0.00 sec)
mysql set @e:='2003-03-01';
Query OK, 0 rows affected (0.00 sec)
mysql SELECT TO_DAYS(@e) -
Hello,
I'm a bit confused about where the database is located in Mac OS X. I
was following the instructions in O'Reilly's boot using and Managing
MySQL ad got to the point where I tried to do a select and output to a
file. The command I ran was as follows:
SELECT * INTO OUTFILE 'books.dat'
At 19:46 -0500 3/1/03, Bernardo Zuniga wrote:
Hello,
I'm a bit confused about where the database is located in Mac OS X.
I was following the instructions in O'Reilly's boot using and
Managing MySQL ad got to the point where I tried to do a select and
output to a file. The command I ran was as
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
thanks for your help,
Bernardo
On Saturday, March 1, 2003, at
At 21:38 -0500 3/1/03, Bernardo Zuniga wrote:
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
Well, the book
Hello,
I must have installed mysql incorrectly because
my suse 8.0 server does not have a mysql.sock
file at all.
I installed mysql 3.23.48 from rpm packages
I installed
server
bench
client
Max
navigator
shared
and the required perl bench
What happened.
Can anyone email me a socket file?
Thx
--
Howdy,
I'm curious if anyone has used Visio with MySQL. I have Visio 2000
Developer edition and MySQL 3.23.54 on Win2k. Have successfully imported
two tables from my MySQL database into Visio to create a Database Model
Diagram. I then added several more tables and tried to run the Update
tool but
There were no errors and it listed a number of rows affected and a
time. tried the command again and it said that the file already
existed. The problem was the directory path that I was looking in. I
couldn't see it in the GUI but in the terminal a find pointed me to the
file. I wasn't able to
I need to make a change to a field in a table and don't know how to
write the correct sql statement. I made an error and now have a date
field with the year repeated twice - 01-01-03-03 - there are
aproximately 100 rows like this, and maybe 20 or so that are formatted
properly. How can I remove
All,
I want to develop application with Delphi which can connect to remote mysql server.
Whether I must install myODBC? If are there another way, please tell me? Thanks.
Best Regards,
Q.H. Liu
-
Before posting, please check:
I assume you are storing your dates in a char/varchar column - not a good
choice to start with... :-
Assuming all the values are supposed to be stored as MM-DD-YY (anothoer
marginal choice, but the problem may not rear its head again for another 96+
years), you can do the following:
UPDATE
Oops... forgot the subject line...
I have a complex JOIN statement that I can't seem to get to work.
Here is my schema...
I have a 'forsale' table with various colunms. Here is the query for
the data I am interested in:
SELECT
id,
clientid,
price
FROM
forsale
WHERE user_id = 152
*DISTINCT omits data bases on selected fields only. i.e. if you have
thousand rows having different dates in 'mydate' but all having year 2002,
then SELECT DISITNCT YEAR(mydate) will return only 1 row i.e. 2002.
* DISTINCTROW omits data based on entire duplicate records, not just
duplicate
here's my version of the answer:
SELECT
F.idFilm, F.title
FROM
Films F LEFT JOIN Loans L ON F.idFilm = L.idFilm
WHERE
(L.idFilm IS NULL) OR (L.dateReutrn IS NULL)
;
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01,
hi there my sql slave server cannot replicate as its getting permissions
errors dont know what happened but its not happy now
030302 7:09:24 Slave I/O thread killed while connecting to master
030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position
4
030302 7:09:29 Slave
Dear Mysql guru's
I have a sneaky suspision that the my current problem is related!
I want to display
There are '$number of records' in '$the city you have selected'
However this is proving to be beyond my brains capacity to deal with :p
So,if any of you can spot what the obvious mistakes I
$result=mysql_query(SELECT
items.*, city.City
FROM
items, city
WHERE
items.Category='$Category'
AND items.CityID='$CityName'
AND items.CityID=21
ORDER BY
City
);
while ($row=mysql_query($result)) {
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
Hi there!
Sorry, cause I didn't copy-n-paste those so there were typos, actually I
created the table in console:
1) create table test (id INTEGER NOT NULL AUTO_INCREMENT, name
This is a reposting since I haven't got any answer yet.
It is about the NullPointerException in class Connection
of MySQL Connector/J 2.0.14.
I just changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting this NullPointerException once in
a while. The new StackTrace is:
Description:
Dear sir,
When I execute the command select * from user_info where regdate now()- interval
9 day and phone_confirmed is null and email is null and last_onlinenow()-interval 10
day got 770 rows result.
But when I execute update user_info set email=1 where regdate now()-
Description:
Dear sir,
When I execute the command select * from user_info where regdate now()- interval
9 day and phone_confirmed is null and email is null and last_onlinenow()-interval 10
day got 770 rows result.
But when I execute update user_info set email=1 where regdate now()- interval
Hello,
Please do you know about any good solution for data mininig (clustering,
decision trees ..) that works fine with MySQL.
Thank you
With regards,
Pavel Kusch
-
Before posting, please check:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Holger Wiechert wrote:
This is a reposting since I haven't got any answer yet.
It is about the NullPointerException in class Connection
of MySQL Connector/J 2.0.14.
I just changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting this
Thanks for the clarification.
Is the MySQL list down? I was getting constant email before, and now I've
received nothing for almost 12 hours.
- Sheryl
- Original Message -
From: Uttam [EMAIL PROTECTED]
To: 'Sheryl Canter' [EMAIL PROTECTED]; 'Juan Nin'
[EMAIL PROTECTED]; [EMAIL
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains:
mysqld: Can't find file: './mysql/host.frm'
From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't
hi
have you run mysql_install_db ?
this sets up the mysql database initially
Peter
-Original Message-
From: John Almberg [mailto:[EMAIL PROTECTED]
Sent: 01 March 2003 20:44
To: [EMAIL PROTECTED]
Subject: Can't start mysql
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0
Greetings all,
May be a dumb question,...if I have a text file generated from
mysqldump, how do I reload that file into mysql? In the past I've
always copied and pasted it into mysql, but that takes a lot of
time,...especially as the databases grow! I do not have local access
to the server,
On Sat, Mar 01, 2003 at 05:11:29PM -0500, Jeff Mao wrote:
Greetings all,
May be a dumb question,...if I have a text file generated from
mysqldump, how do I reload that file into mysql? In the past I've
always copied and pasted it into mysql, but that takes a lot of
time,...especially as
40 matches
Mail list logo