On Sep 23, 2008, at 1:16 PM, Mel wrote:
On Tuesday 23 September 2008 15:54:10 John Almberg wrote:
I have two FreeBSD machines. One is a application server, the other a
database server running mysql. These machines are in two different
locations. I'd like to allow the application server
this
error happens we CAN log onto the server with the MySQL database, but I
CAN NOT use the mysql client to connect to the mysql database (localhost
connection as root) - it reports the error mentioned above. The way we
temporarily solve the problem is to restart one of our web servers.
Here is our
out). When
this error happens we CAN log onto the server with the MySQL database,
but I CAN NOT use the mysql client to connect to the mysql database
(localhost connection as root) - it reports the error mentioned
above. The way we temporarily solve the problem is to restart one of
our web
I have two FreeBSD machines. One is a application server, the other a
database server running mysql. These machines are in two different
locations. I'd like to allow the application server to access mysql
through an SSH tunnel.
Being a newbie admin, I've never set up an SSH tunnel. I've
John Almberg wrote:
I have two FreeBSD machines. One is a application server, the other a
database server running mysql. These machines are in two different
locations. I'd like to allow the application server to access mysql
through an SSH tunnel.
Being a newbie admin, I've never set up
On Tuesday 23 September 2008 15:54:10 John Almberg wrote:
I have two FreeBSD machines. One is a application server, the other a
database server running mysql. These machines are in two different
locations. I'd like to allow the application server to access mysql
through an SSH tunnel.
Any
On Tuesday 23 September 2008 12:13:58 Sam Nilsson wrote:
DB Servers: One Master, Two Read Only (replication)
4 GB of Memory on each server
FreeBSD 6.3-RELEASE-p3 FreeBSD 6.3-RELEASE-p3
MySQL 5.0.1
Here are some relevent items from my.cnf:
- set-variable = max_connections=1000
Vincent Hoffman wrote:
If you havent already, you could try increasing the per process memory
limit as per examples in
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/hackers/2008-05/msg00258.html
(man tuning also says a bit about these tuneables but doesnt have the
examples that post does)
I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today.
I ran mysql_install_db and then assigned the root password. I tried to get it
running on boot (mysql_enable=YES) and by hand
(/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start.
What else
On Monday 08 September 2008, Joe Tseng said:
I've got a server running FreeBSD7 and got MySQL 5.0.67 installed
on it today. I ran mysql_install_db and then assigned the root
password. I tried to get it running on boot (mysql_enable=YES)
and by hand (/usr/local/etc/rc.d/mysql-server start
:05 mysqld ended
So my questions are:
1. What directory is it referring to? Is it /var/db/mysql by default? I just
tried to give ownership using chown -R mysql /var/db/mysql but that made no
difference.
2. I've read also for this kind of issue I have to reinstall the software...
When I
: File operation call: 'create'.
InnoDB: Cannot continue operation.
080908 13:35:05 mysqld ended
So my questions are:
1. What directory is it referring to? Is it /var/db/mysql by default? I
just tried to give ownership using chown -R mysql /var/db/mysql but that made
no difference.
2. I've
: 'create'.
InnoDB: Cannot continue operation.
080908 13:35:05 mysqld ended
So my questions are:
1. What directory is it referring to? Is it /var/db/mysql by
default? I just tried to give ownership using chown -R mysql
/var/db/mysql but that made no difference. 2. I've read also for
this kind
Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it...
Thx to all for the help.
- Joe
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 8 Sep 2008 11:46:02 -0800
CC: freebsd-questions@freebsd.org
Subject: Re: Can't start MySQL 5.0.67
On Monday 08
Joe Tseng wrote:
Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did
it... Thx to all for the help.
- Joe
[snip]
Look in /usr/local/share/mysql for my.cnf examples you can use for tuning
your install. One thing that bit me once was the location of the my.cnf
changed
I need to replicate MySQL DB of mulltiple server on SiteA to my DR-Site
Site_B... all DB
are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers.
I need a script to take Multiple MySql DataBase Backup and then import to
SiteB, the replica
can be done as cold or hotbackup and cron
On Sep 3, 2008, at 2:49 PM, Mad Unix wrote:
I need to replicate MySQL DB of mulltiple server on SiteA to my DR-
Site
Site_B... all DB
are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers.
I need a script to take Multiple MySql DataBase Backup and then
import to
SiteB, the replica
can
Found out how to do it:
# portinstall mail/maildrop -m WITH_AUTHLIB=YES
Choose MySQL as one of the possible authentication methods in the config
choices.
Hong
On Tue, Sep 02, 2008 at 04:48:33PM -0700, Hong wrote:
Hi,
How do I enable MySQL look-up when I install maildrop from the port
Hi,
How do I enable MySQL look-up when I install maildrop from the port system? I
looked at the Makefile:
# New ports collection makefile for:maildrop
# Date created: 16 November 1998
# Whom: Tom Hukins [EMAIL PROTECTED]
#
# $FreeBSD: ports/mail/maildrop/Makefile,v 1.50 2008/08
I upgraded to mysql-server-5.0.67 and got the error below so all
websites were in error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
The SOLUTION was:
Datadir is deprecated place for my.cnf, please move it to /usr/local/etc
-best regards ev
Hey All,
Recently I've been asked to do performance testing of postgres and mysql
on FreeBSD. Kris' page
(http://people.freebsd.org/~kris/scaling/mysql.html) was extremely
useful in giving me a starting point for my own comparisons.
Additionally, his name is splattered all over the web
Paul A. Procacci wrote:
My question is in reference to the 1st and 2nd graphs on this page.
While testing the performance of the databases given in this graph, the
one thing that sticks out is that when Mysql uses the myisam engine with
the ULE schedular, performance drops quite considerably
Kris Kennaway wrote:
Paul A. Procacci wrote:
My question is in reference to the 1st and 2nd graphs on this page.
While testing the performance of the databases given in this graph,
the one thing that sticks out is that when Mysql uses the myisam
engine with the ULE schedular, performance
I changed from 4.1.22 to 5.1.26.rc and my performance in a very busy db,
tanked!
could the use of an 'rc' possibly be my issue?
is there any chance that the 'rc' has debugging enabled which is slowing me
down?
--
Jim Pazarena [EMAIL PROTECTED]
___
Abdullah Ibn Hamad Al-Marri wrote:
- Original Message
From: Jim Pazarena [EMAIL PROTECTED]
To: FreeBSD freebsd-questions@freebsd.org
Sent: Friday, August 29, 2008 8:34:14 PM
Subject: Mysql Performance Question 4.1.22 vs 5.1.26.rc
I changed from 4.1.22 to 5.1.26.rc and my performance
Jim Pazarena wrote:
I changed from 4.1.22 to 5.1.26.rc and my performance in a very busy db,
tanked!
could the use of an 'rc' possibly be my issue?
is there any chance that the 'rc' has debugging enabled which is
slowing me down?
Hello,
I've ran some tests just this past week (in fact I
- Original Message
From: Jim Pazarena [EMAIL PROTECTED]
To: FreeBSD freebsd-questions@freebsd.org
Sent: Friday, August 29, 2008 8:34:14 PM
Subject: Mysql Performance Question 4.1.22 vs 5.1.26.rc
I changed from 4.1.22 to 5.1.26.rc and my performance in a very busy db,
tanked
I changed from 4.1.22 to 5.1.26.rc and my performance in a very busy db,
tanked!
why not 7?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
sorry i mistaken SQL versions with FreeBSD versions.
please ignore my last post
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Reordered for clarity -- David.
I used pkg_add (rather than sysinstall) to install MySQL 5.1 server on another
machine. While the port is called 'mysql-server-5.1.22', the package is called
'mysql51-server':
# cd /usr/ports/
# make search mysql
...
Port: mysql-server-5.1.22
Fraser Tweedale wrote:
put the following line in /etc/rc.conf:
mysql_enable=YES
and run (as root):
/usr/local/etc/rc.d/mysql-server start
# echo 'mysql_enable=YES' /etc/rc.conf
# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
# mysql
Welcome to the MySQL
To autostart mysql at boot add this to /etc/rc.conf
mysql_enable=YES
Add this to /etc/rc.conf to direct to use this location where there is disk
space
to hold your databases
mysql_dbdir=/usr/local/mysql
To start or stop mysql server do this
/usr/local/share/mysql/mysql.server start
/usr/local
freebsd-questions:
I am a FreeBSB noob who has read http://nostarch.com/abs_bsd2.htm and is
attempting to build a FreeBSD 7.0 box for Apache/ MySQL/ Perl applications.
I've installed mysql-server-5.1.22 via sysinstall from ftp1.us.freebsd.org, but
I am unable to figure out how to start it.
RTFM
Try adding mysql_enable=YES to /etc/rc.conf after this is done try starting
again via the rc script. In the future pass the parameter rcvar to the rc
script.
Eg. /usr/local/etc/rc.d/mysql-server rcvar
mysql_enable=YES this would indicate what to add to rc.conf
Sent from my BlackBerry device
On Tue, Aug 26, 2008 at 09:57:10PM -0700, David Christensen wrote:
freebsd-questions:
I am a FreeBSB noob who has read http://nostarch.com/abs_bsd2.htm and is
attempting to build a FreeBSD 7.0 box for Apache/ MySQL/ Perl applications.
I've installed mysql-server-5.1.22 via sysinstall from
On 11/08/08 23:23, Johnson, James wrote:
Thanks Chris, I'll look into this. Have you or anyone you know ever set
something like this before? What I'm trying to do is replace our name
servers, they will be Virtualized.
I have several nameservers running from a replicated MySQL database
Does any know how to make mysql and BIND work together.
I found this, it's similar to what I want to do.
http://gentoo-wiki.com/HOWTO_Setup_Bind_with_DLZ,_MySQL_and_replication
James Johnson
___
freebsd-questions@freebsd.org mailing
On 11/08/08 19:17, Johnson, James wrote:
Does any know how to make mysql and BIND work together.
Configure bind with --with-dlz-mysql. I seem to recall that using
--disable-threads is also recommended with MySql. Lots of info at
http://bind-dlz.sourceforge.net/
There is an issue
3:04 PM
To: Johnson, James
Subject: Re: mysql and BIND 9.4.2
On 11/08/08 19:17, Johnson, James wrote:
Does any know how to make mysql and BIND work together.
Configure bind with --with-dlz-mysql. I seem to recall that using
--disable-threads is also recommended with MySql. Lots of info
I de-installed mysql41-client / scripts / server from my FreeBSD 7.0 system, and
attempted to make and install MySQL51, and I have encountered the following
error.
It appears that an empty field has defined mysql-client EVEN THO I have
installed
mysql51-client without mishap.
Is there a fix
Hi! I need two MySQL servers run simultaneously. But when I try to run server I
have
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I had read something about it, but don't find what can help me!
С уважением. Тарас Голуб
-- реклама
Òàðàñ wrote:
Hi! I need two MySQL servers run simultaneously. But when I try to run server I
have
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Does this happen when you try to start the first instance, or starting
the second instance when
Steve Bertrand wrote:
Òàðàñ wrote:
Hi! I need two MySQL servers run simultaneously. But when I try to run
server I have
and then, I believe if you add this to your /etc/my.cnf file:
[mysqld]
socket=/tmp/mysql.sock2
...after thinking about it, this would likely cause both daemons
On Friday 11 July 2008 15:46:25 Тарас wrote:
Hi! I need two MySQL servers run simultaneously.
Why?
But when I try to run
server I have
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Use jails if you have really need to, or start each of them
Hello.
I have a problem with mysql logs and newsyslog. I archive mysql log
with this in my my.cnf:
log=/var/log/mysql
My log works fine.
However, when newsylog archives the log and create a new log file,
mysql doesn't log anymore anything.
See my newsyslog.conf:
/var/log/mysql mysql:wheel 640
hi all...
i just installed openssl 0.9.8h and trying to build mysql 5.0.51b with
it on a freebsd 7 machine. i get this:
/usr/bin/ld: /usr/local/ssl/lib/libssl.a(t1_srvr.o): relocation
R_X86_64_32 can not be used when making a shared object; recompile with
-fPIC
/usr/local/ssl/lib/libssl.a
flags i can change in the Makefile for the mysql build?
does it have to be a 'shared'? static?!
thanks...
kalin m wrote:
hi all...
i just installed openssl 0.9.8h and trying to build mysql 5.0.51b with
it on a freebsd 7 machine. i get this:
/usr/bin/ld: /usr/local/ssl/lib/libssl.a
kalin m [EMAIL PROTECTED] wrote:
i just installed openssl 0.9.8h and trying to build mysql 5.0.51b with it
on a freebsd 7 machine. i get this:
/usr/bin/ld: /usr/local/ssl/lib/libssl.a(t1_srvr.o): relocation R_X86_64_32
can not be used when making a shared object; recompile with -fPIC
/usr
Hello.
In my rc.conf, I have:
dovecot_enable=YES
mysql_enable=YES
At boot, I have this error:
Jun 16 12:34:16 trinite dovecot: auth-worker(default): mysql: Connect failed to
localhost (panel): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) - waiting for 1 seconds
Nicolas Letellier wrote:
Hello.
In my rc.conf, I have:
dovecot_enable=YES
mysql_enable=YES
At boot, I have this error:
Jun 16 12:34:16 trinite dovecot: auth-worker(default): mysql: Connect failed to
localhost (panel): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2
On Mon, 16 Jun 2008 14:08:40 +0300
Manolis Kiagias [EMAIL PROTECTED] wrote:
Nicolas Letellier wrote:
Hello.
In my rc.conf, I have:
dovecot_enable=YES
mysql_enable=YES
At boot, I have this error:
Jun 16 12:34:16 trinite dovecot: auth-worker(default): mysql: Connect
failed
Nicolas Letellier wrote:
Hello.
In my rc.conf, I have:
dovecot_enable=YES
mysql_enable=YES
At boot, I have this error:
Jun 16 12:34:16 trinite dovecot: auth-worker(default): mysql:
Connect failed to localhost (panel): Can't connect to local MySQL server
through socket '/tmp
On Mon, 16 Jun 2008 15:59:21 +0200
Johan Hendriks [EMAIL PROTECTED] wrote:
Does you're my.cnf file contains an entry that needs to be resolved by
dns and if so can it be resolved!
Maybe named is not started before mysql.
Try setting that entry in /etc/hosts.
No, it does not contains any
the question is: how do I set the root password on mysql? this is a
first step in getting phpbb3 up. i have other CMS tools installed
on aristotle, m jail where my webserver runs.
this failed:
mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Access
Gary Kline [EMAIL PROTECTED] wrote:
the question is: how do I set the root password on mysql? this is a
first step in getting phpbb3 up. i have other CMS tools installed
on aristotle, m jail where my webserver runs.
this failed:
mysqladmin -u root password
mysqladmin: connect
Your mysql server already has a password for user root.
2 options
1 - mysqladmin -u root -p password
Of course I think you dont know current password or you wouldnt be
askingso second option
Read
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
On Wed, Jun 11, 2008 at 09:19:26PM -0400, Sahil Tandon wrote:
Gary Kline [EMAIL PROTECTED] wrote:
the question is: how do I set the root password on mysql? this is a
first step in getting phpbb3 up. i have other CMS tools installed
on aristotle, m jail where my webserver runs
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
Dual Rank DIMMs) 667MHz FBD
6 x 450GB SAS 15k 3.5 HD Hot Plug
PERC 6/i, Integrated Controller Card x6 backplane
PE2950 III C5 MSS R10 Add-in PERC 5/i / 6/i 1 S
TCP/IP Offload Engine 2P
Broadcom TCP/IP Offload Engine functionality (TOE) Not Enabled
For FreeBSD 7.0-RELEASE amd64 Which MySQL 5.0
7.0-RELEASE amd64 Which MySQL 5.0 would be used ?
1. FreeBSD 7.x (x86_64)
or
2. FreeBSD 6.x (x86)
I have done some googling and made these configuration files for Apache and
MySQL?
Apache:
httpd.conf-start
MySQL:
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-networking
skip-name-resolve
server-id=1
#2008-02-10
max_connections=499
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=256
connect_timeout=10
myisam_sort_buffer_size=32M
key_buffer=16M
Zbigniew Szalbot wrote:
Will any future upgrade (by means of portupgrade) not change the custom
mysql location back to /var/db/mysql?
Not if you set:
mysql_dbdir=/usr/mysql
in /etc/rc.conf
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 7 Priory
the binary
logging beneficial.
I can think of a reason for FreeBSD. The binary logs are never deleted
and upon every server restart a new one is created. If you're like me,
developing on a laptop with a webenvironment including 'Mysql server',
shutting down your laptop daily, you quickly find
Hello,
Following a recent thread I would like to ask if it is safe to remove
old binlog data. From the below I understand that the current binlog is
mysql-bin.07 and the previous ones (from 01-06) are not
written to any more. I just need confirmation before I take any action
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Zbigniew Szalbot wrote:
Hello,
Following a recent thread I would like to ask if it is safe to remove
old binlog data. From the below I understand that the current binlog is
mysql-bin.07 and the previous ones (from 01-06
On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote:
Hello,
Following a recent thread I would like to ask if it is safe to
remove old binlog data. From the below I understand that the
current binlog is mysql-bin.07 and the previous ones (from
01-06) are not written to any
Hello,
Chris Pratt pisze:
On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote:
Hello,
Following a recent thread I would like to ask if it is safe to
remove old binlog data. From the below I understand that the
current binlog is mysql-bin.07 and the previous ones (from
01-06
in a safe way.
I only wonder now how to set up a cron job to do it on a permanent
basis?
1/ I would probably be better off setting this mysql query (URGE
{MASTER | BINARY} LOGS BEFORE 'date') in a separate file an run it
from cron?
2/ Even if I do that, I would still have to change the 'date
on the 5.0 version of the mysql
doc page that shows a unix way to set up a cron script
and automate the process. I've not tried it.
Shrinking /var partition?: I found the ports setup of mysql to
be overly restrictive by using the /var method. It was simple
to install, shutdown mysqld, copy the contents
. There is an example in the reply comments
below the documentation on the 5.0 version of the mysql
doc page that shows a unix way to set up a cron script
and automate the process. I've not tried it.
Shrinking /var partition?: I found the ports setup of mysql to
be overly restrictive by using the /var method
Can someone direct me to where the MySQL transaction logs are stored? I am
running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra
config. From what I've read online, unless you disable them (which I
couldn't find in the makefile) the logs should be being created. Doing
--On Thursday, May 01, 2008 13:45:32 -0400 John [EMAIL PROTECTED] wrote:
Can someone direct me to where the MySQL transaction logs are stored? I am
running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra
config. From what I've read online, unless you disable them (which I
On Thursday 01 May 2008 19:45:32 John wrote:
Can someone direct me to where the MySQL transaction logs are stored? I am
running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no
extra config. From what I've read online, unless you disable them (which I
couldn't find
Can someone direct me to where the MySQL transaction logs are stored?
I am running FreeBSD 6.1 with MySql 5.0.41 which I installed from
ports, no extra config. From what I've read online, unless you
disable them (which I couldn't find in the makefile) the logs should
be being created. Doing
-
From: Mel [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 01, 2008 2:23 PM
To: freebsd-questions@freebsd.org
Cc: John; [EMAIL PROTECTED]
Subject: Re: Recovering mysql data - mysqlbinlog
On Thursday 01 May 2008 19:45:32 John wrote:
Can someone direct me to where the MySQL transaction logs
a new one is created. If you're like me, developing
on a laptop with a webenvironment including 'Mysql server', shutting down
your laptop daily, you quickly find yourself having full /var partition.
People running dedicated or semi-dedicated MySQL installations, are encouraged
to tweak
for FreeBSD. The binary logs are never deleted and
upon every server restart a new one is created. If you're like me, developing
on a laptop with a webenvironment including 'Mysql server', shutting down
your laptop daily, you quickly find yourself having full /var partition.
That can be alleviated
the binary
logging beneficial.
I can think of a reason for FreeBSD. The binary logs are never deleted
and upon every server restart a new one is created. If you're like me,
developing on a laptop with a webenvironment including 'Mysql server',
shutting down your laptop daily, you
One of our FreeBSD 6 servers got rebooted and when it came back we found
that /usr/local/lib/mysql was not amongst the directories on the
standard ldconfig paths.
Can someone gently explain how this is supposed to work. On our other
servers I see the both /usr/local/lib/apache2 and /usr
On Apr 25, 2008, at 11:03 AM, Robin Becker wrote:
One of our FreeBSD 6 servers got rebooted and when it came back we
found that /usr/local/lib/mysql was not amongst the directories on
the standard ldconfig paths.
Can someone gently explain how this is supposed to work.
Your mysql binary
On Sat, Feb 16, 2008 at 12:57 PM, Peter Boosten [EMAIL PROTECTED] wrote:
Hi all,
Just after upgrading the mysql client to mysql-client-5.1.23 on 6.3, it
seems that it's completely ignoring ~/.my.cnf.
Anyone else has this problem?
Peter
I just ran into the same problem on 7.0
, then fsync the file to guarantee that it's been
committed to disk. Of course, depending on how you'll need to access
this data later, this may not be the best approach.
I don't know the details of how MySQL does or does not guarantee that
your data is safely on disk, but I can say that PostgreSQL
web apps in PHP using MySQL as the
backend database, only this time I need transaction services.
According
to the PHP manual if a transaction is served for MySQL it can come
back
as committed even though it may not. So what I'm trying to accomplish
is
develop some row level
Hi.
I've installed from ports mysql-server-5.0.45_1 on FreeBSD 7.0 and see
what happens:
# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
[EMAIL PROTECTED] ~]$ #I will hit now CTRL+D
[EMAIL PROTECTED] ~]$ exit
[EMAIL PROTECTED] ~]#
So, a shell from the user mysql is started
a component sm which depends on mysql for it's data storage.
Since it takes a second on my system for mysqld to establish it's
listening socket sm fails which takes down all of jabberd I
patched the mysql-server startup script to wait for up to 15 seconds
before termination. This fixes
I know this is not quite the list for these things, but I tried the PHP
list and got no reply whatsoever. In fact, I don't think anyone's home
cause the entire list is silent...
I'm trying to setup a system using web apps in PHP using MySQL as the
backend database, only this time I need
Da Rock [EMAIL PROTECTED] wrote:
I know this is not quite the list for these things, but I tried the PHP
list and got no reply whatsoever. In fact, I don't think anyone's home
cause the entire list is silent...
I'm trying to setup a system using web apps in PHP using MySQL as the
backend
a system using web apps in PHP using MySQL as the
backend database, only this time I need transaction services. According
to the PHP manual if a transaction is served for MySQL it can come back
as committed even though it may not. So what I'm trying to accomplish is
develop some row level
this is not quite the list for these things, but I tried the
PHP
list and got no reply whatsoever. In fact, I don't think anyone's home
cause the entire list is silent...
I'm trying to setup a system using web apps in PHP using MySQL as the
backend database, only this time I need
in PHP using MySQL as the
backend database, only this time I need transaction services. According
to the PHP manual if a transaction is served for MySQL it can come back
as committed even though it may not. So what I'm trying to accomplish is
develop some row level locking with the PHP script.
I
After a long process of figuring out what went wrong, httpd was using a
ton of resources when it received a HUP signal (log rotation at
midnight). Subsequently, php -v was dumping core things pointed to
mysqli.so.
Long story short, I downgraded to mysql-4.10, recompiled php5
Hi all,
Just after upgrading the mysql client to mysql-client-5.1.23 on 6.3, it
seems that it's completely ignoring ~/.my.cnf.
Anyone else has this problem?
Peter
--
http://www.boosten.org
___
freebsd-questions@freebsd.org mailing list
http
Hi,
I'm trying to setup maildrop to work with my postf, dovecot and mysql mail
server.
I installed maildrop successfully.
This is what I used to install it
cd /usr/ports/mail/maildrop; make WITH_AUTHLIB=yes WITH_MAILDIRQUOTA=yes
install clean
At the blue prompt I selected mysql and it installed
To answer my own question, I had the authmysqlrc file set up wrong.
Its working now
On Mon, January 28, 2008 13:06, Reinhold wrote:
Hi,
I'm trying to setup maildrop to work with my postf, dovecot and mysql
mail server. I installed maildrop successfully.
This is what I used to install
On Thu, Jan 17, 2008 at 11:00:46AM -0600, Jack L. Stone wrote:
Am running FBSD-6.2p10
Recently, I upgraded MySQL-4.1.22 to 5.0.x and while things seem to work
okay, I keep getting this warning in phpMyAdmin:
Your PHP MySQL library version 4.1.22 differs from your MySQL server
version
Am running FBSD-6.2p10
Recently, I upgraded MySQL-4.1.22 to 5.0.x and while things seem to work
okay, I keep getting this warning in phpMyAdmin:
Your PHP MySQL library version 4.1.22 differs from your MySQL server
version 5.0.51. This may cause unpredictable behavior.
Perhaps my manner
Hello,
Wonder if you know whether it is possible to change mysql server data
dir from the default /var/db/mysql. I looked through my-small.cnf but
found no option called datadir.
If anyone knows how to change or where to look for compile-time options
to set a custom datadir, I'd very much
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Wonder if you know whether it is possible to change mysql server data
dir from the default /var/db/mysql. I looked through my-small.cnf but
found no option called datadir.
If anyone knows how
Hello,
I'd installed the mysql51-server port (actual snapshot, FBSD6.2r)
After install I ran the create DBs scripts and tried to run a mysql
client locally.
Tried to run the mysqld manually and got a Socket error.
/temp/mysql.sock is not
I found the log file didnt log anything, so i started
running Mysql
5.X on this server and the performance of MySQL is very bad. For some
complexe select I've got ~6secondes (on some basic Linux it's take 0.6
sec). And I think this is nothing about thead (that's mean I don't think
FreeBSD 7.0 can solve my problem) because it's just for one select
301 - 400 of 1650 matches
Mail list logo