Hi
When restoring a DB from a tar file, I had to repair some of the tables.
Whereas when the DB is started after a power failure, everything works fine. I
noticed this on RedHat linux and MySQL5.
Any thoughts?
Thanks
Murthy
-
Building a
"Gerald L. Clark" <[EMAIL PROTECTED]> wrote: Mathieu Bruneau wrote:
> murthy gandikota a écrit :
>
>>Hi
>> I did a hot backup a while ago. When I had to restore from backup there were
>> several error messages. So I ran mysqlcheck for every table wi
Hi
I did a hot backup a while ago. When I had to restore from backup there were
several error messages. So I ran mysqlcheck for every table with --auto-repair
option. Is this the best way?
Thanks
Murthy
-
Ahhh...imagining that irresistible &quo
Hi
I did a hot backup a while ago. When I had to restore from backup there were
several error messages. So I ran mysqlcheck for every table with --auto-repair
option. Is this the best way?
Thanks
Murthy
-
Ahhh...imagining that irresistible &quo
Baron Schwartz <[EMAIL PROTECTED]> wrote: murthy gandikota wrote:
> Hi,
>
> I have a table with 2 million records but without an index or a primary key.
> The column upon which I want to create an index is a varchar. Will it give me
> any advantage when I have to do a
mos <[EMAIL PROTECTED]> wrote: At 06:23 PM 4/15/2007, you wrote:
>Hi,
>
> I have a table with 2 million records but without an index or a primary
> key. The column upon which I want to create an index is a varchar. Will
> it give me any advantage when I have to do a select on the column?
>
> B
ld like to get your feedback before I actually do this because I don't
want to create a disruption when the DB is in production.
Thanks
Murthy
-
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
disposition, source.source
from cust LEFT JOIN source ON (cust.source=source.id)
LEFT JOIN disposition ON (cust.disposition=disposition.id);
'123456789', 'dispo2', 'source1'
'123456780', 'dispo1', 'source2'
'123456781', null, null
+---+-+-+
| ssn | disposition | source |
+---+-+-+
| 123456789 | dispo2 | source1 |
| 123456780 | dispo1 | source2 |
| 123456781 | NULL| NULL|
+---+-+-+
I'd appreciate your help.
Thanks
Murthy
Michael Dykman <
cust.disposition=disposition.id) LEFT JOIN leadSource on
(cust.source=leadSource.id) where agentCode=11 and newPayment > 0 and
cust.disposition > 0 order by SOURCE, DISPOSITION
The MYSQL has the following version
mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)
Thanks
Hi
I tried to look up the time functions specifically for the disparity between
NOW() and the linux time obtained with 'date'. Why are they different? How can
I set the database time?
Thanks
Murthy
-
Looking for earth-friendly autos?
ll me how to manage multiple disk partitions in mysql?
BTW, the mysql is version 4 or something like that.
Thanks
Murthy
-
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
ch, you guarantee that
// each resource will have "close" called on it before returning
try
{
rs.close();
}
catch (Exception e) {}
try
{
stmt.close();
}
catch (Exception e) {}
try
{
conn.close();
}
catch (Exception e) {}
}
David
murthy gandikota wrote:
> I tri
t;[EMAIL PROTECTED]> wrote: On 1/2/07, murthy gandikota wrote:
> ps = con.prepareStatement("select first, last from cust where ssn=?");
> int ssnint = Integer.parseInt(ssn.trim());
> ps.setInt(1, ssnint);
> ResultSet rs=ps.executeQuery();
> if ( rs.next()) {
> rs.c
ut.println("Customer already exists " + Integer.parseInt(ssn));
return;
}
do insert (not shown)
I get the message "customer already exists" for EVERY ssn that I tried.
Hassan Schroeder <[EMAIL PROTECTED]> wrote:
On 12/3
I am getting the same result in Java code, i.e. the resultset returned is
non-null even though the primary key value is not found in the table.
Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/29/06, murthy gandikota
wrote:
> I am posting the relevant JSTL code.
Just to clarif
Hi
I have created a table with the following specs:
create table `cust` (
`ssn` int(9) NOT NULL PRIMARY KEY,
`submitdate` date,
`submitto` int(3),
`first` varchar(30),
`last` varchar(30),
`loanAmt` decimal(10,2),
`company` int(3),
Hi
I have a table with no primary key. I'd like to make one of the table columns
as the primary key. Is it possible do it with ALTER? Is there any other way?
Many thanks for your help.
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo!
Looks like I have too many connections to the database. I made sure all the
connections are closed after use. Hope this is the fix. Anyone please confirm.
Thanks
murthy gandikota <[EMAIL PROTECTED]> wrote:
Can someone please help me figure out what's in this mysqld output befor
nosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
murthy gandikota <[EMAIL PROTECTED]> wrote:
Hi
Can someone tell me where in the file system to look for the
Hi
Can someone tell me where in the file system to look for the logs?
Mysql has been crashing once every hour. Memory is not the issue. This is
how I start the mysql:
nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/
local/mysql/var --user=mysql
--pid-file
f the `sfg` patterns with `sfgnew`. As you may
guess, I don't intend to this often. Why can't we have a tool that copies one
DB into another? BTW, I tried create table with select and it didn't work.
Michael Stassen <[EMAIL PROTECTED]> wrote:
murthy gandikota wrote:
operation, please note that I am
only interested in preserving the schema without the data. Is it possible to
just transfer the schema to a new database?
Thanks
murthy gandikota <[EMAIL PROTECTED]> wrote:
I can't get mysqldump to work. I typed
mysql -uuser -ppassword sfg < s
ing similar to recreate your tables and move them. HTH.
-phpninja
-Original Message-
From: Dan Buettner
[*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent
one that got dropped at some point?
See
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html
The last half seems relevant - it's pointing you to removing the .frm
file manually. Personally, I'd mv it and not rm it.
Dan
murthy gandikota wrote:
> Hi Dan
> I&#
Hi Dan
I've set the permissions to 777 for all the files and directories. Basically
I did chmod -R 777 sfgnew. Also changed the ownership to mysql using chown -R
mysql:mysql sfgnew.
Thanks!
Dan Buettner <[EMAIL PROTECTED]> wrote:
Murthy, do you have appropriate permissions
nyone please help me figure this out?
Here are some pertinent facts:
a) stopped mysqld
b) copied files from sfg to sfgnew in the var directory
c) set the permissions to 777 (read, write, execute) for all the files in
sfgnew
d) restarted
won't
work because the sql is referring to sfg database. I think this is the reason
why I'm facing the problems (sorry for multiple threads). Can anyone confirm my
suspicion and suggest a fix? I'm thinking manually changing all the entries. Is
that the only way?
Thanks
Hi
The following happened when I tried to create table. Can anyone please help?
mysql> create table sfgbackup.advEmail select * from sfg.advEmail;
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 corrup
nks
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
views have the same identifier as the tables. I don't
know if it is possible to have views and tables the same identifier. I didn't
create these views.
Can someone please help me figure this out?
Thanks
Murthy
__
Do You Yahoo!?
Tired
> sql,query,queries,smallint
how to insert only blank spaces into a field. Its getting trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
how to insert only blank spaces into a field using insert query. Its getting
trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
; [EMAIL PROTECTED]
> Phone : +33 1 44 89 77 59
>: +33 1 44 89 77 50 (secretariat)
> Mobile : +33 6 64 63 00 15
> -
>
>
> -----
> Before posting, please chec
thing happened with that too. i
guessed that was because of the alpha version db. so i downgraded to
mysql3.23.
regards,
On Thu, 2 May 2002, Jeremy Zawodny wrote:
> On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote:
> >
> > I have created only one database with 18 table
ppens randomly.
One more thing i noticed is that when i run the 'show table status' it
says 1000 rows in the table that has lost all the records.
Could someone help me here. help is greatly appreciated.
regards,
--
__
hi,
I had posted a few days back regarding having problems running MySQL on WIN
2000...
I forgot to add before, I can ping my localhost but unable to do a telnet
localhost too...
I had installed and was running MySQL and PHP with IIS successfully for
nearly 2 mths now... All of sudden since a fe
hi,
I had posted a few days back regarding having problems running MySQL on WIN
2000...
I had installed and was running MySQL and PHP with IIS successfully for
nearly 2 mths now... All of sudden since a few days back the MySQL service
refuses to start and keeps giving various errors such as unab
Unable to start the service MySQL thru ctl panel/services too.
Tried reinstalling MySQL but to no avail...
frustrating...
sandeep
- Original Message -
From: "yilmaz" <[EMAIL PROTECTED]>
To: "Sandeep Murthy" <[EMAIL PROTECTED]>
Sent: Tuesday, November 20,
Hi all,
Am facing a strange problem... I am running MySQL on a WIN 2000 server and
was running fine till this morning..
I am using PhpMyAdmin to administer the databases.. Suddenly all of a sudden
I could no longer connect to the databases and keep getting an error saying
"
Can't connect to MySQ
Have been spammed too by NuSphere earlier on.. so junked my earlier mail id
and switched to the present one...
let all the subscribers carry a vote to hv this spammer banned from this
list...
sandeep
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Michael A. Peters"
b to show the new data on my frontpage..
I hope I could convey what I need..
Would appreciate any more suggestions...
TIA,
sandeep
- Original Message -
From: "jim barchuk" <[EMAIL PROTECTED]>
To: "Sandeep Murthy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]&
Hi all,
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 & 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the postions 5,6
Hi all,
I feed data into a db and a jscript draws that data from the db and dumps it
in a Marquee on the pg but what happens is everytime i feed in data, there
is an sql update query which updates my db overwriting earlier data... but i
need to archive the data which i wrote earlier so am trying
The database I have created for storing images has a field called
binary_junk which is of type "BLOB" but its still not working...
TIA,
sandeep
- Original Message -
From: "AJDIN BRANDIC" <[EMAIL PROTECTED]>
To: "Sandeep Murthy" <[EMAIL PROTECTED]&g
hi all,
I have been trying to insert images into my mysql database thru PHP for the
past 2 days without any luck.. After having tried various combinations of
queries, I gave up..
Wud be grateful if anyone can post a query for inserting images in to my
database..
TIA,
Sandeep
This is what i h
Can anyone please guide me in uninstalling MySQL...
P.S: i did a rpm -e but there was no mysql rpm package...
tia,
sandeep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
hi,
Can anyone pl tell me as to how I can resolve a missing mysql.sock
problem??? Can anyone pl send me the mysql.sock file??? been trying to
start mysql for the past 3 days and everytime am getting a "unable to
connect localhost error, missing mysql.sock"
I tried most of the suggestions foun
Dear Sir,
Hello,
We have installed MySql in Windows NT Server.
MysqlAdmin services are doing fine and but when we try
to enter the prompt of mysql.we are getting the
follwing error
ERROR :1045
Access denied for user 'odbc@localhost )using password
yes
port is:3306 and user is :root
How to r
50 matches
Mail list logo
