after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_name| Value |
+--++
| system_time_zone | UTC
Wednesday, August 24, 2005, 5:11:14 PM, you wrote:
> Hi,
> I am going to implement a mysql hosting, and I would to make a question,
> if a mysql-user with only a "SELECT" privilege make this query:
> SELECT * FROM table1 INTO OUTFILE '/mysqldb/data/test.sql';
> the result is a file in this pat
PS
after mysql reinstallation (upgrade from 4.1.12 to 4.1.13) from source
code with EXACTLY THE SAME ./configure options as before and the SAME
configuration file everything is OK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
resuming all above i can say that to my greatest regret nobody even
expects what the matter is :(
so i'll just try to install a newer version of server hoping the bug
will disappear
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
>> Hello Nuno,
>>
>> Tuesday, July 26, 2005, 8:53:33 PM, you wrote:
>>
>>
>>>[EMAIL PROTECTED] wrote:
>>>(...)
>>>
When i try to execute the following query
>>>
>>>(...)
>>>
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect.
table2
GROUP
BY value2
(here count is replaced with MAX() for experimental purposes)
SELECT
COUNT(field1) as value1,
CONCAT(field2, '-') as value2
FROM
table1,
table2
GROUP
BY value2
(here distinct is removed)
SELECT
C
e2
FROM
table1,
table2
GROUP
BY value2
(here CONCAT(field2, '-') is replaced with CONCAT(field2, '') )
does anyone know what the matter is?
ps
my mysql version is
mysql Ver 14.7 Distrib 4.1.12, for unknown-freebsd4.6 (i386) using EditLine
wrapper
and
Hello
Is there any built-in way to set some kind of disk qoutas in mysql
(database quotas, quotas per user, etc )?
--
Best regards,
Sergey Averyanov mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
