Re: integer

2008-05-22 Thread Norbert Tretkowski
Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati: I would to know the difference between the two int(10) and int (Used in create table ) MySQL has an excellent documentation, which of course also answers your question: http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

Re: changing 'max_allowed_packet'

2008-05-17 Thread Norbert Tretkowski
Am Freitag, den 16.05.2008, 14:55 -0700 schrieb Sigfrid: Hello, I have a simple question: how can I change the value of max_allowed_packet? http://dev.mysql.com/doc/refman/5.1/en/program-variables.html Norbert -- MySQL General Mailing List For list archives:

Re: innodb disabled

2008-05-07 Thread Norbert Tretkowski
Am Mittwoch, den 07.05.2008, 01:30 schrieb Krishna Chandra Prajapati: Currently error log file is empty. What else can be the reason for disable innodb. You mentioned that you're using Debian. The MySQL packages in Debian using syslog, check /var/log/syslog for errors. Norbert --

Re: changing ip addresses

2008-04-26 Thread Norbert Tretkowski
Am Freitag, den 25.04.2008, 12:25 -0500 schrieb James Sheffer: Hi all, I've got a problem. A client of ours changed ip addresses on their mysql server, and I believe MySL was set up to listen on the old ip address. How can I see what ip address mysql is set to listen on, and how can I

Re: Mysqldump

2008-04-15 Thread Norbert Tretkowski
Am Dienstag, den 15.04.2008, 15:11 -0400 schrieb minky arora: Could someone pls guide me as to the best way of adding excel files as tables to Mysql ? You can import CSV files into MySQL: http://dev.mysql.com/doc/refman/5.1/en/load-data.html Norbert -- MySQL General Mailing List For

Re: Multi Instances

2008-04-08 Thread Norbert Tretkowski
Am Dienstag, den 08.04.2008, 09:27 +0200 schrieb Stefano Elmopi: This command is available from the latest MySQL distribution. Please make sure you have the command in your PATH. Set the $PATH variable in the init script, and make sure it contains the path to the MySQL binaries.

Re: MySQL Master Slave Replication

2008-04-07 Thread Norbert Tretkowski
Am Montag, den 07.04.2008, 11:22 +0530 schrieb Kaushal Shriyan: is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication No, it's not. As the title says, it describes Master-Master replication, not Master-Slave replication. Just use

Re: Anybody can tell me the differences between show variables and show status?

2008-01-07 Thread Norbert Tretkowski
Am Dienstag, den 08.01.2008, 14:48 +0800 schrieb Moon's Father: I always confused to them. It's explained in the documentation: http://dev.mysql.com/doc/refman/5.0/en/show-status.html http://dev.mysql.com/doc/refman/5.0/en/show-variables.html Norbert -- MySQL General Mailing List

Re: Partitioning in mysql

2007-12-05 Thread Norbert Tretkowski
Am Mittwoch, den 05.12.2007, 17:59 +0530 schrieb Krishna Prajapati: Suggest me some link for partitioining. http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html http://dev.mysql.com/doc/refman/5.1/en/partitioning.html Norbert -- MySQL General Mailing List For list

Re: MySQL crash on Debian Etch system

2007-11-23 Thread Norbert Tretkowski
Am Donnerstag, den 22.11.2007, 09:31 -0800 schrieb Frank Niedermann: Nov 22 15:32:16 localhost mysqld[12720]: InnoDB: Last MySQL binlog file position 0 1991372, file name /var/log/mysql/mysql-bin.000580 Is there a way to find out why MySQL crashed? You have the binlog and the position where