Make sure your mysqld is running
On Fri, Apr 4, 2008 at 3:24 AM, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> Vidal Garza wrote:
>
> > [[...]]
> >
> > I have a cuestion, where do you find the system header files error
> > number (61)?
> >
>
> I do that brute-force:
>
> #! /bin/sh
> #
>
Kaushal,
I will try it tomorrow to see if it works. It is similar to something I
tried
a couple of weeks ago and it work but when I changed the ip address it stop
working.
I will try this tomorrow and let you know.
Néstor :-)
On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan <[EMAIL PROTECT
hi
is this a correct documentation
http://howtoforge.com/mysql_master_master_replication for Master Slave
Replication
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think this is the same as the other system.
On Mon, Mar 31, 2008 at 10:32 PM, Daniel Brown <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
> <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > Is there a documentation on replication of MySQL Database on Gentoo
>
> From
You should decrease your max_connections value
On Sat, Mar 29, 2008 at 11:15 AM, jfuentes <[EMAIL PROTECTED]> wrote:
> Hi
>
> Last days frequently I see an error message :
> "Can't create a new thread (errno 12) if you are not out of available
> memory, you can consult the manual for a possible
On Sun, Apr 6, 2008 at 9:57 PM, Eric Bergen <[EMAIL PROTECTED]> wrote:
> I don't see what the issue is. As Jay said the row counts in explain
> outputs are estimates. When running an explain query MySQL asks the
> storage engine how many rows it thinks are between a set of values for
> an index.
Nice reply.
On Fri, Apr 4, 2008 at 5:19 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Master-->Slave1/Master>Slave2 (Chain 1
> to 1)
> Slave1 should have --log_slave_updates
>
>
> Master->Slave1/Slave2/Slave3.
>
I don't see what the issue is. As Jay said the row counts in explain
outputs are estimates. When running an explain query MySQL asks the
storage engine how many rows it thinks are between a set of values for
an index. Different storage engines use different methods to calculate
row count. Both inno
You can read more at my blog, if you want .
On Tue, Apr 1, 2008 at 8:55 PM, Kaushal Shriyan <[EMAIL PROTECTED]>
wrote:
> Hi
>
> I am referring to
> http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to
> create multiple instances of MySQL Database Server. I wanted it for
> Gentoo L
Just waiting for any reply .
On Thu, Apr 3, 2008 at 11:01 PM, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Please actually read my reply before asking the same question. As I
> stated, InnoDB outputs *estimated* row counts in EXPLAIN, whereas MyISAM
> outputs *accurate* row counts.
>
> -jay
>
> Krishn
I was having some problems with MySQL after restoring a new MacBook
Pro from a Time Machine backup. I deleted
/Library/StartupItems/MYSQLCOM and the corresponding package in
/Library/Receipts, however I am unable to reinstall the Startup Item.
I've tried both 10.5 packages and the Intel 10.4 packa
Hi,
On Sun, Apr 6, 2008 at 12:54 AM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Sat, Apr 5, 2008 at 9:28 PM, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
> > select itemized.day_date as day_date,
> > round(sum(my_menu.carb * units) + simple.carb,2)
> > from itemized inner join simple using
Hi,
On Fri, Apr 4, 2008 at 1:46 PM, Ed W <[EMAIL PROTECTED]> wrote:
> It appears that since updating from mysql 5.0.44 to 5.0.54 I have also lost
> my DEFAULT "" option on all my varchar columns.
>
> For colums which are also NOT NULL this is causing a bunch of problems in
> my existing app (tryi
Hi,
On Sun, Mar 23, 2008 at 11:30 PM, <[EMAIL PROTECTED]> wrote:
> Hello mysql,
>
> Here is the short version of my story. I have a database that was not
> correctly defined at creation time and is currently set to utf8_general_ci
> but needs to be utf8_polish_ci. Some Polish characters are d
Hi,
I'll just address the things others didn't answer.
On Thu, Apr 3, 2008 at 2:28 PM, Dre <[EMAIL PROTECTED]> wrote:
> 1) Several sources seem to suggest MyISAM is a good choice for data
> warehousing, but due to my lack of experience in a transaction-less world,
One approach you might conside
Learnt more from here.
On Mon, Apr 7, 2008 at 9:22 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Wed, Apr 2, 2008 at 4:34 PM, Ben Roberts <[EMAIL PROTECTED]>
> wrote:
> >
> > Hello,
> >
> > Does anybody have any info on cross-database joins?
> >
> > i.e. doing a join across variou
You can use temporary table if you want short statement.
On Mon, Apr 7, 2008 at 9:24 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Thu, Apr 3, 2008 at 3:25 AM, nataliew
> <[EMAIL PROTECTED]> wrote:
> >
> > I need querylike this that make a row of numbers (in one execute)
> >
> > SE
Hi Ed,
On Thu, Apr 3, 2008 at 3:32 PM, Ed W <[EMAIL PROTECTED]> wrote:
> Hi
>
> Up until version 5.0.44 (on linux) it appeared that you could do stuff like
> deliberately insert a NULL into a NOT NULL varchar field and it would be
> silently converted to an empty string. Similarly if you didn't
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
<[EMAIL PROTECTED]> wrote:
>
> I need querylike this that make a row of numbers (in one execute)
>
> SELECT a from (
> SELECT -1 a UNION ALL
> SELECT -2 UNION ALL
> SELECT -3 UNION ALL
> SELECT -4 UNION ALL
> SELECT -5 UNION ALL
> SELECT -6 UNIO
Hi,
On Wed, Apr 2, 2008 at 4:34 PM, Ben Roberts <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> Does anybody have any info on cross-database joins?
>
> i.e. doing a join across various tables that are located inside different
> databases (albeit on the same database server).
>
> I'm interesested in
Hi,
On Wed, Apr 2, 2008 at 5:10 PM, Richard Jones <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a complex legacy application with around 30 tables which is in need
> of re-factoring, as there are tables with lots of nulls. I've partially
> managed to achieve this so that my queries mostly return co
Hi Robert,
On Tue, Apr 1, 2008 at 1:01 PM, Robert DiFalco <[EMAIL PROTECTED]> wrote:
> I've been told that an index always contains the primary key. So if I
A non-primary key index, in InnoDB, contains the primary key values at
the leaf nodes. However it does not contain them at the non-leaf
nod
Hi Reuven,
Michael is warning you against using SMB or NFS for your data
directory, in case you were thinking of doing so. I know you didn't
mention that but I think he was trying to be helpful just in case you
got the idea to use one of these technologies.
Baron
2008/4/1 Reuven Nisser <[EMAIL
Hi,
On Tue, Apr 1, 2008 at 5:39 PM, Michael Katz <[EMAIL PROTECTED]> wrote:
> In a replication environment with 1 master and a 2 slaves, does the
> entire database always have to be stored on the master? I understand
> that slaves can come on and off line but I am not sure if the master
> must
On Tue, Apr 1, 2008 at 3:34 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> According to the manual multi-table UPDATE and DELETE queries can use
> explicit join syntax, but I have had issues with that in the past, and only
> achieved success using implicit (comma) joins. YMMV.
Hmm. Are your issu
Hello Martijn
thanks so much for your reply
pls read this carefully
ok
for instance
i already know how use mysqldump,
so i can get A.sql , something like this
insert into person(id,name,age,sex ) VALUES (01, jesus, 33, male ),
insert into person(id,name,age,sex ) VALUES (02, michael, 17, male
26 matches
Mail list logo
