Hi all,
I'm using 3.23.49a-max-log and as a temporary fix for a disk space
problem, I shut mysql down,, moved some database files to different
partitions on the system and symlinked them back into the datadir.
Everything seems to work ok... So far... Mysql came up with no errors,
selects and in
On Fri, May 21, 2004 at 08:01:31PM -0400, [EMAIL PROTECTED] wrote:
> Luis - you're quite polite so I'll assume that you are ignorant rather than
> prejudiced.
I'm polite since I wanted to be respectful but honest at the same time.
> You have a university email so I'll also assume you're a studen
mos wrote:
At 05:08 PM 5/22/2004, you wrote:
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are "inspirational" quotes that
I want
to appear at the bottom of the pages of my website. I want them to
come up
randomly wi
mos wrote:
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
At 05:08 PM 5/22/2004, you wrote:
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are "inspirational" quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
35,000 que
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are "inspirational" quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page load. How do I randomly access re
How's that for alliteration in a subject line?
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are "inspirational" quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page lo
John Mistler wrote:
Aha, this revealed the .pid:
/usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/data/John-Mistlers-
Computer.local.pid
Now, this brings up a new question. Is there a "sudo find" command I can
use to locate the proper .pid on any given computer? I am hard coding this
into
"Paul West" <[EMAIL PROTECTED]> wrote:
> Here are some easy questions I hope you can answer.
> I have been creating innoDB tables in mysql, creating contraints and foreign keys
> and it
> runs swimmingly.
>
> The server I am now doing mySQL on won't allow me to create other than myISAM tables.
>
At 09:55 AM 5/22/2004, you wrote:
Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html
It generates random data for you.
> -Messaggio originale-
> Da: Greg Willits [mailto:[EMAIL PROTECTED]
> Inviato: venerdi 21 maggio 2004 21.17
> Cc: MySql
> Oggetto: Large sample data sets
Aha, this revealed the .pid:
/usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/data/John-Mistlers-
Computer.local.pid
Now, this brings up a new question. Is there a "sudo find" command I can
use to locate the proper .pid on any given computer? I am hard coding this
into an application th
John Mistler wrote:
I'm having trouble getting this line to work. I have tried:
kill `cat /usr/local/mysql/bin/mysql/data/localhost.pid`
-> Not a directory
kill `cat /usr/local/mysql/data/localhost.pid`
-> Permission denied
I'm not sure if I have the wrong hostname, or if the command is more flawe
I'm surprised it ever worked, if it was exactly as you gave us. You have
SUM(quantity)*100/ AS percentage
It looks like you intended to divide SUM(quantity)*100 by something, but
there's nothing there to divide by.
Michael
Aaron Wolski wrote:
Hi all,
Have a query that used to work on one serve
I'm having trouble getting this line to work. I have tried:
kill `cat /usr/local/mysql/bin/mysql/data/localhost.pid`
-> Not a directory
kill `cat /usr/local/mysql/data/localhost.pid`
-> Permission denied
I'm not sure if I have the wrong hostname, or if the command is more flawed
than that. Furt
Hi all,
Have a query that used to work on one server but then MYSQL version was
upgraded and now it no longer works. Here's the query:
SELECT *, SUM(quantity)*100/ AS percentage FROM CartTable WHERE company
='1' AND submitted='1' AND dateinserted>='946702800' AND
dateinserted<='1085247047' AND pr
Aysun Alay wrote:
Our application needs to support both solaris 8 and solaris 9. I was
wondering if mysql has a backwards compatibility in terms of operating
systems. Can I use mysql-pro-4.0.20-sun-solaris2.9-sparc.tar file to
install mysql on Solaris 8?
Not sure, but it is usually not too hard to
On May 22, 2004, at 2:12 AM, John Mistler wrote:
In the larger picture, I am wondering if there is a way to avoid all of
this. Ideally, I would like for the application to come packaged with
MySQL, to install MySQL automatically (not sure what happens if MySQL
already exists on the system), and to
Hi Michael,
Thank you very much. It works good.
Regards,
Laercio.
>
> Laercio Xisto Braga Cavalcanti wrote:
>
>> Hi all,
>>
>> I'm using mysql 3.23.54 under RedHat9 trying to update a field named
>> pac_fone in a table named paciente with the value of a field named
>> ita_fone from a table name
Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html
It generates random data for you.
> -Messaggio originale-
> Da: Greg Willits [mailto:[EMAIL PROTECTED]
> Inviato: venerdi 21 maggio 2004 21.17
> Cc: MySql
> Oggetto: Large sample data sets for testing
>
>
> Anyone know
amd64f# ./run-all-tests --server=mysql --cmp=mysql --user=root
--password=theword --log
Warning: Can't execute create. Check the file
'output/create-mysql-FreeBSD_5.2_CURRENT_amd64-cmp-mysql'
^CWarning: Can't execute insert. Check the file
'output/insert-mysql-FreeBSD_5.2_CURRENT_amd64-cmp-mys
On Sat, 22 May 2004, John Mistler wrote:
> do shell script "kill cat /usr/local/mysql/bin/mysql/data/localhost.pid"
The kill command takes a numeric PID as its argument. You need to get
the pid out of the pidfile. So to get the above to work you have to
enclose cat and the filename in backticks
I have two tables one is the gallery and the other one is table for
events so I can categorise the images.
Now I wan't to get all the rows from events (id, event, date) in
cronological order by date. But I also wan't a random row (id, , ext,
*_nail) from the gallery where gallery.event is equal
A couple of questions for any Mac users willing to help:
I have created an application for OS X.3 that talks to the MySQL server with
shell commands. In order for those commands to work, I have to include a
proper username and password to access the MySQL database designated for my
app within the
When it will be avalaible to download ?
regards
massimo
-
Massimo Petrini
c/o Omt spa
Via Ferrero 67/a
10090 Cascine Vica (TO)
Tel.+39 011 9505334
Fax +39 011 9575474
E-mail [EMAIL PROTECTED]
--
MySQL General Mailing List
For list
Hi Folks,
Here are some easy questions I hope you can answer.
I have been creating innoDB tables in mysql, creating contraints and foreign keys and
it runs swimmingly.
The server I am now doing mySQL on won't allow me to create other than myISAM tables.
Is it true that only innoDB tables sup
26 matches
Mail list logo
