:47 PM
To: Hathaway, Scott L
Cc: [EMAIL PROTECTED]
Subject: Re: Windows 2003 read-only problem
Have you tried connecting with this user directly from the MySQL
monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from
IIS 6. I access the latest 4.0x
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as has update
privileges (all privileges, actually). We checked the file permissions
to the Mysql
I went to the download site to get 4.04. I noticed that there is a pro
version now. What is the difference between MySQL, MySQL Pro, and MySQL
Max? I looked at the products page on the website, but I am just not clear.
I do understand that MySQL does not have transactions and the other two do,
I am trying to get something like the following:
Title
-
topic #1
sub topic #1.1
topic #2
sub topic #2.1
sub topic #2.2
from the following table (I am using php for scripting).
forum
id int
parent_id
I deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
-
Before posting, please check:
:14 AM
To: Hathaway, Scott L
Subject: Re: database restore - please help
Hi Scott,
One more simple way..u should have the mysql back ..copy the dir from
\mysql\data (Old dir ) having name of the database. Copy to the new
\mysql\data (current).
Or delete the dir having name as database name cut
Given your query, you would access it like:
$avgField = $avg-fields['avg(fieldname)'];
You can also change your query to use an alias like:
select avg(fieldname) as theAvg from tablename
HTH,
Scott
-Original Message-
From: bobbie bob [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21,
I have an sql question. I have a table that holds user information that
includes their id and who they report to.
user
-
id (int)
supervisor (int)
This heirarchy goes several levels deep. Without changing the db structure,
what is my easiest way to determine if user x is a supervisor for
Isn't it true that for last_insert_id to work that it gets this value from a
connection, so if you are using a database library that uses separate
connections to the database between server trips that this function does not
work (like when doing web programming)?
Scott
-Original
I would not look at front ends to mySQL. Instead, I would let them keep
using access to do this and link them to the mySQL database or get an SQL
query tool that allows for graphical queries.
Scott
-Original Message-
From: Pierre du Parte [mailto:[EMAIL PROTECTED]]
Sent: Saturday,
Yes, that should only cause a reordering within the group itself, but in my
case, the group breaks into two groups!
Scott
-Original Message-
From: Michael Zimmermann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:58 AM
To: Hathaway, Scott L; Mysql (E-mail)
Subject: Re: help
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.
I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header
function is just that a couple of the .inc files with phpMyAdmin need to
have the extra lines after the ? deleted. But, that message says that the
headers have already been sent out. The error below usually means a 404
error
Does anyone know what is wrong with my syntax? (the sql statement works in
mssql server)?
SELECT user.*, wbs.name
FROM wbs INNER JOIN (user INNER JOIN user_wbs ON user.id =
user_wbs.user_id) ON wbs.id = user_wbs.wbs_id
Thanks,
Scott
14 matches
Mail list logo