I have replication setup in the following way:
A - B -C
I am making updates to server A. I want to stop all my updates and point
them to server C. After I start writing to server C, can I use the change
master statement to make the C the master of A (take B out of the topology)
and proceed to
We are in the process of switching to percona binaries of MySQL . I am
using Percona 5.5.27 and monitoring the MySQL server with the MySQL
Enterprise monitor. It starts up fine, but after a while I end up with
MySQL monitor connections stacking up until the server becomes pretty much
useless. This
James rja...@yahoo-inc.com wrote:
What does SHOW FULL PROCESSLIST say?
What values do you have for
max_connections
wait_timeout (GLOBAL version)
-Original Message-
From: Sabika M [mailto:sabika.makhd...@gmail.com]
Sent: Thursday, October 25, 2012 11:44 AM
To: mysql
hi!
I am trying to work with percona's extra backup. Has anyone found any
simple instructions how to install it? We are using innodb file per table
Thanks!
Sabika
hi!
I am hoping someone has experienced this before or knows how we can resolve
this. I am running into an innodb assertion error (see below) and cannot
reproduce it. It has happened 3-4 times, MySQL crashes and sometimes
recovers and other times it is unable to recover (MySQL repeatedly
hi all,
our DB crashed for some reason... any inputs would be greatly appreciated..
120711 8:12:21 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured.
sorry.. im using 5.1
On Wed, Jul 11, 2012 at 10:09 AM, J M jerom...@gmail.com wrote:
hi all,
our DB crashed for some reason... any inputs would be greatly appreciated..
120711 8:12:21 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
hi all,
i have an issue with our db which hangs and the only way to
recover from it is to restart mysql if you had console access or
restart the box itself ( only if i can't wait )
show processlist result can be found here: http://pastebin.com/BYvZ5ZFR
listed below are info about
Thank Baron,
i want to see if there is something i can do from the DB end.
and BTW, i've been using the plugin already.
On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz ba...@xaprb.com wrote:
In this case the solution is much easier outside of MySQL than inside.
hi...
so i have this user in the user table in the mysql db that has all the
privileges but grant. now i need for that user to have the file
privilege so it can do into outfile. thing is i don't see that
privilege anywhere in the db table. i know that i have to do the grant
file on
.
Carlos
On Mon, Jan 30, 2012 at 10:56 PM, kalin m ka...@el.net
mailto:ka...@el.net wrote:
hi...
so i have this user in the user table in the mysql db that has all the
privileges but grant. now i need for that user to have the file
privilege so it can do into outfile
thanks. it took about 15 hrs. but right now everything seems ok. does
the check last as long as the repair?
On 1/24/12 3:51 AM, Johan De Meersman wrote:
- Original Message -
From: kalin m ka...@el.net
ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD
file is about
hey. this list used to be pretty active. did anything change? is there
another place to ask questions like these?
thanks...
On 1/23/12 5:02 PM, kalin m wrote:
hi all..
i started a repair on a table that has an MYD file of 9.2 gigs. the MYI
file is 7.7 gigs. the TMD file, which i'm
:
This is still the list although more quiet than it used to be.
Repairing a table is already a fragile process.. I would not try to
interrupt it if the data has no backup.
- michael dykman
On Mon, Jan 23, 2012 at 11:04 PM, kalin m ka...@el.net wrote:
hey. this list used to be pretty active
I also want to say Thank you Shawn for your valuable contribution. On the
note on Resumes -I thought I would put it out here. My company is looking
for an excellent MySQL DBA (Oracle and MSSQL experience a plus) Please send
me your resume.
Thanks!
Sabika
On Wed, Oct 19, 2011 at 12:30 PM, Shawn
my.cnf settings becuase stats are useless without
knowing the configuration and without knowing your hardware (memory!)
nobody can say what buffers are making sense
i would use mysqltuner.pl because it shows in the most cases good
advises
Am 05.05.2011 20:42, schrieb J M:
Hi,
I have
Hi,
I have this stats: I have tuned some of it but I was wondering if someone
can give inputs regarding it:
*
__ Key _
Buffer used54.63M of 384.00M %Used: 14.23
Current 123.21M%Usage: 32.09
Write hit
Aveek, Simcha, Johan,
Thanks for explaining the situation. I knew there were some reserved
words, but I hadn't realized there were so many.
Anyway, now that I know I can protect my column names with backticks,
I'm good to go.
--
Dave M G
--
MySQL General Mailing List
For list archives: http
for column names? Seems a little
silly. Is there a way to protect column names to that there is no confusion?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
in MyISAM type.
What's going on?
Regards,
Rodrigo.
--
M. Rodrigo Monteiro
Free as in Freedom, not free as in free beer
As we are liberated from our own fear, our presence automatically
liberates others
Linux User # 403730
Pense antes de imprimir. Think before printing.
AVISO LEGAL
Esta
Hi!
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;
I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.
Regards,
Rodrigo.
--
M. Rodrigo Monteiro
Free as in Freedom
/ cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
--
M. Rodrigo Monteiro
Free as in Freedom, not free as in free beer
As we are liberated from our own fear, our presence automatically
liberates others
Linux User # 403730
Pense antes
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was
disabled by default so you must be almost a PhD to enable it.
But the version of MySQL is 5.1 as you can see below...
What about updating server?
# cat
.
-- Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Apparmour and MySQL
solved the problem.
Thank you for setting me in the right direction.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Simcha Younger wrote:
On Mon, 04 Oct 2010 16:11:08 -0400
kalin m ka...@el.net wrote:
what i'm trying to do is update the column only of one of those times
isn't yet passed. and it works. except sometimes...
like these 2 unix times:
this was in the table under unix time
hi all...
i'm doing tests with a table that gets updated based on random unix
times it contains. there is a column that has a bunch or random times
that look like:
+-+---+
| date_time | unix_time|
have in your table. Try posting the SHOW CREATE TABLE table \G output, and a
sample INSERT statement to populate the table. That way someone can try to
reproduce the behavior you're seeing.
-Original Message-
From: kalin m [mailto:ka...@el.net]
Sent: Monday, October 04, 2010 1:11 PM
On 7/20/2010 10:07 AM, Chris W wrote:
I try to avoid asking why but in this case I have to. I can't imagine
wanting to have a list of numbers displayed and not have them all
aligned right with the sane number of digits after the decimal
point. So why would you even want to do this is?
mysql select 1+1.0;
+---+
| 1+1.0 |
+---+
| 2.0 |
+---+
1 row in set (0.00 sec)
mysql select 1+1.1;
+---+
| 1+1.1 |
+---+
| 2.1 |
+---+
1 row in set (0.00 sec)
Is there a way to tell MySql to only return '2' in the first select as
opposed to
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was created in the first place, I can only
work with
On 7/19/2010 10:48 AM, Michael Dykman wrote:
Not quite sure what the question is.
from:
mysql select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
On 7/19/2010 11:08 AM, Shawn Green (MySQL) wrote:
Just because someone hands you a set of data to *start* with, does not
mean that you must only use that data to *work* with.
You should be able create additional tables derived from the original
data and work with those as part of your
Huh? That doesn't make a whole lot of sense. If that is the case, can you
explain why? Is the stored procedure mechanism that primitive?
From: Ted Yu [mailto:yuzhih...@gmail.com]
Sent: Saturday, May 01, 2010 7:11 AM
To: Ashley M. Kirchner
Subject: Re: [MySQL] Re: Variables in stored
I have the following procedure:
--
CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int)
begin
declare userlng double;
declare userlat double;
declare lng1 float;
declare lng2 float;
declare lat1 float;
declare lat2 float;
select lng, lat into userlng,
-Original Message-
From: Shawn Green [mailto:shawn.l.gr...@oracle.com]
Sent: Friday, April 30, 2010 9:49 PM
To: Ashley M. Kirchner
Cc: mysql@lists.mysql.com
Subject: [MySQL] Re: Variables in stored procedures
Two options
1) use the placeholder, a question mark
|
--
when i do this:
select distinct prod as m, (select category from products where email
= m) as n from products;
i get:
ERROR 1242 (21000): Subquery returns more than 1 row
i know that the subquery returns more than one rows. i hope so...
what i'd like to see as result
-0700, kalin m wrote:
hi all...
i have a bit of a problem with this:
table products:
--
prod | category |
-|
boots | winter|
boots | summer |
boots | spring |
shoes | spring |
shoes | winter|
shoes | fall |
shoes | summer
.
There are many ways to skin this cat ...
--
H | It's not a bug - it's an undocumented feature.
+
Ashley M. Kirchner mailto:ash...@pcraft.com . 303.442.6410 x130
IT Director / SysAdmin. 800.441.3873 x130
I'm stuck again ... and perhaps it's just not designed right, but I
inherited this setup, so if anyone has suggestions on how to make it better,
I'm all ears. This is all one table ...
describe approvals;
+---+--+--+-+-++
| Field
Hi folks,
I'm trying to, possibly do the impossible here. I have to select data from
4 different tables to come up with the right information and I'm having one
heck of time trying to figure it out. This is going to be a long email ...
Table_1:
.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello all,
due to connection state, I need to keep an updated copy of the database on the
client.
How can I accomplish this?
TIA
Mos
/
*
*
*
Selebihnya anda fikir2kan dan nilai sendiri..
Saya sudah mengambil tempat saya.
Saya yakin saya bertindak betul.
salam
Wassalam.
Aslani M
--
Email Signature
Hi,
I'm a little rusty in my SQL statements, and I'm not all that certain
that this can be done.
IF I have a field with the contents like:
http://beta.somedomain.com/url/url/url=2;
where 2 is the record ID value. And I need to change the contents of
that field to read:
. I would have assumed it would need to be one way, but
it actually requires a different approach, which I don't quite understand.
Here are the table creation scripts:
CREATE TABLE student
(
name VARCHAR(20) NOT NULL,
sexENUM('F','M') NOT NULL,
student_id INT UNSIGNED
I think normally NULL values will sort at the end, correct? I believe
there's a way to make NULL values sort at the beginning, but I can't
remember how to do it. I just searched a couple of MySQL resources, but
I couldn't find it.
--
MySQL General Mailing List
For list archives:
Ubuntu 8.10.
I was experimenting with the Spring Petclinic sample application,
configured with MySQL. I found that some of the tests were failing,
apparently because of table name case-sensitivity issues. I was able to
fix some of the code references, but after that I hit other, probably
Duncan, Kurt (MCUSA) wrote:
1. Any issues running MySQL Ver. X on Windows 2008 Server?
2. Running a query to list all records of about 2600 records is
very slow and gets an error of Extremely High Work Load, Each record
does contain 1 LONGBLOB containing small voice recording. We are
John G. Heim wrote:
- Original Message - From: Darryle Steplight
dstepli...@gmail.com
To: Stephen Edberg sbedb...@ucdavis.edu
Cc: John G. Heim jh...@math.wisc.edu; mysql@lists.mysql.com
Sent: Thursday, March 05, 2009 12:53 PM
Subject: Re: best mysql optimization tutorial and/or quick
Baron Schwartz wrote:
Hi!
On Wed, Mar 11, 2009 at 8:20 PM, David M. Karr
davidmichaelk...@gmail.com wrote:
Using 5.0.67-0ubuntu6 on Ubuntu 8.10.
I'm going through the High Performance MySQL book. I was reading section
4.4.1.8, titled MIN() and MAX(). The point of this is that MySQL
Using 5.0.67-0ubuntu6 on Ubuntu 8.10.
I'm going through the High Performance MySQL book. I was reading
section 4.4.1.8, titled MIN() and MAX(). The point of this is that
MySQL doesn't optimize MIN()/MAX() very well, but it showed a supposed
workaround for this.
The first sample query was:
Anyone?
I'm trying to diagnose this and not having much luck. I can't even
figure out where to even begin to look. I have two MySQL servers and
getting different results for the same query on both:
SERVER 1:
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
Michael Dykman wrote:
It
worked fine as you wrote it on my v5.0.45, although it reported 2 rows
affected on each subsequent run of the insert statement. I thought
this odd as I only ran the same statement repeatedly leaving me with
one row ever, but the value updated just fine.
I noticed
I'm trying to diagnose this and not having much luck. I can't even
figure out where to even begin to look. I have two MySQL servers and
getting different results for the same query on both:
SERVER 1:
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
SERVER 2:
hi all...
i had a weired thing happened
is it possible for a user privileges to expire?!
suddenly today an application stopped working and i was getting the
message that the user can't login.
now, i did mess with it last night trying to give it file privileges but
since i would have
hi all...
i have a strange problem with a simple script that is doing select into
outfile...
the thing just does that. it does a select into an outfile. if i print
the query that's passed to mysql_result in the script and then copy it
and paste it z`into the mysql client it works fine but
right null did it... thanks...
Leonardus Setyabudi wrote:
try something like : count(if(a.type = 'SBR', 1, null))
count will ignore null value .. and only count the one with 'SBR' value
br,
Leo
On 24/09/08 12:09, kalin m wrote:
no, not really... sum is part of the query:
count
hi all...
can somebody explain why a conditional count like this one doesn't work:
count(if(a.Type = Signature Based Return, a.amount,'')) group
by order by
or
if(a.Type = Signature Based Return, count(a.amount),'') group
by order by...
thanks...
--
MySQL
wrote:
On Tue, Sep 23, 2008 at 9:29 PM, kalin m [EMAIL PROTECTED] wrote:
count(if(a.Type = Signature Based Return, a.amount,'')) group by
order by
I think you're looking for sum().
- Perrin
went into
/etc/mysql and edited both my.cnf and debian.cnf so that the socket =
/tmp/mysql.sock
Then I reinstalled MySQL server:
$ sudo apt-get install mysql-server mysql-server-5.0
Seems to be running now.
Thanks everyone for helping me get things sorted out.
--
Dave M G
--
MySQL General
supposed to do? It won't let me start it, stop it,
remove it, or anything.
Any advice would be much appreciated.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the situation.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- I ran a PHP script with phpinfo() and it
says my MYSQL_SOCKET is located at:
/var/run/mysqld/mysqld.sock
Which is where it should be, no?
Any ideas why it is doing this, and how to get MySQL happy again?
Any advice would be much appreciated.
--
Dave M G
--
MySQL General Mailing List
Wel Don't want to spoil the party, but it would be helpfull if you post
some code. My crystalball is in the repairshop at the moment, zo it is pretty
hard to guess what the problem is...
Met vriendelijke groet,
Open Systems Development
Peter M. Groen
Klipperwerf 12
2317 DZ Leiden
Telef
hi...
how do i do conditional sums? like:
select a.job, sum(if b.amount 0 then amount end if ) from t1 as a left
join t2 as b on a.account=b.accoun where a.account = b.account group by
a.job;
or
select a.job, if b.amount 0 then sum(b.amount) end if from t1 as a
left join t2 as b on
...
any ideas?!.
thanks.
kalin m wrote:
hi...
how do i do conditional sums? like:
select a.job, sum(if b.amount 0 then amount end if ) from t1 as a
left join t2 as b on a.account=b.accoun where a.account = b.account
group by a.job;
or
select a.job, if b.amount 0 then sum
Hello
I ram yum update for mysql , mysql-server and mysql-devel in fedora core 2,
after this mysql is not starting.
===
Log Error message:
080715 22:55:58 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB
I found this in innodb log file..
Version: '4.1.9-standard' socket: '/var/lib/mysql/mysql.sock' port:
3306 Official MySQL RPM
080712 04:37:21 mysqld started
080712 4:37:29 [Warning] Asked for 196608 thread stack, but got 126976
080712 4:37:36 InnoDB: Started; log sequence number 0
hi all... i just build from source 5.0.51b on a freebsd 7...
works fine.
but the cli displays \40 for white space on remembered commands. like in
flush\040privileges;. pretty annoying specially for long ones.
how to fix?
thanks
--
MySQL General Mailing List
For list archives:
i use the cli exclusively... how can i fix this?!
kalin m wrote:
hi all... i just build from source 5.0.51b on a freebsd 7...
works fine.
but the cli displays \40 for white space on remembered commands. like
in flush\040privileges;. pretty annoying specially for long ones.
how to fix
the \40 is all over the .mysql_history?!?
kalin m wrote:
i use the cli exclusively... how can i fix this?!
kalin m wrote:
hi all... i just build from source 5.0.51b on a freebsd 7...
works fine.
but the cli displays \40 for white space on remembered commands. like
in flush\040privileges
assuming this is for books/pages to be displayed on line...
how about if you just keep just important stuff in mysql
like chapter titles and how many pages the book has, author, edition,
etc
then you keep files for each page (or book) in the filesystem - xml,
txt, etc - and you just make a
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
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2008 6:23 AM
To: mysql@lists.mysql.com
Subject: RE: what is the proper way to store timezone information?
Boyd, Todd M. wrote:
When recording this information, do I store the full name
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 1:40 PM
To: Martijn Tonies; MySQL List
Subject: Re: Function Still Not Working
Any difference in default collation?
Not sure what that is. I'm using a visual tool (EMS) to create my
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 8:25 PM
To: mysql@lists.mysql.com
Subject: natural sort via substrings
Hi, I am attempting to do a natural sort from within mysql, if
possible.
So, for example, jane2 would come before
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 5:17 AM
To: mysql@lists.mysql.com
Subject: what is the proper way to store timezone information?
All,
I will be recording timezone information based on user input using the
time zone names
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:33 AM
To: Emily Heureux; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
---8--- snip
Forgive me if I am incorrect, but wouldn't jane2 already be listed
before jane10
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:48 AM
To: [EMAIL PROTECTED]
Cc: mos; mysql@lists.mysql.com
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Hi
Is sphinxsearch avialable only on for windows
-Original Message-
From: Elim Qiu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:56 AM
To: mysql@lists.mysql.com
Subject: query counts of a database
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:12 AM
To: Boyd, Todd M.; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
Hi, I am sorry for being so vague. The values are not as simple as
jane20,
jane10, or jane2
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 6:23 AM
To: MySQL List
Subject: Re: Function Still Not Working
Hey,
Sorry for posting this again, but I got only one response last time,
and
I'm
still having the problem. I
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 9:41 AM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: Re: enable and disable keys
We have 200GB of free space on the file system where our database is
located.
---8--- snip
If the system
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. [EMAIL PROTECTED] wrote:
-Original Message-
From: Ananda Kumar [mailto:[EMAIL
hi all...
just wondering what is the performance difference between:
PRIMARY KEY [/|index_type|/] (/|index_col_name|/1,/|index_col_name|/2)
at the time of the table creation
or
create index index_name1 on table_name (/|index_col_name|/1);
create index index_name2 on table_name
[take 2]
--
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C
Work
defined like that.
I'm trying to avoid doing something that I have to update everytime a table is
added/deleted.
- --
-
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http
)
- --
-
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C
Work like you don't need the money,
love like you'll never get hurt
Decided to run up2date -u
I noticed that our website was tossing off mysql errors. Quickly
realized that mysql was down. Went to restart but it couldn't find
mysqld_safe, mysqld, mysqladmin, etc.
I used locate and it couldn't find the binaries anywhere...it appears
that up2date -u had
Glyn Astill wrote:
I'd back up the data directories then try and then re-install mysql (sorry, I
know little about red hat and it's package management). It shouldn't overwrite
your data if it's already present anyway.
Great. Thought that would be the case, but without sleep, I wasn't sure.
.
+
Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130
IT Director / SysAdmin / Websmith . 800.441.3873 x130
Photo Craft Imaging . 3550 Arapahoe Ave. #6
http://www.pcraft.com . . .. Boulder, CO 80303
hi all...
i have a 5.0.33 build from source on a freebsd 4.10 machine...
i'm looking for a my.cnf file.
ps tells me that the base dir is /usr/local but there is no my.cnf
there. and i cant find one anywhere.
i can get all the variables set up from the cli but i need to change
some of them.
phpMyAdmin, it might be simpler not to use it, and use mysqldump instead.
I suppose I'll have to if I can't get phpMyAdmin to behave. It's too
bad, though, as phpMyAdmin is so convenient otherwise.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
backing up and restoring?
Thanks for any advice.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Folks,
Thanks for the 'help'. Oy.
I figured it out from some help on the Lasso discussion list.
All I had to do was properly address ALL the tables I wanted to touch.
So this:
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id =
Hi,
I'm wondering if the following can be done
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND
tbe_images.img_orig_filename = tbe_gsa.gsa_id
Let me explain:
I have 3 tables and only 1 of them
1 - 100 of 757 matches
Mail list logo
