Re: Mysqld fails to start

mysql 4096 2009-01-21 14:12 mysql/ srwxrwxrwx 1 mysql mysql0 2009-01-27 14:13 mysql.sock= -rw-r--r-- 1 mysql mysql 5242880 2009-01-27 14:13 ib_logfile0 drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 15:48 ./ Claudio Nanni

Re: How do you backup HUGE tables?

I would also suggest to use the innodb storage option 'innodb-file-per-table=ON' so that at least the datafile is split to have as many (smaller) datafiles as innodb tables. This could make it easier to deal with the whole database. Cheers Claudio Baron Schwartz wrote: On Fri, Jan 23, 2009

Re: timeout

If you do not connect probably you have a firewall in between, and it is not a timeout problem. You should ask your network administrators to open, if possible, that port for you. Another option is to ssh to the host and do a local connection to the MySQL instance. Cheers Claudio Nanni 2009/1

NDB Cluster Storage Engine 6.2 data types limit

Claudio Nanni

Re: Unused and empty tables - what impact on mysql

% of their uselessness. Cheers Claudio Nanni 2009/1/14 Brent Clark brentgclarkl...@gmail.com Hiya I just inherited a project, and before I get started, Id like to do a little clean up. There a * load of unused and empty tables in the db. My question is, does this in any way affect the performance

Re: default storage engine

is the default storage engine so it should not be specified. Cheers Claudio Nanni 2009/1/14 Walter Heck li...@olindata.com You can only copy files liek that for MyISAM tables. Are you sure you didn't accidentally convert to INNODB somewhere along the line? If so, go back to your old install

Setup a replication slave without stopping master

All, Happy New Year, and let's hope somebody tries to stop the killing in gaza. I need to setup a replication slave off a master that is currently production and not stoppable or lockable(possibly). Do you have any idea on how to setup the slave with minimum or no impact on the master? The

Re: Setup a replication slave without stopping master

First, Thank You all guys, I really appreciate your great answers. Second in my experience this is one of the most challenging and frequent things with mysql on production servers, once you have the slave practically you have online backups I will try to answer one by one. Jake Maul wrote:

Re: Searching for recent book available in Germany

Hi Michelle, I would definitely suggest DuBois' last book(28. September 2008): http://www.amazon.de/MySQL-Developers-Library/dp/0672329387/ref=sr_1_3?ie=UTF8s=books-intl-deqid=1230479926sr=8-3 It is well written, clear and complete, look no further. Aloha! Claudio Nanni 2008/12/28 Michelle

Re: On fighting with master-slave replication lag

I would suggest a Nagios monitoring system, useful for many different checks and with plugins to check also mysql replication. Aloha! Claudio Nanni 2008/12/23 xufeng xuf...@yuanjie.net Hello everyone, In my production system, I set up MySQL 5.0.67 master/slave replication, and recently I

Re: Problem with MySQL prompt

Ciao Stefano, how do you connect to the different instances? if you use different operating system users or different mysql home directories just put in the home directory of each user a .my.cnf file (or my.cnf in the mysql home) with just the prompt setting in the [mysql] section. NOTE: in the

Re: MYSQL startup problem

Hi, something weird is in the logs, the timestamps are messed up, can you post the full logfile as attachment? Claudio BAJAJ POOJA wrote: Hi, Pls find logs attached below in mail: 080605 15:28:08 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version:

Re: Updating from MySQL 4.0.12 to 5.0.67 Community

Hi Bai, I think the best option is to read carefully the installation guide, there are some post installation steps to set up initial privileges, and everything is explained quite well. After that if you still have problems please provide more informations on platform and other points like the

Re: Stopping using a server as a slave

stop slave; reset slave; Krishna Chandra Prajapati wrote: stop slave; reset slave; restart mysql server On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote: I have a server that I've been using as a MySQL Slave for a while now. I want to change it over to a regular server

Re: SELECT through many databases

| +--++ 4 row in set (0.01 sec) mysql Anyway you need a minimum a procedure programming to use this data and get your query out of this. Aloha Claudio Nanni Andre Matos wrote: Hello, Let's suppose I have 5 database: db1, db2, db3, db4, and db5. They all have the same

Re: Virtualizing MySQL

if I repeat myself, but for reliable test you should have the same architecture for both prod and preprod, Claudio Nanni Shain Miley wrote: Ok...based on the responses that I received so far...it seems like maybe I should be leaning toward a non virtualized solution. What I am wondering

Re: moving from 3.23.58 to 5.0.45

Hi Mark, from my experience I can tell you that you can easily migrate. A quick and dirty way is to use the two(or more) different MySQL installations on same server (or even different ones) and different ports of course. You dump the whole DB from the 3.23.58 and import it on the 5.0.45. If

Re: Cannot login into mysql server

Try using the '-h localhost' flag, shellmysqladmin -u root -h localhost -p Aloha Claudio SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: [EMAIL PROTECTED] To:

Re: making mysql work with c++

You can start by downloading the official C++ API. Get it from MySQL Developer Zone http://dev.mysql.com/downloads/other/plusplus/index.html Ciao! Andy B wrote: hi... i was interested in making mysql work with c++... how would i go about doing this? to be more exact i use borland builder 6

MySQL Administrator Installation problem on Solaris

? (Solaris?) thanks in advance, Claudio Nanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

<    1   2   3   4