Dear All,
Today i faced an issue while issuing commands on my innodb tables.
When I issued any drop table or alter table command my query gets into
waiting state for more than 15-20 minutes.
Mysql Version :-5.5.4 community
I researched on the issue and find that every command try to get lock
>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
>loops
>through the country names and creates an SQL script? That would be fast
>entering AND fast
>performing!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
No one here has any experience with it?
W.
On 4/4/2012 2:17 PM, Claudio Nanni wrote:
> Wes,
> Thanks for these questions about this 'ghost' of the MySQL world, it
> seems more a legend than a real thing!
> I am sorry I do not have the answers but I would love to hear some.
>
> All I can say is t
2012/04/05 02:15 -0700, sam
I have data file written in SQL Server Compact.I need to Convert it to MySQL.
Does anyone know how to do that?
If it stores in CSV files, you can use that for the data, although to make
MySQL read it, you hav to fiddle with it. The SQL, for tables &
may be following will solve:
a. create file '/var/lib/mysql/mysql.sock' if not exist, i mean verify
path.
b. check permission of mysql dir, logfile and other files. /var/lib/mysql
c. check the error log it will show you more details about error..
2012/4/5 Peter Boros
> Hi,
>
> What are the
> From: joe j
>
> Thanks. I was looking for a loop--not to gain speed but to reduce the
> length of my script file:) I'll try and hopefully it will work!
Is there any reason (besides human keystrokes) that you want a short script?
If not, how 'bout the best of both worlds: create a UNIX (or per
Hi,
What are the parameters you are trying to change? What does the error
log say?
Peter
On Thu, 2012-04-05 at 14:40 +, Manivannan S. wrote:
>
> I am not facing the MySQL server problem during installation. I have
> installed those two rpm packages in my machine successfully an
I am not facing the MySQL server problem during installation. I have
installed those two rpm packages in my machine successfully and started working
in mysql.
I am trying to the change parameter value in my.cnf file to tune up the
server for performance improvements. Fo
2012/04/04 19:56 +0200, joe j
/*STEP 2. from the dos prompt?*/
for x in UK ZA IN CN;
do mysql -ujoe -p -e "INSERT INTO `table_new`
SELECT var1, var2`, (case when (country='${x}') then 1 else 0 end) AS citizen
,'${x}' AS ctry
FROM `'${x}'_table`
LEFT JOIN
WORLD
USING(YEAR)";
For some r
This year's MySQL conference is hosted by Percona and takes place next
week in Santa Clara, CA. There is a day of tutorials from experts in
MySQL, followed by 2 days of keynotes, conference sessions, networking
events, receptions, birds-of-a-feather sessions, and much more. The
conference has 8 con
Unfortunately they don't have MySQL Migration Toolkit for Ubuntu
--- On Thu, 4/5/12, Pothanaboyina Trimurthy wrote:
From: Pothanaboyina Trimurthy
Subject: Re: Convert SQL Server Compact data to MySQL
To: "sam"
Date: Thursday, April 5, 2012, 4:56 AM
hello sam
you can convert that file into
I am not using random binaries. I am using rpm packages only which are already
tested and preconfigured. By installing rpm package also I am facing the same
issue.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, April 05, 2012 4:12 PM
Cc: mysql@l
Hi,
In 64-bit Linux(Centos/Red Hat) machine when I am trying to
start the MySQL service by using service mysql start command , I am getting the
following error
Ø Starting MySQL.Manager of pid-file quit without updating file [FAILED]
If I try to stop the MySQL service I am
Am 05.04.2012 12:27, schrieb Manivannan S.:
> Hi,
>
> In 64-bit Linux(Centos/Red Hat) machine when I am trying to
> start the MySQL service by using service mysql start command , I am getting
> the following error
>
>
> I have installed
>
> MySQL-client-5.1.52-1.glibc23.x86_6
boah do not top-post!
this was a typo - seems you did not understand my question
WHY are you downloading random binaries instead using
packages from your linux distribution which are tested
and preconfigured?
Am 05.04.2012 12:39, schrieb Manivannan S.:
> Hi,
>
> If I execute "service myqsl
Hi,
If I execute "service myqsld start" its saying
mysqld: unrecognized service
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, April 05, 2012 4:05 PM
To: mysql@lists.mysql.com
Subject: Re: Error in starting MySQL s
Thanks, Johan.
I run the script in Unix indeed-don't know why I said Dos:)
The problem is caused (at least that is the sense I get, so far) when
I use some conditional statements inside "case when" as:
(case when (country='${x}' AND var2<>"") then 1 else 0 end)
The problem lies with the "<>" pa
Hello,
I have data file written in SQL Server Compact.I need to Convert it to MySQL.
Does anyone know how to do that?
Thank you,
Sam
- Original Message -
> From: "joe j"
>
>
> /*STEP 2. from the dos prompt?*/
>
> for x in UK ZA IN CN;
> do mysql -ujoe -p -e "INSERT INTO `table_new`
> SELECT var1, var2`, (case when (country='${x}') then 1 else 0 end) AS
> citizen
> ,'${x}' AS ctry
> FROM `'${x}'_table`
> LEFT JOIN
>
- Original Message -
> From: "Rick James"
>
> That sounds like the wrong way to design the schema. Why not have
> `country` as a column in a single table?
Given that he got all the data for the new tables from existing ones, I was
assuming he needed separate tables for some specific pu
20 matches
Mail list logo
