Diff between restore from tar and recover from power outage

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 we

Re: Should the db be shutdown before backing up?

"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

Should the db be shutdown before backing up?

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 "new

Should the db be shutdown before backing up?

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 "new

Re: Is an index on varchar column efficient?

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

Re: Is an index on varchar column efficient?

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

Is an index on varchar column efficient?

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? BTW, here is the scenario: create table `test` (`phonenumber` va

Re: LEFT/RIGHT Joins not working

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

Re: LEFT/RIGHT Joins not working

this page very carefully before you continue: http://dev.mysql.com/doc/refman/5.1/en/join.html - michael On 4/3/07, murthy gandikota wrote: > I tried the following 2 SQL's and the results are less than satisfactory. The > RIGHT join does not show where disposition is NULL. The LEFT join

LEFT/RIGHT Joins not working

I tried the following 2 SQL's and the results are less than satisfactory. The RIGHT join does not show where disposition is NULL. The LEFT join shows dispositions as NULL where they shouldn't be. Also the LEFT join generates more dupes. Any way to fix this? select cust.first as FIRST, cust

What does NOW() return: linux time or something else?

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? Browse Top Cars

Disk parition full

Hi I have looked up earlier postings on disk partitions and mysql and couldn't find any discussion threads. Mysql is storing data in the /usr partition of Redhat 9. The /usr partition is about 50% full. Within a year it will outlast the available space on /usr. The /var partition on the

Re: JSP/JSTL problem

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

Re: JSP/JSTL problem

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

Re: JSP/JSTL problem

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

Re: JSP/JSTL problem

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

JSP/JSTL problem

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),

Can Primary Key be added with ALTER?

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! Mail

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

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

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

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

Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

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

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

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:

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

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

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

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

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

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&#

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

(777 works, or 775/770 if owned by mysql user) on your new directory ('sfgnew')? If you don't have execute permission for the mysql user on that dir, MySQL can't list the contents ... Dan murthy gandikota wrote: > > I'm getting the following error > ER

ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

I'm getting the following error ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1) This is the output from mysqld 060613 19:59:34 InnoDB error: Cannot find table sfgnew/agent from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe yo

MYSQLDUMP uses database name in the SQL statements?????!!!!!!!!!!!

I've checked the dump file I created with mysqldump on a database sfg, and it has statements like the following: DROP VIEW IF EXISTS `advAPI`; CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select `sfg`.`advertiser`.`advertiserid` AS `advertiserid`,count(`sfg`.`cust`.`custid`) AS `api` from

Can't CREATE table using SELECT

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

ERROR 2013 (HY000): Lost connection to MySQL server during query

Hi, I am getting this error. Can anyone please help? mysql> create table sfgbackup.advEmail select * from sfg.advEmail; ERROR 2013 (HY000): Lost connection to MySQL server during query Bye [EMAIL PROTECTED] mgandikota]$ mysql -V mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686) Thanks Mur

Copying tables sans data from one database to another

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

TABLE and VIEW have same IDENTIFIER: PLEASE HELP

I created a sql file for database sfg as follows: mysqldump -uuser -ppassword sfg > backup.sql Then I tried to reload it in another database sfg2 mysql -uuser -ppassword sfg2 < backup.sql I get the error message saying the table already exists. I traced the error to the lines where the views ha