I think 'top' is showing the external view of the process and how many
pages total of heap have been allocated (under 'RES'). Possibly your
tuner program is just showing the size of the cache specifically.
-Will
Valentin Bud wrote:
Hello community,
I have mysql installed on FreeBSD 7.0
Norbert Papke wrote:
On April 6, 2009, DAve wrote:
Has anyone setup two instances of MySQL on the same server? One running
just a client's DBs? Any advice would be helpful.
It's just a matter of making sure that the two instances don't share any ports
or files. It works well. You'll have
Paul Schmehl wrote:
--On April 6, 2009 11:41:06 PM -0400 DAve dave.l...@pixelhammer.com
wrote:
Olivier Nicole wrote:
Hi,
Has anyone setup two instances of MySQL on the same server? One
running just a client's DBs? Any advice would be helpful.
That is not answering your question directly
I am venturing into Mysql. I am trying to install it from the port, 5.1.33.
Simple question:
Immediately after the start of make, you are presented with a list of options.
Are those options selected by entering them on the make line like:
make BUILD_OPTIMIZED=yes BUILD_STATIC=yes
Sorry
On Tue, 7 Apr 2009, Dave Stegner wrote:
I am venturing into Mysql. I am trying to install it from the port, 5.1.33.
Simple question:
Immediately after the start of make, you are presented with a list of
options.
Are those options selected by entering them on the make line like:
make
Good morning all,
I have a situation where I am being instructed to allow a client to
access MySQL remotely. We generally put those clients on a VPS and allow
them free reign. In this case we cannot, they are on a shared host
server. Opening our PIX to allow connections through to MySQL
Hi,
Has anyone setup two instances of MySQL on the same server? One running
just a client's DBs? Any advice would be helpful.
That is not answering your question directly, but MySQL works finr
over an SSH tunnel.
You'd have your users connect/authenticate with SSH first to establish
On April 6, 2009, DAve wrote:
Has anyone setup two instances of MySQL on the same server? One running
just a client's DBs? Any advice would be helpful.
It's just a matter of making sure that the two instances don't share any ports
or files. It works well. You'll have to create a custom
Olivier Nicole wrote:
Hi,
Has anyone setup two instances of MySQL on the same server? One running
just a client's DBs? Any advice would be helpful.
That is not answering your question directly, but MySQL works finr
over an SSH tunnel.
You'd have your users connect/authenticate with SSH
--On April 6, 2009 11:41:06 PM -0400 DAve dave.l...@pixelhammer.com
wrote:
Olivier Nicole wrote:
Hi,
Has anyone setup two instances of MySQL on the same server? One
running just a client's DBs? Any advice would be helpful.
That is not answering your question directly, but MySQL works
Any MySQL admins have a few cycles to spare privately?
Robert Huff
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail
I'm in the process of moving a phpBB3 forum to a new machine (formerly
5.2, now 7.1).
I also was so keen to move to php5 (was running php4 before, I believe).
I have the phpBB3 forum directory copied back into the DocumentRoot.
Mysql 4.1 is running, The database is there, I can log in to mysql
(mysql) or
something. Is there some module
or driver to be compiled in? I installed php5 now from ports with the
apache mod_php5 module
being installed.
If you installed phpBB3 from ports, php5-mysql should've been installed. Php5
has been split into modules. You may want to visit lang/php5
Christoph Kukulies wrote:
I'm in the process of moving a phpBB3 forum to a new machine (formerly
5.2, now 7.1).
I also was so keen to move to php5 (was running php4 before, I believe).
I have the phpBB3 forum directory copied back into the DocumentRoot.
Mysql 4.1 is running, The database
Yes. Linux threads is a port of the linux threading library
(devel/linuxthreads).
OK... this setup still seems to underperform 64 bit RHEL 5.x for at least
our setup. Unless I'm missing something. Our sites are higher traffic -
100-300 threads/connections at any given time. Perhaps that's
Hi all,
About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit). I
read at the time that the use of pthreads with FreeBSD would significantly
improve performance, but as I was running the 64 bit version of FreeBSD, I
could not use them.
Fast forward to today - a different
On Friday 20 March 2009 09:38:27 Matt Juszczak wrote:
I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 GB
RAM in the box) and attempt to build with pthreads enabled, as well as a
static build and optimized compiler options. Once again, got the
error/warning in ports that
Matt Juszczak wrote:
Hi all,
About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).
I read at the time that the use of pthreads with FreeBSD would
significantly improve performance, but as I was running the 64 bit
version of FreeBSD, I could not use them.
Fast forward
Matt Juszczak wrote:
Hi all,
About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).
I read at the time that the use of pthreads with FreeBSD would
significantly improve performance, but as I was running the 64 bit
version of FreeBSD, I could not use them.
Fast forward
You're confusing linux-threads with pthreads. The performance boosts mentioned
are done using the FreeBSD Posix threads (pthreads) library, in FreeBSD 7.x
they are implemented using libthr(3).
The benchmarks also assume you are using SCHED_ULE, rather then SCHED_4BSD.
Nothing should be configured
On Friday 20 March 2009 10:46:20 Matt Juszczak wrote:
You're confusing linux-threads with pthreads. The performance boosts
mentioned are done using the FreeBSD Posix threads (pthreads) library,
in FreeBSD 7.x they are implemented using libthr(3).
The benchmarks also assume you are using
I did a pkg_add -r mysql60-server
and then
# mysql_install_db --user=mysql
Installing MySQL system tables...
090320 17:11:24 [Note] Falcon: unable to open system data files.
090320 17:11:24 [Note] Falcon: creating new system data files.
^T ^T
load: 0.01 cmd: mysqld 1028 [uwait] 0.01u 0.01s 0
In the last episode (Mar 20), Christoph Kukulies said:
I did a pkg_add -r mysql60-server
and then
# mysql_install_db --user=mysql
Installing MySQL system tables...
090320 17:11:24 [Note] Falcon: unable to open system data files.
090320 17:11:24 [Note] Falcon: creating new system data files
Matthew Seaman wrote:
Actually, you may only need to recompile databases/php5-mysql
(possibly plus some dependencies) and then restart apache. If your DB
is on the same machine as where you're running phpMyAdmin, then you
will have the 5.0.77 client libraries already installed and
recompiling
Problem solved. What I did is:
- using Matthew's pkg_info -rx php5-mysql
- after that Aryeh's solution on the php5-mysql port
thanks for your help,
Jos
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd
Jos Chrispijn wrote:
| FreeBSD 6.4-STABLE
Just upgraded my MySQL server/client to v5.0.77 and php version to
php5-5.2.8 but something struck my eye when opening phpmyadmin, saying:
'Your PHP MySQL library version 4.0.27 differs from your MySQL server
version 5.0.77. This may cause
Aryeh M. Friedman wrote:
Jos Chrispijn wrote:
| FreeBSD 6.4-STABLE
Just upgraded my MySQL server/client to v5.0.77 and php version to
php5-5.2.8 but something struck my eye when opening phpmyadmin, saying:
'Your PHP MySQL library version 4.0.27 differs from your MySQL server
version 5.0.77
| FreeBSD 6.4-STABLE
Just upgraded my MySQL server/client to v5.0.77 and php version to
php5-5.2.8 but something struck my eye when opening phpmyadmin, saying:
'Your PHP MySQL library version 4.0.27 differs from your MySQL server
version 5.0.77. This may cause unpredictable behavior'.
I
Hello
I successfully updated the Ports collection to compile MySQL 5.1.22,
but even after updating /etc/rc.conf, the server doesn't start but
doesn't say why:
==
# pkg_version -v | grep -i mysql
mysql-client-5.1.22needs updating (port has
5.1.30)
mysql-server-5.1.22
Gilles wrote:
Hello
I successfully updated the Ports collection to compile MySQL 5.1.22,
but even after updating /etc/rc.conf, the server doesn't start but
doesn't say why:
==
# pkg_version -v | grep -i mysql
mysql-client-5.1.22needs updating (port has
5.1.30
On Sat, 28 Feb 2009 19:30:06 +0200, Manolis Kiagias
sonic200...@gmail.com wrote:
# cat /etc/rc.conf
#BAD? mysql-server=YES
mysql_server=YES
The /etc/rc.conf variable should be:
mysql_enable=YES
It will start then ;)
Makes sense :-/ Thanks for the prompt reply
On Mon, 16 Feb 2009 11:32:46 -0900, Mel
fbsd.questi...@rachie.is-a-geek.net wrote:
If you have none in /etc/make.conf that's a good start.
If it still fails, then make sure BUILD_OPTIMIZED is unset.
Also comment any CPUTYPE variables in /etc/make.conf.
Thanks again. I'm not really a developper,
On Tue, 17 Feb 2009 09:45:40 +0100, Gilles gilles.gana...@free.fr
wrote:
How should I tell gcc to compile for either a PIII processor, or just
plain i386?
BTW, here are the CFLAGS-related lines MySQL Server's Makefile:
.if defined(WITH_LINUXTHREADS)
CFLAGS+=-D__USE_UNIX98 -D_REENTRANT
On Tue, 17 Feb 2009 09:53:09 +0100, Gilles gilles.gana...@free.fr
wrote:
BTW, here are the CFLAGS-related lines MySQL Server's Makefile:
Using make BUILD_OPTIMIZED=no doesn't solve the issue :-/
In file included from item.h:2199,
from mysql_priv.h:589,
from
Gilles wrote:
On Tue, 17 Feb 2009 09:53:09 +0100, Gilles gilles.gana...@free.fr
wrote:
BTW, here are the CFLAGS-related lines MySQL Server's Makefile:
Using make BUILD_OPTIMIZED=no doesn't solve the issue :-/
In file included from item.h:2199,
from mysql_priv.h:589
On Tuesday 17 February 2009 01:09:34 Ivan Voras wrote:
Gilles wrote:
On Tue, 17 Feb 2009 09:53:09 +0100, Gilles gilles.gana...@free.fr
wrote:
BTW, here are the CFLAGS-related lines MySQL Server's Makefile:
Using make BUILD_OPTIMIZED=no doesn't solve the issue :-/
In file included
Hello
I updated the Ports collection on this 6.3 host, but it fails
compiling MySQL Server 5.1:
===
In file included from item.h:2428,
from mysql_priv.h:749,
from sql_profile.cc:32:
item_cmpfunc.h:1301: internal compiler error: Illegal instruction: 4
Please
Gilles wrote:
Hello
I updated the Ports collection on this 6.3 host, but it fails
compiling MySQL Server 5.1:
===
In file included from item.h:2428,
from mysql_priv.h:749,
from sql_profile.cc:32:
item_cmpfunc.h:1301: internal compiler error
On Mon, 16 Feb 2009 15:12:59 +0100, Ivan Voras ivo...@freebsd.org
wrote:
If you have any CFLAGS set (the most common are those for CPU
optimizations), disable them and try again.
Thanks for the tip. Do you know which value I should set for this
switch, if at all?
# dmesg | grep -i CPU
CPU: Intel
On Monday 16 February 2009 05:46:01 Gilles wrote:
On Mon, 16 Feb 2009 15:12:59 +0100, Ivan Voras ivo...@freebsd.org
wrote:
If you have any CFLAGS set (the most common are those for CPU
optimizations), disable them and try again.
Thanks for the tip. Do you know which value I should set for
I currently have running:
mysql-client-4.0.27 mysql-server-4.0.27, who I would like to upgrade
to mysql-client-5.0.75 mysql-server-5.0.75
I can imagine that there is a database issue here as the 4.0 records
might differ from the 5.0 ones.
Is there a way of upgrading smoothly? I did
On Fri, Jan 2, 2009 at 10:40 AM, Jos Chrispijn ker...@webrz.net wrote:
I currently have running:
mysql-client-4.0.27 mysql-server-4.0.27, who I would like to upgrade to
mysql-client-5.0.75 mysql-server-5.0.75
I can imagine that there is a database issue here as the 4.0 records might
[APseudoUtopia] Uit een eerder bericht van 2-1-2009 17:04 ::
I'd recommend that you read up on the MySQL documentation on the
subject of upgrading.
I don't mean to be mean, but it's not exactly a FreeBSD issue :-P
I ofcourse was referring to the ports part of the whole story, sorry
Dear All,
I am having trouble with using Zope 2.10 together with MySQL. I have
_mysql Python support library for Python 2.5 from some previous port but
Zope came with Python 2.4 and I do not have _mysql support for that. I
guess that there will not be a Zope 2.10 port with Python 2.5 support
Hello list,
I apologize if I somehow highjack the thread. I just want to tell the list
for further references
one way (my way) of doing mysql backup and to ask you if it's safe or not.
I have 2 server: one of which is the master (named for the sake of brevity
with M) in mysql terms
Hello,
Yes you're right but what I meant was something like this ;))
http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/
It's simple, safe and faster than mysqldump.
On 3 GB database it takes only 3-5 seconds.
Best regards,
Sebastian Tymkow
On 3-Nov-08, at 1:16 AM, Yuri Pankov wrote:
Apache and Courier IMAP are just not stopped during deinstall stage
(IIRC). You can use AFTERINSTALL in /usr/local/etc/pkgtools.conf to
start MySQL after upgrade.
Thanks! There's even an example using mysql-server in the file. My
AFTERINSTALL
On Sun, 2 Nov 2008 22:21:53 -0800
Jeremy Chadwick [EMAIL PROTECTED] wrote:
On Mon, Nov 03, 2008 at 12:52:53AM -0500, Andrew Berry wrote:
For some reason, after running portupgrade
databases/mysql51-server, MySQL is brought down, but not restarted.
It's not a huge issue, as I just have
Hi,
For some reason, after running portupgrade databases/mysql51-server,
MySQL is brought down, but not restarted. It's not a huge issue, as I
just have to remember to run the rc.d script after upgrading, but I
was wondering if anyone else had seen this? portupgrade seems to work
fine
On Mon, Nov 03, 2008 at 12:52:53AM -0500, Andrew Berry wrote:
For some reason, after running portupgrade databases/mysql51-server,
MySQL is brought down, but not restarted. It's not a huge issue, as I
just have to remember to run the rc.d script after upgrading, but I was
wondering
In the last episode (Nov 03), Andrew Berry said:
For some reason, after running portupgrade databases/mysql51-server,
MySQL is brought down, but not restarted. It's not a huge issue, as I
just have to remember to run the rc.d script after upgrading, but I
was wondering if anyone else had seen
On Mon, Nov 03, 2008 at 12:52:53AM -0500, Andrew Berry wrote:
Hi,
For some reason, after running portupgrade databases/mysql51-server,
MySQL is brought down, but not restarted. It's not a huge issue, as I
just have to remember to run the rc.d script after upgrading, but I was
wondering
Now I just need to figure out how to start it on reboot, but that
is something I've been meaning to learn, anyway, so I don't mind.
I hope you guys will bear with me just a little more... I have
spent the day trying to figure out how to create an rc script for
autossh. Very cool, and not
John Almberg wrote:
Now I just need to figure out how to start it on reboot, but that is
something I've been meaning to learn, anyway, so I don't mind.
I hope you guys will bear with me just a little more... I have spent
the day trying to figure out how to create an rc script for autossh.
Answering my own question (probably the best way)...
I solved this problem by figuring out how to execute the command
inside the rc script as a non-root user. Like so:
autossh_start()
{
echo ${command} ${command_args}
su admin -c ${command} ${command_args}
echo started autossh
}
This
John Almberg wrote:
I do know that Mysql supports SSL... somehow this got discounted early
in the discussion, perhaps mistakenly?
I believe the thinking was that although MySQL claims to support SSL,
it does in fact make a pretty bodge of it, and a more effective approach
is to pipe MySQL
On Oct 20, 2008, at 11:09 PM, Peter Boosten wrote:
John Almberg wrote:
I tried this, and not surprisingly, it didn't work. Now I'm trying to
debug it...
Maybe some mixup in the keys? In my example ssh tries to read the
private key of root on the connecting server, so the server where the
On Oct 21, 2008, at 3:44 AM, Matthew Seaman wrote:
John Almberg wrote:
I do know that Mysql supports SSL... somehow this got discounted
early in the discussion, perhaps mistakenly?
I believe the thinking was that although MySQL claims to support SSL,
it does in fact make a pretty bodge
Now I just need to figure out how to start it on reboot, but that
is something I've been meaning to learn, anyway, so I don't mind.
I hope you guys will bear with me just a little more... I have spent
the day trying to figure out how to create an rc script for autossh.
Very cool, and not
John Almberg said the following on 2008-09-23 15:54:
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
On Sep 23, 2008, at 10:09 AM, Vincent Hoffman wrote:
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
John Almberg wrote:
On Sep 23, 2008, at 10:09 AM, Vincent Hoffman wrote:
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
After a few hours of work today, I have all this working
perfectly. I'm
using autossh to automatically create and monitor the ssh tunnel,
and I
can make mysql connections through the tunnel with no problems.
Very cool.
And that's through PF firewalls on both machines, which added
On Oct 20, 2008, at 4:50 PM, John Almberg wrote:
After a few hours of work today, I have all this working
perfectly. I'm
using autossh to automatically create and monitor the ssh tunnel,
and I
can make mysql connections through the tunnel with no problems.
Very cool.
And that's
On Mon, Oct 20, 2008 at 03:25:23PM -0400, John Almberg wrote:
On Sep 23, 2008, at 10:09 AM, Vincent Hoffman wrote:
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
On Oct 20, 2008, at 5:21 PM, Jeremy Chadwick wrote:
On Mon, Oct 20, 2008 at 03:25:23PM -0400, John Almberg wrote:
On Sep 23, 2008, at 10:09 AM, Vincent Hoffman wrote:
John Almberg wrote:
I have two FreeBSD machines. One is a application server, the
other a
database server running mysql
normally isn't) you need to
verify the host key of the remote server (by either putting it in
known_hosts of root by hand, or make the connection once from the prompt
and answer 'y', or putting the key in /etc/ssh/ssh_known_hosts.
The connection on the remote host indeed is made with
mysql -h 127.0.0.1
Peter Boosten wrote:
John Almberg wrote:
I tried this, and not surprisingly, it didn't work. Now I'm trying to
debug it...
Maybe some mixup in the keys? In my example ssh tries to read the
private key of root on the connecting server, so the server where the
database is located, because
John Almberg wrote:
Where 'admin' is the user I am logging into on the remote machine, and
'example.com' is the hostname of the remote machine. I guess equivalent
to the following?
ttyv7 /usr/bin/ssh -nNTx -R 3306:127.0.0.1:33006 [EMAIL PROTECTED]
/dev/null 21unknown on
Port
containing:
[client]
user = root
password = imnottellingyou
Make sure that's mode 400. You should then be able to type 'mysql' as the unix
root user and be auto-logged into a root level mysql session without having to
type in the password explicitly. Other client applications (mysqldump
Hello,
Zbigniew Szalbot wrote:
| It works so no problem but I do not really like the idea of providing
| passwords in crontab. I wish the option in my.cnf file worked as
| advertised.
Hmmm It's always worked for me to create a file /root/.my.cnf
containing:
[client]
user = root
On Wed, Oct 08, 2008 at 07:48:47AM +0200, Zbigniew Szalbot wrote:
Hi there,
I hope someone can help. Due to they way my HD has been sliced I had
to move mysql database to /usr/local/mysql. All works fine. Last week
I added this entry
#expire bin logs
expire_logs_days = 7
to /usr/local
(MySQLFront running on Windows XP, connecting to
MySQL5.2.5 on FreeBSD7.0REL)
Sorry, brain fade... it's early! MySQL 4.1.22... was thinking about PHP
at the time...
Cheers!
Marc A Coyles - Horbury School ICT Support Team
Mbl: 07850 518106
Land: 01924 282740 ext 730
Helpdesk: 01924 282740 ext
Zbigniew Szalbot wrote:
Hi there,
I hope someone can help. Due to they way my HD has been sliced I had
to move mysql database to /usr/local/mysql. All works fine. Last week
I added this entry
#expire bin logs
expire_logs_days = 7
to /usr/local/mysql/my.cnf
I restarted the MySQL server
Hello,
-r--r--r-- 1 mysql mysql4954 Oct 1 07:30 my.cnf
drwx-- 2 mysql mysql1536 Sep 27 07:10 mysql
-rw-rw 1 mysql mysql 1073745213 Sep 2 04:07 mysql-bin.47
-rw-rw 1 mysql mysql 1073746878 Sep 7 03:48 mysql-bin.48
-rw-rw 1 mysql mysql
fails to restore
with Check syntax near... error, but at a COMPLETELY different point
thru the restore.
If I head into cPanel, to phpmyadmin, and do an export from there... the
file restores PERFECTLY without errors.
Sooo... how can I write a script that'll backup a MySQL database and
produce
that'll backup a MySQL database and
| produce a useable file??
|
| This problem is occurring on 2 of my 8 databases... it appears the
| chosen software used to produce the dump of MySQL data is the culprit...
| what is the best commandline (ie: cron-able) tool to use for the task?
Without seeing
Hi there,
I hope someone can help. Due to they way my HD has been sliced I had
to move mysql database to /usr/local/mysql. All works fine. Last week
I added this entry
#expire bin logs
expire_logs_days = 7
to /usr/local/mysql/my.cnf
I restarted the MySQL server and now I have been waiting
On Thursday 02 October 2008 01:59:18 Da Rock wrote:
On Wed, 2008-10-01 at 12:53 +0200, Erik Trulsson wrote:
On Wed, Oct 01, 2008 at 08:39:47PM +1000, Da Rock wrote:
So are you saying I can't start a script manually without enabling it
in rc.conf? I was not under that impression... I
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Sebastian Tymków wrote:
| Hello,
|
| You can store whole db files too. It's faster to run database from scratch
| than use mysqldump and mysql source.
Um... no. In general you cannot do this, and it is exceedingly irresponsible to
suggest
On Thu, 2008-10-02 at 09:18 +0200, Jonathan McKeown wrote:
On Thursday 02 October 2008 01:59:18 Da Rock wrote:
On Wed, 2008-10-01 at 12:53 +0200, Erik Trulsson wrote:
On Wed, Oct 01, 2008 at 08:39:47PM +1000, Da Rock wrote:
So are you saying I can't start a script manually without
On Wed, 2008-10-01 at 15:40 +1000, Da Rock wrote:
Has anyone else had trouble with starting mysql server with the rc
script?
I've only just installed from ports (as a dependency, mind) and
technically it should just start when you run the rc script - it sets up
the db dirs and stuff so
Da Rock [EMAIL PROTECTED] writes:
On Wed, 2008-10-01 at 15:40 +1000, Da Rock wrote:
Has anyone else had trouble with starting mysql server with the rc
script?
I've only just installed from ports (as a dependency, mind) and
technically it should just start when you run the rc script
of the websites on my server uses a
large Mysql database. Somehow, one of the tables got corrupted today.
I have been blithely backing up mysql with a simple cron script that ran
mysqldump every night. Simple, reliable, and I've never needed it.
Today, when I realized the database was corrupted, I
On Wed, 2008-10-01 at 12:57 +0400, Boris Samorodov wrote:
Da Rock [EMAIL PROTECTED] writes:
On Wed, 2008-10-01 at 15:40 +1000, Da Rock wrote:
Has anyone else had trouble with starting mysql server with the rc
script?
I've only just installed from ports (as a dependency, mind
On Wed, Oct 01, 2008 at 08:39:47PM +1000, Da Rock wrote:
On Wed, 2008-10-01 at 12:57 +0400, Boris Samorodov wrote:
Da Rock [EMAIL PROTECTED] writes:
On Wed, 2008-10-01 at 15:40 +1000, Da Rock wrote:
Has anyone else had trouble with starting mysql server with the rc
script
On Wed, Oct 1, 2008 at 12:39 PM, Da Rock [EMAIL PROTECTED]wrote:
On Wed, 2008-10-01 at 12:57 +0400, Boris Samorodov wrote:
Da Rock [EMAIL PROTECTED] writes:
On Wed, 2008-10-01 at 15:40 +1000, Da Rock wrote:
Has anyone else had trouble with starting mysql server with the rc
script
} -h#{db_host} --all-databases #{backup_file}
puts backup_command if debug
`#{backup_command}`
puts backup status: #{$?.exitstatus} if debug
unless $?.exitstatus == 0
`echo Mysql backup failed with status: #{$?.exitstatus} | mail -
s Mysql_backup Error #{notify_email}`
exit
end
# zip
Hello,
You can store whole db files too. It's faster to run database from scratch
than use mysqldump and mysql source.
Best regards,
Shamrock
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
trouble with starting mysql server with the rc
script?
I've only just installed from ports (as a dependency, mind) and
technically it should just start when you run the rc script - it sets
up
the db dirs and stuff so it can just run. But I can't get it to do the
setup
First, I wanted to say how great this list is. I'm a newbie FreeBSD
admin and, besides the Handbook and Absolute FreeBSD (which never
seems to leave my desk), this list is the best resource I have.
I just had a huge scare today... One of the websites on my server
uses a large Mysql
of the websites on my server uses a
large Mysql database. Somehow, one of the tables got corrupted today.
I have been blithely backing up mysql with a simple cron script that ran
mysqldump every night. Simple, reliable, and I've never needed it.
Today, when I realized the database was corrupted, I
of the websites on my server
uses a large Mysql database. Somehow, one of the tables got corrupted
today.
I have been blithely backing up mysql with a simple cron script that
ran mysqldump every night. Simple, reliable, and I've never needed it.
Today, when I realized the database was corrupted, I
On Tue, Sep 30, 2008 at 06:18:35PM -0400, John Almberg wrote:
I just had a huge scare today... One of the websites on my server uses a
large Mysql database. Somehow, one of the tables got corrupted today.
Do you know if the table corruption was a result of 1) a MySQL bug (and
there are many
a numeric date unique back, that would give
you numerous backups if you have the storage.
DATE=`date +%a`
#
echo $DATE
#
echo Backup Mysql database
mysqldump -h localhost -u YOURSQLUSERID -pYOURPASSWORD YOURDATABASE /
usr/somedirectory/somefile_$DATE.backup
gzip -f /usr/somedirectory/somefile_
On Tue, Sep 30, 2008 at 06:18:35PM -0400, John Almberg wrote:
I just had a huge scare today... One of the websites on my server
uses a
large Mysql database. Somehow, one of the tables got corrupted today.
Do you know if the table corruption was a result of 1) a MySQL bug
DATE=`date +%a`
#
echo $DATE
#
echo Backup Mysql database
mysqldump -h localhost -u YOURSQLUSERID -pYOURPASSWORD YOURDATABASE
/usr/somedirectory/somefile_$DATE.backup
gzip -f /usr/somedirectory/somefile_$DATE.backup
/usr/bin/at -f /usr/somedirectory/mysqlbackup.sh midnight
Ah, a much
. '.' . '0';
my $command = $mysqldump --opt --all-databases | $gzip $curfile;
my $result;
$result = system $command and warn $result;
On Sep 30, 2008, at 4:22 PM, John Almberg wrote:
DATE=`date +%a`
#
echo $DATE
#
echo Backup Mysql database
mysqldump -h localhost -u YOURSQLUSERID -pYOURPASSWORD
a huge scare today... One of the websites on my server uses a
large Mysql database. Somehow, one of the tables got corrupted today.
I have been blithely backing up mysql with a simple cron script that ran
mysqldump every night. Simple, reliable, and I've never needed it.
Today, when I realized
Has anyone else had trouble with starting mysql server with the rc
script?
I've only just installed from ports (as a dependency, mind) and
technically it should just start when you run the rc script - it sets up
the db dirs and stuff so it can just run. But I can't get it to do the
setup stuff
201 - 300 of 1650 matches
Mail list logo