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 Norbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 I change it? It's configured with the bind-address option in the my.cnf configuration file. Norbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. Norbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the official HOWTO from MySQL for Master-Slave replication: http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html Norbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 where the server crashed, check the statements which have been run shortly before the crash. There is at least one known crash[0] in MySQL 5.0.32 which is shipped with Debian 4.0. Norbert [0]: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=447028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]