Rick James 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, 20
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
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 s
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 crashe
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
sorry.. im using 5.1
On Wed, Jul 11, 2012 at 10:09 AM, J M 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 bina
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. Th
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 wrote:
> In this case the solution is much easier outside of MySQL than inside.
> http://ocaoimh.ie/wp-super-cache/ i
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
s, "db" is
> specific to each database.
>
> Carlos
>
>
> On Mon, Jan 30, 2012 at 10:56 PM, kalin m <mailto:ka...@el.net>> wrote:
>
>
>
> hi...
>
> so i have this user in the user table in the mysql db that has all the
> pr
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 user@l
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"
>>
>> ok. thanks. i thought so. it's been about 8 hrs
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 wrote:
>>
>>
&
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. t
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 Gr
ase 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
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 arch
the word "group" 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
2011/1/31 João Cândido de Souza Neto :
> 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?
>
>
eractive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / software-development / 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"
"
Hi!
2011/1/31 João Cândido de Souza Neto :
> 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,
e table creates 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.
rting both 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
try?
Thank you for any advice.
-- 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 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: 1286216
rent about the values you
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: Mo
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|
+-+--
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?
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 analysis
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 |
+
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 wh
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
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 s
> -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) u
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, userla
08:37:04AM -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 |
shoe
|
--
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 r
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
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:
+---+--+--+---
any advice.
--
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
vemma-my.com/aslani<http://www.vemmabuilder.com/>
*
*
*
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:
"http://www.so
set of tables and a
specific query. 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'
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: http://lists
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
fo
John G. Heim wrote:
- Original Message - From: "Darryle Steplight"
To: "Stephen Edberg"
Cc: "John G. Heim" ;
Sent: Thursday, March 05, 2009 12:53 PM
Subject: Re: best mysql optimization tutorial and/or quick start guide?
High Performance MySql "Optimization, Backups, Replication,
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
Baron Schwartz wrote:
Hi!
On Wed, Mar 11, 2009 at 8:20 PM, David M. Karr
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 d
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 w
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
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
S
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 to
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 i
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
i do that?!
thanks
Perrin Harkins 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
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
es. I 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 Ge
ything else I can do to get a clean install of MySQL running
again?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nfuse 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]
b
E: Sub-process /usr/bin/dpkg returned an error code (1)
So now what am I 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]
/mysql.sock' (2)
Oh, this might be relevant - 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 appreciate
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
ut that's not it. and the 1464 is
the correct number for b.money...
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
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 o
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 93442
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 tables,
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 p
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\040privi
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
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: http
there any 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/lo
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:
> -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
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: 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
&
> -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 tab
> -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 win
> -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 "ja
> -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 z
> -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 co
> -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
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 [m
> -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 t
> -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 pro
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 (/|index_co
[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
le_id)
- --
-
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
IED BY 'X'
obviously this doesn't work as there is no grant defined like that.
I'm trying to avoid doing something that I have to update everytime a table is
added/deleted.
- --
- ----
Philip M. Gollucci
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. :-
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 someho
undocumented feature.
+----
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 . . .
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. i
ing trouble importing a mysql dump using 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
est practice for preserving my database as is when
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 = tbe_
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 790 matches
Mail list logo