Re: integer

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'

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: http://lists.mysql.com/

Re: innodb disabled

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 -- M

Re: changing ip addresses

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

Re: Mysqldump

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 Fo

Re: Multi Instances

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. Norbe

Re: MySQL Master Slave Replication

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?

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 Fo

Re: Partitioning in mysql

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 a

Re: MySQL crash on Debian Etch system

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 wher