If you want to specify the password itself on the command line use
'--password' (double hyphen). '-p' requests interactive password
prompt.
- michael
On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen cars...@bitbybit.dk wrote:
don't have a space between '-p' and 'password', i.e. -ppassword
was increase the instance memory but still problem not solved. i
don't have much idea in mysql..
thank in advance..
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
I need to read an array's content using a while loop and inside the loop
read another array's content. Using the variables from the two arrays I need
to execute a query. My problem is the inner while loop reads all records of
the array whereas the outer while loop exits after reading the first
Hi,
Lets see If I can help.
Overly long queries (transactions
in general) are bad for performance as a lot of unpurged versions
accumulate.
In this sentence, I don't know the meaning about 'unpureged version
accumulate'
When rows are updated new versions are created. They are later
HI Peter:
Thanks for your answer. I have understand your answer. Thank you very
much.
――
Best regards
Timo Seven
blog: http://zauc.wordpress.com
#请翻墙浏览,或者指定hosts到74.200.243.252###
UNIX System Admin
2010/3/23 Peter Zaitsev p...@percona.com
Hi,
Lets see
Hi everyone:
I read the presentation about InnodDB performance optimization what
Heikki Tuuri written in april23 2007.
But now I have some sentences don't know how to understanding. Can you help
me?
Overly long queries (transactions
in general) are bad for performance as a lot of unpurged
Here I have to update year column with reference to the row id
mysql update table1
- set year=case when id=1 then 2000
- when id=2 then 2001
- when id=3 then 2000
- when id=4 then 2001
- when id=5 then 2000
- when id=6 then 2001
- else 2003
- where
and 6;
Good luck!
Regards,
m
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Friday, February 05, 2010 12:04 PM
To: mysql@lists.mysql.com
Subject: help me out for this problem...
Here I have to update year column with reference to the row id
: Friday, February 05, 2010 12:04 PM
To: mysql@lists.mysql.com
Subject: help me out for this problem...
Here I have to update year column with reference to the row id
mysql update table1
- set year=case when id=1 then 2000
- when id=2 then 2001
- when id=3 then 2000
I thank you all who responded to solve my problem in using the source command
to execute a mysql script saved on a notepad. Thank you, for your tips, I've
solved the problem. When I was using the \.create.sql at the prompt I wasn't
giving the full path where 'create.sql' is residing. Once I
I'm very new to MySQL, Tomcat, connection pooling, JSP, etc. and I've
been banging my head against a wall for two weeks trying to get a simple
program to connect to a MySQL database.
*Vital Stats:*
Ubuntu 9.10, Java 1.6.0_0, Java Servelet 2.5, Java Server Pages 2.1,
JSTL 1.2, Apache2,
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote:
[snip]
I create the WAR (jar cvf testapp.war *), undeploy the old version and
redeploy the new one through Tomcat Web Application Manager. Then restart
Tomcat (sudo /etc/init.d/tomcat restart). The result is:
Jan 21, 2010 9:40:35 PM
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Jan 21, 2010 9:43:06 PM
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO:
skip-networking is OFF
On 1/22/2010 12:09 PM, Mark Matthews wrote:
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010
mySQL-5.1.34-osx10.4-powerpc-64bit
Not sure how this happened, but mySql will not start anymore, either
from the command line or the system pref control panel.
here's a startup sample: [I have blocked out the password]
Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/
can you give us the error , it can be found on the file
/usr/local/mysql/data/Power-Mac-G5.local.err
Thanks
Anand
On Thu, Jan 14, 2010 at 9:49 AM, Chris Elhardt celha...@mac.com wrote:
mySQL-5.1.34-osx10.4-powerpc-64bit
Not sure how this happened, but mySql will not start anymore, either
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I have checked that, and reverse DNS is OK -
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
regards
anandkl
On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes
sq...@dahl-stamnes.netwrote:
On Monday 11 January 2010
On Monday 11 January 2010 09:55, Ananda Kumar wrote:
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and
'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve to
192.18.2.22
I read you solved your problem
read you solved your problem, but by reverse I meant what
r2-d2.dahl-stamnes.net resolves to.
Sorry (...) what 192.18.2.22 resolves to.
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
+261 34 29 155 34 / +261 33 11 207 36
have checked that, and reverse DNS is OK - both resolve to
192.18.2.22
I read you solved your problem, but by reverse I meant what
r2-d2.dahl-stamnes.net resolves to.
Sorry (...) what 192.18.2.22 resolves to.
it resolv to r2-d2.dahl-stamnes.net
--
Jørn Dahl-Stamnes
homepage: http://www.dahl
Hello
I have installed mysql, apache and phpmyadmin on a new server running Fedora
Core 12.
For some unknown reason I cannot connect to the local host using a full
hostname.
This is what I have done:
r2-d2# mysql -u root -p
grant all on . to 'root'@'r2-d2' idenfified by 'secret-password';
...@dahl-stamnes.net
Subject: Problem with mysql
Sent: Jan 10, 2010 3:20 PM
Hello
I have installed mysql, apache and phpmyadmin on a new server running Fedora
Core 12.
For some unknown reason I cannot connect to the local host using a full
hostname.
This is what I have done:
r2-d2# mysql -u
by
'secret-password';
--Original Message--
From: Jørn Dahl-Stamnes
To: mysql@lists.mysql.com
ReplyTo: sq...@dahl-stamnes.net
Subject: Problem with mysql
Sent: Jan 10, 2010 3:20 PM
Hello
I have installed mysql, apache and phpmyadmin on a new server running
Fedora Core 12.
For some
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK theyaho...@gmail.com wrote:
Hi Victor,
You have given space after the comma(shown here: ('Small, Medium,
XSmall')). Take out the space and try, it will work.
Example:
mysql insert into products(sizes) values ('Small,Medium,small,medium');
Query
Hi Victor,
Take out the double quotes from[ ('Small,Medium,XSmall'),
('teal_E2725B,black_FF,yellow_9ACD32')]. Its working fine for me.
mysql insert into products (sizes, colorsShadesNumbersShort)
values(('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32'));
Query OK, 1 row
On Fri, Jan 8, 2010 at 9:29 AM, Thiyaghu CK theyaho...@gmail.com wrote:
Hi Victor,
Take out the double quotes from[ ('Small,Medium,XSmall'),
('teal_E2725B,black_FF,yellow_9ACD32')]. Its working fine for me.
mysql insert into products (sizes, colorsShadesNumbersShort)
OK, guys, I'm totally confused:
mysql insert into products (SKU, Category, Name, Title, Description, Price,
SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
ShipPercentWeight, sizes, colorsShadesNumbersShort) values (prodSKU1,
prodCat1, name1, title1, descr, 12.34,
Hi Victor,
You have given space after the comma(shown here: ('Small, Medium, XSmall')).
Take out the space and try, it will work.
Example:
mysql insert into products(sizes) values ('Small,Medium,small,medium');
Query OK, 1 row affected (0.05 sec)
Regards,
Thiyaghu CK
www.mafiree.com
On Fri,
Hi;
The following doesn't work with or without enclosing the sets in quotes:
update products set SKU=prodSKU2, Category=prodCat1, Name=name2,
Title=title2, Description=descr, Price=22.55, SortFactor=500,
Availability=1, OutOfStock=0, Weight=5.5, ShipFlatFee=10.0,
ShipPercentPrice=5,
On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman mdyk...@gmail.com wrote:
I don't really use sets when I can avoid them (too much special
wierdness) but from the manual I see this:
mysql INSERT INTO myset (col) VALUES
- ('a,d'), ('d,a'), ('a,d,a'), ('a,d,d'), ('d,a,d');
Query OK, 5 rows
so you dropped the quotes around the unneccessarily bracketed
expression? It's hard to diagnose when your example isn't even what
you think is syntactically correct.
I can't find a reference, but i recall there is some limit on the
length of SET member identifiers.. some of yours look longish,
On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman mdyk...@gmail.com wrote:
so you dropped the quotes around the unneccessarily bracketed
expression? It's hard to diagnose when your example isn't even what
you think is syntactically correct.
Here's my example again. Syntactically correct. From
On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder hassan.schroe...@gmail.com
wrote:
On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi victorsube...@gmail.com
wrote:
Here's my example again. Syntactically correct. From my original post:
update products set SKU=prodSKU2, Category=prodCat1,
On Wed, Jan 6, 2010 at 2:34 PM, Hassan Schroeder hassan.schroe...@gmail.com
wrote:
On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi victorsube...@gmail.com
wrote:
mysql update products set SKU=prodSKU2, Category=prodCat1,
Name=name2, Title=title2, Description=descr, Price=22.55,
How about you show us the schema for the table so we know what is
defined as what?
Also, as the update does succeed, it would be interesting to see what
value actually got stored. After you have accounted for each bit in
the stored value, we might have a clue about what is being truncated.
One
On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman mdyk...@gmail.com wrote:
How about you show us the schema for the table so we know what is
defined as what?
Done in last email.
Also, as the update does succeed, it would be interesting to see what
value actually got stored. After you have
mysql create table t (sizes
set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge'),
colorsShadesNumbersShort
set('blue:99','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:FF','yellow:9ACD32'));
If I can login from a shell, what could stop a script from login?
I'm following a newbie tutorial for django, a web content mgt. system.
The following user and password are good if I use them fromthe same shell the
script launches from.
Here's the error message from a django script using a
John Griessen wrote:
If I can login from a shell, what could stop a script from login?
privileges were stopping it and at first, maybe a mistake in GRANT setup of a
new user.
Nevermind
JG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
: John Griessen [mailto:j...@industromatic.com]
Sent: Wednesday, December 09, 2009 10:16 AM
To: mysql@lists.mysql.com
Subject: login problem from django script, using
python2.5/MySQLdb/connections.py
If I can login from a shell, what could stop a script from login?
I'm following a newbie tutorial
On Sun, Dec 6, 2009 at 2:42 PM, Steve Edberg edb...@edberg-online.comwrote:
At 1:26 PM -0500 12/6/09, Victor Subervi wrote:
Hi;
I have the following:
mysql select * from categoriesProducts as c inner join
relationshipProducts
as r on c.ID = r.Child inner join categoriesProducts as p on
Hi;
I have the following:
mysql select * from categoriesProducts as c inner join relationshipProducts
as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = prodCat2;
ERROR 1054 (42S22): Unknown column 'prodCat2' in 'where clause'
mysql describe
At 1:26 PM -0500 12/6/09, Victor Subervi wrote:
Hi;
I have the following:
mysql select * from categoriesProducts as c inner join relationshipProducts
as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = prodCat2;
ERROR 1054 (42S22): Unknown column
Hi;
mysql insert into categories (Category, Parent) values ('test', NULL);
ERROR 1062 (23000): Duplicate entry '0' for key 1
mysql describe categories;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
Oops. Never mind.
V
On Sat, Dec 5, 2009 at 1:19 PM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
mysql insert into categories (Category, Parent) values ('test', NULL);
ERROR 1062 (23000): Duplicate entry '0' for key 1
mysql describe categories;
automysqlbackup on the actual machine and
simply dump to an external drive or another server on the network.
On 2009-11-20, at 12:58 PM, René Fournier wrote:
Yes, still exhibits this problem -- although at a different line in the file.
(Seems random.) I should also mention, the backup is running across
again.
Thanks for the idea though. At least I'm not the only one to have encountered
that error.
...Rene
On 2009-11-21, at 5:44 AM, 王浩 wrote:
i googled the problem,it says that's a mysql bug.This is the source page
:http://www.shinguz.ch/MySQL/mysql_trouble_shooting.html#backup_restore
again.
Thanks for the idea though. At least I'm not the only one to have
encountered that error.
...Rene
On 2009-11-21, at 5:44 AM, 王浩 wrote:
i googled the problem,it says that's a mysql bug.This is the source page
:http://www.shinguz.ch/MySQL/mysql_trouble_shooting.html#backup_restore
1136 (21S01) at line 6300: Column count doesn't match value count at row
6253
So, a different error. And it appears that each time mysqldump runs, the
resulting file has different problem.
On 2009-11-21, at 5:05 PM, Claudio Nanni wrote:
There is a bug in mysqldump that prevents mysql from
On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan yuan4...@gmail.com wrote:
Hi Victor,
It looks to me the foreign key syntax is wrong. Can you create the
Relationship table on your database by using below ddl?
create table if not exists Relationship
(ID integer auto_increment primary key,
Parent
-- about 10GB.
The other databases automysqlbackup backs up are fine.)
Basically on the import, MySQL fails and returns an error indicating a problem
with the dump file:
mysql -u root -p dump_file.sql (~10GB)
Enter password:
ERROR 1300 (HY000) at line 426: Invalid utf8 character string: '?03422
problem with mysqldump / automysqlbackup (ERROR 1300)
I've been using automysqlbackup 2.5 for years on a particular database, and
it's always performed great. Recently, however, I've become encountering
problems when trying to re-import one of its dumped sql files. (Not sure if it
matters
Yes, still exhibits this problem -- although at a different line in the file.
(Seems random.) I should also mention, the backup is running across a local
network. The machine the starts automysqlbackup (and internally, mysqldump)
connects over TCP/IP to the database server. I am going to try
Hi;
I don't claim to be an expert in MySQL. The following code was largely
supplied to me by someone who was. I don't really understand foreign keys.
He wrote this off the top of his head, and it's throwing an error. Here's
the python code:
def catTree():
user, passwd, db, host = login()
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
Dear Michail and Sergey,
Thank you very much for your responses and kind suggestions!
On 29.10.2009, at 16:53, Sergey Petrunya wrote:
this makes it clear that index on O1.tsn will not be useful. You
need indexes
on parent_tsn column.
mysql alter table taxonomic_units1 add index
| |
++-+---+--+---+--+-
+--++---+
6 rows in set (0.00 sec)
What is wrong with this query? Or is it a problem of all adjacency
list models?
Is there a way to get columns indexed using self-joins?
Thanks,
Olga
--
MySQL General Mailing List
Not sure if this is the exact problem you're trying to solve, but this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Thanks Kabel,
Not sure if this is the exact problem you're trying to solve, but
this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Yes, I have seen this article before, and it is really nice. However
they do not discuss any
| 483305 | |
| 1 | SIMPLE | O6| ALL | NULL | NULL | NULL|
NULL | 483305 | |
++-+---+--+---+--+-
+--++---+
6 rows in set (0.00 sec)
What is wrong with this query? Or is it a problem of all
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote:
... taxonomic_units1 AS O1
LEFT OUTER JOIN taxonomic_units1 AS O2
ON O1.tsn = O2.parent_tsn
current optimizer has only one option(*): use Nested-Loops Join algorthm, with
the outer table being the first one. That is, it
| |
++-+---+--+---+--+-+--++---+
6 rows in set (0.00 sec)
What is wrong with this query? Or is it a problem of all adjacency
list models?
Is there a way to get columns indexed using self-joins?
Thanks,
Olga
--
MySQL General Mailing List
For list
Hi.
I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server but
switched my database to another machine, on a Windows Server 2008. Problem
is, the connection to that other server (which is on the same network) is
very slow, taking 4-6 seconds every time. That is impossible to use
Damn I just said I wrote slot instead of slow...
Well I solved the problem, we added the client ip on the etc/hosts file on
the server. Now its pretty fast.
2009/10/8 Kim Delevati kim.delev...@gmail.com
Hi.
I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server
Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using
To: mysql@lists.mysql.com
Subject: mysql odbc connection problem
Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC
Hi
I just did a new installation of Suse 11.2 and found that I couldn't
connect to mysql from a php script because mysql.sock was
in /var/run/mysql/mysql.sock rather than /var/lib/mysql/mysql.sock. I
changed all the lines in /etc/my.cnf for the socket
to /var/lib/mysql/mysql.sock. Now my php
Hi Scott,
Change socket = path in the [client] section of your my.cnf as well.
Regards
Gavin Towey
-Original Message-
From: Scott Wagner [mailto:gildedp...@comcast.net]
Sent: Monday, October 05, 2009 3:21 PM
To: mysql@lists.mysql.com
Subject: mysql.socket location problem
Hi
I just did
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
Please note the error is about ambiguity. products has an ID field and so
does categories.
On Fri, Oct 2, 2009 at 10:53 AM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
Qualify the column names. EG
SELECT categories.ID, products.Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
Regards
John Daisley
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID =
Victor Subervi wrote:
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
Please note the error is about ambiguity. products has an ID field
Victor Subervi wrote:
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
Please note the error is about ambiguity. products has an ID field
Thanks
V
On Fri, Oct 2, 2009 at 11:08 AM, Mark Goodge m...@good-stuff.co.uk wrote:
Victor Subervi wrote:
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID'
Hello,
we have two tables associated with a foreign key constraint.
Table A with the primary key and table B with an on delete cascade constraint.
We want to delete datasets in Table B if the related dataset in Table A is
deleted - that works.
Now the Problem:
There is a weekly import defined
- that works.
Now the Problem:
There is a weekly import defined on table A using a load data infile
FILE replace into table A command.
The problem is the implicit delete/insert from the replace keyword.
Therefore the sets in Table B are deleted.
We are using replace because some datasets have
at it.
- Original Message
From: Kyong Kim kykim...@gmail.com
To: Lawrence Robertson lawrobert...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Monday, September 21, 2009 4:25:34 PM
Subject: Re: 100% CPU load problem
Is the status information correct?
mysql Ver 14.12 Distrib 5.0.27, for Win32
Hi.
We have some MySql servers in a circular replication, and one of the servers is
having some performance issues for some weeks. I tried with mysqlcheck and
nothing is wrong. I'm logging the slow queries and there's nothing wrong.
The complete database in this server is like 1GB when it's
Is the status information correct?
mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Are you using some sort of vm?
Kyong
On Mon, Sep 21, 2009 at 12:23 PM, Lawrence Robertson
lawrobert...@yahoo.com wrote:
Hi.
We have some MySql servers in a circular replication, and one of the servers
is
Is the status information correct?
mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Are you using some sort of vm?
I'm not using a VM at all. It's a simple PC with CentOS 4 and MySql.
Don't know why is that Ver 14.12 Distrib 5.0.27, for Win32 (ia32). But the
| version_compile_os
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X network between the two VMs up, but
when they try to
: Problem with MySQL user
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X network between the two VMs up
data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
how you can resolve the problem
* in the data directory 3. Store a copy of your my.ini with the
backup as well. 4. Restart mysql
Regards,
Gavin Towey
-Original Message-
From: Néstor [mailto:rot...@gmail.com]
Sent: Thursday, September 10, 2009 11:28 AM
To: mysql@lists.mysql.com
Subject: DB/table problem
I am running mysql
issue
or problem with xtrabackup? I'm not aware of any show-stopper bugs.
I'm just curious, because it works well for us. The backup is online
with the only lock held occuring while it's copying over the *.frm and
*.MY* files, which is not very much for us.
--
Regards... Todd
--
MySQL
mysql
Regards,
Gavin Towey
-Original Message-
From: Néstor [mailto:rot...@gmail.com]
Sent: Thursday, September 10, 2009 11:28 AM
To: mysql@lists.mysql.com
Subject: DB/table problem
I am running mysql 5.0 on a windows 2003 host with php and apache
I am trying to restore a database
Two tables:
USERS:
USER_ID (PK)
. . .etc
TWEETS:
TWEET_ID (PK)
USER_ID (FK)
Trying to get the user information and the number of tweets each person has:
SELECT USERS.USER_NAME, COUNT(TWEETS.TWEET_ID) AS 'TWEETCOUNT' FROM
TWEETS NATURAL JOIN USERS;
But it seems to be just rolling up all the
Methinx you need a GROUP BY in there. See below.
-Original Message-
From: John Meyer [mailto:john.l.me...@gmail.com]
Sent: Thursday, September 10, 2009 6:48 PM
To: mysql@lists.mysql.com
Subject: Natural join problem
Two tables:
USERS:
USER_ID (PK)
. . .etc
TWEETS
Thanks. That worked.
Jason Trebilcock wrote:
Methinx you need a GROUP BY in there. See below.
-Original Message-
From: John Meyer [mailto:john.l.me...@gmail.com]
Sent: Thursday, September 10, 2009 6:48 PM
To: mysql@lists.mysql.com
Subject: Natural join problem
Two tables:
USERS
@lists.mysql.com
Subject: Re: DB/table problem
OK, All I have then is a bunch of .frm files.
Can I recover the data from the FRM files if I install mysql 5.0 without
INNODB?
Thanks,
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey
gto...@ffn.commailto:gto...@ffn.com wrote:
When using innodb, your data
Towey
-Original Message-
From: tly...@sitehelp.org [mailto:tly...@sitehelp.org] On Behalf Of Todd Lyons
Sent: Thursday, September 10, 2009 3:44 PM
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: DB/table problem
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey gto...@ffn.com wrote:
When
Hi:
I have the following python code:
import os
os.system(mysqldump -u root -pPASSWORD --opt spreadsheets dump.sql)
This nicely creates the file...but the file is empty! The database exists
and has lots of data, I double-checked it. If there is nothing wrong with my
code, is there some way to do
On 9/2/2009 3:43 AM Victor Subervi said...
Hi:
I have the following python code:
import os
os.system(mysqldump -u root -pPASSWORD --opt spreadsheets dump.sql)
First, test this at the system command line -- you'll likely get an
empty file there as well, so calling from within python simply
-
From: news [mailto:n...@ger.gmane.org] On Behalf Of Emile van Sebille
Sent: Wednesday, September 02, 2009 7:18 AM
To: mysql@lists.mysql.com
Cc: python-l...@python.org
Subject: Re: Problem w/ mysqldump
On 9/2/2009 3:43 AM Victor Subervi said...
Hi:
I have the following python code:
import
-
From: news [mailto:n...@ger.gmane.org] On Behalf Of Emile van Sebille
Sent: Wednesday, September 02, 2009 7:18 AM
To: mysql@lists.mysql.com
Cc: python-l...@python.org
Subject: Re: Problem w/ mysqldump
On 9/2/2009 3:43 AM Victor Subervi said...
Hi:
I have the following python
301 - 400 of 8646 matches
Mail list logo