Re: mysqldump --single-transaction causes database to become unusable

Hi , --single-transaction will execute the same nature of mysqldump command with begin and end transaction. How ever the table is locked for the backup your site may be slow. -- Praj Ian P. Christian wrote: Recently my one and only slave went down, and stupidly I don't have a dump suitable

Re: optimizing mySQL

Also, when a query takes too long I kill it by shutting down the server, is this safe or is there a better alternative (MyISAM tables)? Use show processlist to see the query that taking more time and use kill processid; for terminating the query . -- Praj Surendra Singhi wrote: Hello

Re: adding columns to a large table

base dir . -- Praj |Helen M Hudson wrote: let you know shortly or I have a table with about 3million rows and I'm having trouble altering it to add 4 more columns. I'm using the MySQL Administrator and I've left it more than 24hours and its still not finished. I was going to try using a login

Re: pkgadd error

Not sure iam right . Try without gunzip 'ing the pkg . zehra cagnan wrote: Hi all, I am trying to install mysql-standard-5.0.24. My OS is Sun Solaris 9. I down loaded the binary package mysql-standard-5.0.24-solaris9-sparc.pkg.gz from your web site. I can unzip the file with no problem

Re: How to delete all rows....

If its one time .. i will suggest to take a mysqldump of table structure only and drop the database import the backup . [EMAIL PROTECTED] wrote: Hi All, How do I delete all the rows of all the tables(but not table) in the database at one shot. Regards, Ravi K The

Re: how can I access to mysql fro moutside?

U can chk firewall by doing a telnet to the remote host on 3306 ( default ) port . Error message looks like username/password might be wrong . [EMAIL PROTECTED] wrote: hi, I'm trying to access to mysql on dedicated web server (hosted by hosting company) using MySQL Administrator. Right now

Re: how can I access to mysql fro moutside?

Okie there might be a entry in mysql.user table having username and password column as blank . That might result in Access denied when u use password . Try this , use mysql ; select * from user where user=''; if so , Delete those entries . [EMAIL PROTECTED] wrote: I can connect using

Re: myisam primary key with innodb primary key..

Hi Lakshmi , I guess both treated same . But physical structure of storage is different from Myisam and Innodb . Correct me if iam wrong . Lakshmi wrote: Hi, I want to know is there any difference between myisam primary index vs innodb primary index... -- MySQL General Mailing List

Re: How to find the no of Inserts and selects

mysql show status like 'com_update'; +---+---+ | Variable_name | Value | +---+---+ | Com_update| 0 | +---+---+ 1 row in set (0.00 sec) mysql show status like 'com_insert'; +---+---+ | Variable_name | Value |

Re: Row count discrepancy when converting from MyISAM to InnoDB

- Praj Dilipkumar wrote: Hi, Instead of using select count(*) from tablename You can try with show table status like 'tablename' This doesn't takes much longer time. Thanks Regards Dilipkumar - Original Message - From: David Hillman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent

Re: Incremental Backup

Kaushal, Do a flush logs when you do full backup , And copy your Binary log files ( After Full Backup ) for incremental . Correct me if iam wrong . -- Praj Kaushal Shriyan wrote: Hi ALL Can we have incremental backup of MySQL Database and if its there How do we do it Thanks and Regards

Re: LOAD DATA INFILE

Do chmod -R 755 on datapath Thanks Praj - Original Message - From: Jay Paulson (CE CEN) [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, January 11, 2006 10:47 PM Subject: LOAD DATA INFILE I'm creating a file via PHP after getting information from a log file. I create

Re: checking for corruption?

Hi , Alternate solution : Do show table status on that database . In comment field you can find info about corrupted table . This will be faster than check table . Thanks Praj - Original Message - From: N.J. Thomas [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January

Re: Mysql database capacity

Sujay , Tables : 1 (only 1) ::: Innodb or Myisam ? I see lots of updates happening on that table so , how frequent do you defragment the table . -- Thanks Praj On Mon, 9 Jan 2006 01:46:39 -0800 Sujay Koduri [EMAIL PROTECTED] wrote: I am giving the system configuration which we are using