if you have myisam alone tables you can rename the folder of the database. That
can work like rename database. If you have innodb table you have to move one by
one table because details of those tables will be stored in innodb shared table
space. Moving folder cannot work.
Thanks,
Saravanan
really nice tool.
Thanks,
Saravanan
--- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
From: lakshmi pathi <[EMAIL PROTECTED]>
Subject: A tool
To: mysql@lists.mysql.com
Date: Monday, November 17, 2008, 1:25 PM
Hi all,
If you are using mysql in linux with ext3 file syst
If you kill the process in the middle of huge alter. It will take some time to
reverse them back. It will be fast if you have good memory.
Thanks,
Saravanan
--- On Wed, 6/11/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
From: Ananda Kumar <[EMAIL PROTECTED]>
Subject: kill process id
Hi Simon,
what kind of table you are using. If it is myisam you can increase the max size
of table by changing the following variable
myisam_data_pointer_size = 7
as default it should be 6.
Please let me know if that helps you.
Thanks,
Saravanan
--- On Thu, 6/5/08, Simon Collins <[EM
what kind of datatype it is int(50)
parent_id| int(50)
is that big int?
Saravanan
--- On Thu, 5/22/08, Norbert Tretkowski <[EMAIL PROTECTED]> wrote:
> From: Norbert Tretkowski <[EMAIL PROTECTED]>
> Subject: Re: integer
> To: mysql@lists.mysql.com
> Date: T
Hi all,
I tried with 5.1.23-rc why it is very slow while enable sync_binlog? It is
normal and fast with 5.0.
Thanks,
Saravanan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thanks velen. But I want to escape the newlines in the fields. It is annoying
and new lines moves the values in separate line of excel sheet.
Thanks,
Saravanan
--- On Wed, 5/14/08, Velen <[EMAIL PROTECTED]> wrote:
> From: Velen <[EMAIL PROTECTED]>
> Subject: Re: how to esca
line characters?
Thanks,
Saravanan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes it can use multiple cores. Mysqld is a multithreaded service.
Saravanan
--- On Sat, 5/10/08, JW <[EMAIL PROTECTED]> wrote:
> From: JW <[EMAIL PROTECTED]>
> Subject: Best CPU config for a busy DB server
> To: mysql@lists.mysql.com
> Date: Saturday, May 10, 2008
Use
alter procedure procedure_name comment 'comments string'
Saravanan
--- On Wed, 4/30/08, Moon's Father <[EMAIL PROTECTED]> wrote:
> From: Moon's Father <[EMAIL PROTECTED]>
> Subject: Anybody can tell me how to reserve the comments in the procedure
Use
alter procedure procedure_name comment 'comments string'
Saravanan
--- On Wed, 4/30/08, Moon's Father <[EMAIL PROTECTED]> wrote:
> From: Moon's Father <[EMAIL PROTECTED]>
> Subject: Anybody can tell me how to reserve the comments in the procedure
in that server.
Saravanan
--- On Tue, 4/29/08, Mark-E <[EMAIL PROTECTED]> wrote:
> From: Mark-E <[EMAIL PROTECTED]>
> Subject: mysql_install_db
> To: mysql@lists.mysql.com
> Date: Tuesday, April 29, 2008, 3:22 AM
> I have a question on this script. When you run t
Use my.cnf to point the data directory and the user details.
[mysqld]
user=mysql50
datadir=/home/mysql50
Saravanan
--- On Mon, 4/28/08, Mark-E <[EMAIL PROTECTED]> wrote:
> From: Mark-E <[EMAIL PROTECTED]>
> Subject: User Issue
> To: mysql@lists.mysql.com
> Date: Mo
It doesn't lock single table it locks all other select and update statements of
other tables too which I don't use in procedure.
Saravanan
--- On Sat, 3/29/08, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> From: B. Keith Murphy <[EMAIL PROTECTED]>
> Subject: Re: p
blocks. i tried start transaction
and commint for every single update. but the result is same
Saravanan
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http
eds of sql statements in the processlist.
Any Ideas why this happens to me?
Saravanan
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list arch
hi lists,
I want to count the number of rows containing "'" aphostrophe in a particular
field. I tried with
select count(*) from table where field like "%'%"
i get only 0 counts. but I am sure that exists in many rows.
updates the table waits for long time. How can
achieve isolation correctly make other statements proceed without waiting. And
my script updates record by record not as bunch.
should I use transactional statements like "start transaction" and "commit" to
achieve ?
thanks in
| 2008-02-24 | 70 |0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 90 |0 | 2008-02-24 18:10:54 |
| 2008-02-24 |100 |0 | 2008-02-24 18:10:54 |
Saravanan
Hi lists,
I have innodb tables with millions of records. How can i add index without
locking the table.
Saravanan
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL
erating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot
Hi List,
I am trying to write a procedure. I want to know whether the last statement
updated correctly. Then I can add the count.
anybody can help me.
Saravanan
Looking for last minute shopping deals
p-auto-rehash
Saravanan
MySQL DBA
--- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote:
> From: imad <[EMAIL PROTECTED]>
> Subject: The Use database command is too slow
> To: mysql@lists.mysql.com
> Date: Saturday, February 2, 2008, 6:14 AM
> Hello,
>
> I have l
do binary copy. sql dump will be slow.
Saravanan
--- On Thu, 1/24/08, Ivan Levchenko <[EMAIL PROTECTED]> wrote:
> From: Ivan Levchenko <[EMAIL PROTECTED]>
> Subject: transfer huge mysql db
> To: mysql@lists.mysql.com
> Date: Thursday, January 24, 2008, 6:12 PM
> Hi
Hi,
Try the following link
ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc6.x86_64/php-mysql-5.2.5-1.fc6.remi.x86_64.rpm
if that doesn't match your need search http://rpm.pbone.net
Saravanan
--- On Sun, 1/20/08, Apple <[EMAIL PROTECTED]> wrote:
> From: App
did you check time in master and slave servers?
saravanan
--- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote:
> From: Paul Berry <[EMAIL PROTECTED]>
> Subject: another slave loading question
> To: "MySql"
> Date: Saturday, January 19, 2008, 7:56 AM
Hi,
I am new to MySQL. I am not sure how to set timezones. But your slave status
and slave processlist doesn't show any problem. It replicated correctly and
wait for I/O thread to update the relay log.
use '\G' instead of ';'
Saravanan
--- On Sat, 1/19/08, Pau
i am ok with this
mysql> change master to master_host='';
Query OK, 0 rows affected (0.01 sec)
mysql> show slave status\G
Empty set (0.01 sec)
Saravanan
--- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote:
> From: Paul Berry <[EMAIL PROTECTED]>
> Subje
Hi,
will removing the master.info help instead of executing change master?
or
>stop slave;
>reset master;
--- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote:
> From: Paul Berry <[EMAIL PROTECTED]>
> Subject: Re: turn a slave back into its own master
> To: "MySql"
> Date: Saturday, Janu
Kerry,
Post the error you get.
First select the database you are going to use in the right panel.
execute the create table statement.
update the table.
execute the select statement as last.
Saravanan
--- On Sat, 1/19/08, Kerry Frater <[EMAIL PROTECTED]> wrote:
> From: Kerry Frate
Hi,
Split frequently used columns from other non frequently used. Splitting them
will improve the disk access. You don't need to separate as too many tables.
You need to index all the tables if you split into many.
Saravanan
--- On Fri, 1/18/08, Alex K <[EMAIL PROTECTED]> wro
Hi,
Split frequently used columns from other non frequently used. Splitting them
will improve the disk access. You don't need to separate as too many tables.
You need to index all the tables if you split into many.
Saravanan
--- On Fri, 1/18/08, Alex K <[EMAIL PROTECTED]> wro
://dev.mysql.com/doc/refman/5.1/en/installing.html
Saravanan
--- On Fri, 1/18/08, perl pra <[EMAIL PROTECTED]> wrote:
> From: perl pra <[EMAIL PROTECTED]>
> Subject: upgrading mysql on RHEL4
> To: mysql@lists.mysql.com
> Date: Friday, January 18, 2008, 10:21 PM
> Hi Gurus,
>
Hi,
Are you using mysql browser? If yes. It will run only the current line
statement. It will not execute all the three statements. So try one after the
other.
Saravanan
--- On Fri, 1/18/08, Kerry Frater <[EMAIL PROTECTED]> wrote:
> From: Kerry Frater <[EMAIL PROTECTED]>
Hi,
Post the error.
Saravanan
--- On Wed, 1/16/08, Pastor Steve <[EMAIL PROTECTED]> wrote:
> From: Pastor Steve <[EMAIL PROTECTED]>
> Subject: Error
> To: "MySQL List"
> Date: Wednesday, January 16, 2008, 3:32 AM
> Greetings,
>
> I am tryin
Hi,
You don't need to change the hostname to reflect the new server if you run php
from the same server. Could you post the error you get when you insert new
records.
Saravanan
--- On Wed, 1/16/08, meridklt <[EMAIL PROTECTED]> wrote:
> From: meridklt <[EMAIL PROTECTED]>
Hi,
Server parses the statement only once and executes them with the small
difference. It reduces parsing time. Clients don't need to send the full
statement again and again. It reduces traffic.
Saravanan
--- On Mon, 1/14/08, mos <[EMAIL PROTECTED]> wrote:
> From: mos <
. Try to remove them before dropping the database.
Saravanan
--- On Mon, 1/14/08, OldManRiver <[EMAIL PROTECTED]> wrote:
> From: OldManRiver <[EMAIL PROTECTED]>
> Subject: Re: Ghost Tables
> To: mysql@lists.mysql.com
> Date: Monday, January 14, 2008, 11:23 PM
> Al
Hi,
I am getting the following error:
mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
if some one knows the answer . Pl. let me know.
Thanks,
Saravanan K
Dear sir
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
by
Saravanan
__
Do you Yahoo!?
Yahoo! Tax Center - forms
> To: [EMAIL PROTECTED]
> From: Saravanan C <[EMAIL PROTECTED]>
> Subject: From Saravanan, REC, INDIA
> Date: Thu, 1 Aug 2002 13:05:17 GMT
> -
> Hi Lists,
>
> I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for
linux
> platform.
>
makefile found. Stop.
[root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# make install
make: *** No rule to make target `install'. Stop.
What is the problem, I am following the instructions provided in the manual.txt.
I am new to this.
Regards,
Sara
42 matches
Mail list logo
