Re: mysqldump error 1064 for database Use command

Hi win.a,   I tried with another user the problem still persists. I am getting same error for another user as well. -- Regards, Manasi Save On Tue, 7 Sep 2010 11:41:35 0800, "win.a" wrote: use another user and dump the data ,eg the root . > mysqldump -uroot -p -

Re: mysqldump error 1064 for database Use command

No it does not. But when I dump database name "mydb" it does. but not the database with name "1". -- Regards, Manasi Save On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote: On 06/09/2010 6:54 a, Manasi Save wrote: > > Dear Nitin, > > > > I hav

Re: mysqldump error 1064 for database Use command

ora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. --Regards, Manasi Save On Sat, 4 Sep 2010 21:00:22 -0700 (PDT), Nitin Mehta wrote: Hi,   Have you recently upgraded your MySQL installation? 1064 in earlier days used

mysqldump error 1064 for database Use command

. The backups uptill now was happening properly. Please let me know if I am missing out any information which should be provided to get more clear idea about this error.   Any input will be a great help.    Thanks in advance. -- Regards, Manasi Save

How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

advance. --Regards, Manasi Save Database Administrator

Re: MySQL data get and set problem

Hi Michale,   I have made that parameter column name change. but I am unable to understand how even after execution of update statement and commit after that, data is getting reverted.   Any inputs on this will be a great help. -- Regards, Manasi Save On Mon, 9 Aug 2010 14:11:19 -0400

MySQL data get and set problem

lling SP_GetMyID again. It gives me OUTPUT  as 1. --Regards, Manasi Save Artificial Machines Private Limited manasi.s...@artificialmachines.com Ph:-9833537392

Insert blob data using prepared statements

rror saying mysql syntax near ** STREAM DATA..     Can anyone give me any example how to insert blob data in database with prepared statement.   Thanks in advance. --Regards, Manasi Save Artificial Machines Private Limited manasi.s...@artificialmachines.com Ph:-9833537392

How to decode base64 encoded text from mysql

  Hi All,   Is there any way I can decode base64 encoded message from mysql. I tried using mysql decode function but it did not work for me.   Can anyone provide any input on how I should go about it.   Thanks and Regards, Manasi Save   -- MySQL General Mailing List For list archives: http

MySQL Cluster Out of fragment records (increase MaxNoOfOrderedIndexes)

go about this error. As I have only few hundred records in my table and still i m getting this error.   Thanks in advance.   -- Regards, Manasi Save

Re: MySQL Replication - Master-Slave crash

tName = tbl2.FirstName, T3.LastName = tbl2.LastName Where T3.UserID = tbl2.UserID;   Insert into MyTbl(UserID, Name) Select UserID, Concat(FirstName,' ',LastName) From norep_Temp3; -- Regards, Manasi Save  On Wed, 23 Jun 2010 18:47:19 0530, Nilnandan Joshi wrote: Hi Manasi, > >

MySQL Replication - Master-Slave crash

Hi All,   I have kept  Replicate_Wild_Ignore_Table = mydb%.temp_%   this is temporary table  which i want should not be replicated. But still it is getting replicated and slave is getting crashed.     any input will be a great help. --Thanks and Regards, Manasi Save Artificial Machines Private

Re: Replication of MySQL Stored Procedure

I think even if you ignore the mysql database from replication and set Is_Deterministic = YES then your stored procedures will be replicated. Please set it to NO if you do not wish the stored procedures will not be replicated. You can set this in mysql.proc table. -- Regards, Manasi Save

Re: Strange behavior by MySQL Stored Procedure

Does anyone have any sort of any idea on how to deal with this problem? This is happening again and again and not all the time but randomly anytime.--Regards,Manasi Save  On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save wrote: Dear Venugopal, Here's the Sample Java Code Which Calls s

Re: Strange behavior by MySQL Stored Procedure

ocedure} method. Please check the same or let us know how you are executing the Query/Calling the Procedure. Regards, VR Venugopal Rao --- On Fri, 28/5/10, Manasi Save wrote: From: Manasi Save Subject: Strange behavior by MySQL Stored ProcedureTo: mysql@lists.mysql.comDate: Friday, 28 May, 2010, 5:44

Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it

error.   Any specific reason this could happen. Any other possible scenario.   Any input will be a great help.    Thanks in advance. -- Regards, Manasi Save On Mon, 31 May 2010 14:29:16 0200, "Walter Heck - OlinData.com" wrote: This kind of error usually means you ran out of disk spa

ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it

ct Distinct Val >From MyLogs Where TaskName = ','"','Time required to complete task','"',' Order By Val DESC LIMIT ',InputFrom,',',InputTo,';');   Prepare stmt1 From @stmt; Execute stmt1; Deallocate prepare stmt1;   Select AVG(Val) into AvgVal From MyLogs Where TaskName = 'Time required to complete task';   Select Count(*) into Count From MyLogs Where TaskName = 'Time required to complete task';    Select Count, MinVal, MaxVal, AvgVal  From Temp;   END;   --Regards, Manasi Save    

Re: Strange behavior by MySQL Stored Procedure

;,', False',',','"',InputTimeStamp,'"',';');                         Prepare stmt1 From @stmt;                       Execute stmt1;                       Deallocate Prepare stmt1;                         Select InputUserID as RecordInserted;

Strange behavior by MySQL Stored Procedure

known for mysql? Or am I doing something wrong? Any input will be a great help.   --Thanks and Regards, Manasi Save

Application lost database connection

ome input.   Thanks in advance. --Regards, Manasi Save

Re: Using symlinks for database creation in mysql

sql50#User.Name Can anyone help me on how to resolve this error. Please Help. Thanks in advance. -- Regards, Manasi Save Quoting Manasi Save : Hi Johan, Some time back you have solved my problem of creating symlink as database was fixed. But now When I am putting special characters in symli

Re: Using symlinks for database creation in mysql

it but an symlink with special character is not readable. Is it possible that I can read a symplink with special characters as databse. Thanks in advance. -- Regards, Manasi Save Quoting Johan De Meersman : Given that you're talking about "quite a few" folders, I think it

Get count of number of lines from mysql stored procedure

Hi All,I want to find out number of lines are there in all stored procedure written.Is it possible to get the number of lines using a SQL query.Thanks in advance. -- Regards, Manasi Save

Re: SQL query for unique values.

it; Hope this will work fine. -- Regards, Manasi Save Quoting "Ravishankar BV." : Hi, I'm very new to SQL and databases. I need a query for the following: (I'm sure google would have found the answer, but I could not really frame the sentence for the task I'm loo

Re: Reason for MySQL Replication Slave Crash

. -- Regards, Manasi Save Quoting Shawn Green : Hello Manasi, Manasi Save wrote: > Dear All, > > I am using MySQL Master-Master Replication. > > Where most of the times it is happening that my slave crashes with two > errors either :- > > 1. Duplicate Entry (Error No:- 10

Reason for MySQL Replication Slave Crash

reason behind this behaviour of replication.I read somewhere that this can happen when relay-log.info does not get updated. But did not find any reason of how to deal with it. Does anyone faced similar type of issue in MySQL Replication. Any input will be a great help.Thanks in advance.--Regards,Manasi

Using symlinks for database creation in mysql

few folders and symlinks on the same path?Thanks in advance. -- Regards, Manasi Save

Re: MySQL Replication Delete is not gettting replicated

Dear Carlos, Thanks for the response. But I haven't gave any privileges besides repl_slave priv to user replication and replication2 respectively. So does that amke any difference really? Thanks in advance. -- Regards, Manasi Save Quoting Carlos Proal : I dont see anything unusu

Re: MySQL Replication Delete is not gettting replicated

in advance.--Regards, Manasi Save Quoting Anand kumar :can you give us the configuration(.cnf) file from both the masters ?   --Anand On Sat, Jan 16, 2010 at 3:06 PM, Manasi Save <manasi.s...@artificialmachines.com> wrote: Hi All, I have configured MySQL Master-Master Replication on my s

MySQL Replication Delete is not gettting replicated

not getting replicated on its slave.Even if I am doing truncate it is not getting replicated. Can anyone provide any input on this? Thanks in advance.--Regards, Manasi Save

Re: MySQL Master Master Replication and data loss

. -- Regards, Manasi Save Quoting Suresh Kuna : Hi Manasi, As both are implemented by replication, there is a possibility for loosing data. Thanks Suresh Kuna MySQL DBA On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi All, > > > I

MySQL Master Master Replication and data loss

Hi All,I want to implement MySQL Master Master Replication. But I have read in the various documentation that in mysql replication it is possible that I loose data.Is it also applicable to MySQL Master Master Replication. Thanks in advance.--Regards, Manasi Save

Rename mysql database

Hi All,I want to rename my database. but as per the mysql documentation it says, RENAME DATABASE command has been removed from mysql 5.1.Can anyone help me with this, that is there any other way I can rename it. Thanks in advance.--Regards, Manasi Save

Re: mysql Create table in system database

Hi Johan,Is it possible to do such manipulation in NDB, the way innodb works. Thanks in advance.--Regards, Manasi Save Quoting Johan De Meersman :File permissions ? SE Linux ? AppArmor ?On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save <manasi.s...@artificialmachines.com> wrote: Thanks Shawn f

Can't execute the given command because you have active locked tables or an active transaction

n I am doing it through NetBeans then I am getting this error. Well that is what is very strange and I am unable to solve this problem.If anyone could just help me with this.  Thanks in advance.--Regards, Manasi Save

Mysql Keeps crashing

am not even able to debug the problem. I can reporduce it by issuing same insert statement.Also I am using concept of symlinks in mysql data directory.Thanks in advance.--Manasi Save  - End forwarded message -

Re: Delete table definition without .frm files.

Thanks Johan, I tried doing this. When I try to delete that empty table it is giving me an error saying Unknow table 'tblename'. I have created empty .frm file at folder level. can I create one from mysql. Thanks in advance. -- Regards, Manasi Save Quoting Johan De Meers

Delete table definition without .frm files.

afile? Thanks in advance. --Regards, Manasi Save Artificial Machines Private Limited

Re: question regarding mysql database location

Hi Nitin, Yes for the actually directories created mysql is the owner. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > Is mysql the owner of the directories? > > > > - Original Message > From: Manasi Save > To: Johan De Meersman > Cc: Waynn

Re: question regarding mysql database location

Hi Johan, It worked perfectly. Thank you so much for this explanation. I am really greatful. -- Best Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save < > manasi.s...@artificialmachines.com> wrote: > >> Dear Johan, >>

Re: question regarding mysql database location

in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save < > manasi.s...@artificialmachines.com> wrote: > >> Hi Johan, >> >> I am Sorry. If I have complicated the senerio But, this still not fix my >&g

Re: question regarding mysql database location

Thanks Johan, It was really a great help. I'll try to implement it. I dont want to opt for multiple mysql instances option as thats not feasible. I'll get back to you all if it works fine. Thanks again. -- Best Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25,

Re: question regarding mysql database location

(directory) /db5 (directory) /db6 (directory) -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > You don't need to move any databases. Look at this structure: > > /data/disk1/mysql/db1 (directory) > /db2 (directory) >

Re: question regarding mysql database location

Well Waynn, In this case I need to move all the existing databases to new location right. Which I don't want to do. Is it possible that I create sym link between two and use both. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 12:53 AM, Man

Re: question regarding mysql database location

ks in advance. Regards, Manasi Save Artificial Machines Pvt Ltd. > I fixed this by using symlinks for the directories for the underlying > databases. The limit for files is significantly higher than > directories. > > Waynn > > On 11/24/09, Manasi Save wrote: >> Hi All, >

Re: question regarding mysql database location

:2048M:autoextend:max:1024M;/var/lib/mysql/data1/ibdata1:2048M:autoextend:max:1024M; Is there any wayout for this? Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > Hi All, > > I have asked this question before But, I think I am not able to describe > it better. > > Sorry for as

question regarding mysql database location

gards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How normal mysql server 5.1 uses multiple cores

Hi Johan, Thanks for the quick response. Is there any command available in mysql using which I can check how much CPU is being used by each mysql thread. Or any article where how mysql multi-threading works. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > MySQL is alread

How normal mysql server 5.1 uses multiple cores

Hi All, Can anyone provide me any input on How to make mysql use multiple CPU cores avaliable. I am sorry if I am souding very unclear with this. Let me know if you have any questions. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List

mysql accessing one database from another

for this. Please let me know if you need any other information on this. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

How NDBCluster cleans Local checkpoint

2.9G. and on my management console I am getting following Message Node 3: Data usage increased to 96%(63442 32K pages of total 65536) Node 4: Data usage increased to 96%(63439 32K pages of total 65536) Need more information on this. Thanks in advance. -- Regards, Manasi Save -- MySQL

Strange mysql NDB Cluster error "The table '' is full"

. Thanks in advance. Regards, Manasi Save -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql Create table in system database

Thanks Shawn for the quick response. But then What I am doing is I am doing copy paste of one database and rename it to another. but I cannot read the tables inside it. Can you tell me what might be the possible reason for that. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd

mysql Create table in system database

in mysql system database. Can anyone help me on this. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Restore database through SP's

Hi All, I want to restore mysql database through stored procedure as I am creating databases at runtime. Is it possible? Is there any possible workaround for this? Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives

Mysql dynamic database location

Hi All, Is it possible to change or create any database on a specific location. I want to specify a db path at runtime. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Mysql prepare statement

27;Select ',InputTestID,';'); Prepare stmt1 From @stmt; Execute stmt1; Deallocate prepare stmt1; END $$ DELIMITER ; Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: sub query or something else

may be you can use IN clause: SELECT SUM(price)*0.5 AS price1, SUM(price)*0.65 AS price2 FROM table WHERE partner IN ('A', 'B'); -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > I have these query: > SELECT SUM(price)*0.5 AS price1 FROM table WHE

Re: Mysql update query gives error of lock wait timeout

even if its a select it locks all the rows and it is reading with share lock mode. Can anyone give brief idea about what is exclusive lock and how it works and what is share lock mode and how it works. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. > On Sat, Aug

Mysql update query gives error of lock wait timeout

Hi All, I have a query which gives an error of lock wait timeout only this transaction is running with 2 records in the table. The query is : Update Test Set TestFlag = 1 Where TestID = 5; Can this one transaction lock my entire table? -- Thanks and Regards, Manasi Save Artificial

lock wait timeout try restrating transaction

increasing the limit of this parameter. - Thanks and Regards, Manasi Save -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Mysql Cluster data node Setup

iguaration do I need to make on node "B" server. I have just set Management node information on node "B" server. Thanks in advance. -- Regards, Manasi Save -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org