Re: Urgent problem
Hi! > "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes: Peter> Best group member, Peter> My computer stopped working. And I was able to install Windows on another Peter> partition and now I face one problem. I was running Windows with MySQL 4.1. Peter> I have all C: working, and can access all files. Peter> The first question: Can I recover that data from MySQL? Peter> The second question: How can I do that? (All attempts to repair Windows has Peter> failed, so that option is gone) Peter> I have gone thru the manual but all information there seems to be related to Peter> if the database crashes. And some options are there when you do make Peter> backups, but I do not have the backups. Peter> A "desperate" soul... In principle you can just copy the tables from one partition/computer to another and start using them. (The MySQL version doesn't have to exactly the same, as long as the new one is newer than the old one). To fix this: - Install MySQL on your new partition (computer) - Copy all files in the MySQL data directory (normally C:\mysql\data) to your new partition. If the path is different, you may have to create a my.cnf file that includes the --basedir and --datadir options to your new path. - Restart MySQL. - Check/repair your tables by using from the command line: C:\mysql\bin\mysqlcheck --all-databases --auto-repair Regards, Monty CTO of MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent problem
restart mysql with the skip-grants option -Original Message- From: Rainer M. Krug [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:03 AM To: [EMAIL PROTECTED] Subject: Urgent problem Hi I did something very stupid: I locked myself out of the MySQL server (all accounts, incl administrator)... My problem: I use MySQLFront to change the allowed hosts and did it for all users. They were 'localhost' and I set them to 'localhost; EcolMod1' where the EcolMod1 is the name of my computer where the MySQL server is installed on. After these changes, I couldn't log on any more. Windows 2000, MySQL 4.012. Any help welcome what I could do to access the data again, Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent problem
> I did something very stupid: I locked myself out of the > MySQL server (all accounts, incl administrator)... > > My problem: I use MySQLFront to change the allowed > hosts and did it for all users. They were 'localhost' > and I set them to 'localhost; EcolMod1' where the > EcolMod1 is the name of my computer where the MySQL > server is installed on. After these changes, I > couldn't log on any more. > > Windows 2000, MySQL 4.012. > > Any help welcome what I could do to access the data > again, One mail should be enough in most cases! You may try to edit your host.mid file in \mysql-dir\data\mysql. Make a backup of that file before you start and use a hex-editor for doing so. The first chars in there should look like "ÿlocalhost; EcolMod1". Simply overwrite (not erase) what you don't need with spaces (20 hex). You need to restart mysql to apply changes made. Regards, TomH -- PROSOFT EDV-Lösungen GmbH & Co. KG Ladehofstraße 28, D-93049 Regensburg Geschäftsführer: Axel-Wilhelm Wegmann AG Regensburg HRA 6608 USt.183/68311 www : http://www.proSoft-Edv.de email: [EMAIL PROTECTED] phone: +49 941 / 78 88 7 - 121 fax : +49 941 / 78 88 7 - 20 cellphone: +49 174 / 41 94 97 0 -- > -Original Message- > From: Rainer M. Krug [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 13, 2003 10:03 AM > To: [EMAIL PROTECTED] > Subject: Urgent problem > > > Hi > > > Rainer > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=mysql-list@> 7thweb.de > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Quoting Nils Valentin <[EMAIL PROTECTED]>: > When you said you modified the scripts, are these the scripts on the 12 > webservers (mysql clients) ? Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12 webservers > If not, then these mysql clients (webservers) would still be wanting to send > > to IP addres 192.168.1.71 as configured for php or in your client. > > Best regards > > Nils Valentin > Tokyo/Japan > > > 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました: > > Neither of these two machines send the request. > > > > I have 12 webservers, which send the requests. > > I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 > > slaves(for selects). > > > > Machine A below was the current Master DB server, however it is old and > was > > being replaced by machine B > > > > > > -- > > Keith Bussey > > > > Wisol, Inc. > > Chief Technology Manager > > (514) 398-9994 ext.225 > > > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > > Hi Keith, > > > > > > soory now I got confused. Which machine is sending the requests (client) > > > and > > > > > > which machine is the mysql server (server). Do you use php or something > > > like > > > > > > this (webinterface) on the client ? > > > > > > If yes, than my suggestions below apply. > > > If no than I we will have to think the next step. > > > > > > Best regards > > > > > > Nils Valentin > > > Tokyo/Japan > > > > > > 2003å¹´ 6æ 27æ¥ éææ¥ 11:29ãKeith Bussey > ããã¯æ¸ãã¾ãã: > > > > Ok but that's not what I meant. > > > > > > > > I'll try to explain better. > > > > > > > > Machine A: IP = 192.168.1.71 > > > > Machine B: IP = 192.168.1.79 > > > > > > > > 1) Scripts goto 192.168.1.71 - Everything is OK > > > > 2) Changed scripts to 192.168.1.79 - Site works at first, but > processes > > > > pile up until server is killed > > > > 3) Halt machine B > > > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) > > > > 5) Problem persists even though it's a different machine, site works > > > > but then processes pile up and kill machine > > > > 6) Change scripts to use 192.168.1.71 again > > > > 7) Site works fine > > > > > > > > > > > > What I don't get is why do processes run normally with IP > 192.168.1.71, > > > > > > but > > > > > > > NOT with IP 192.168.1.79 even when they are on the same machine ? > > > > > > > > -- > > > > Keith Bussey > > > > > > > > Wisol, Inc. > > > > Chief Technology Manager > > > > (514) 398-9994 ext.225 > > > > > > > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > > > > Hi Keith, > > > > > > > > > > The wrong IP address could only avoid a client to connect to the > > > > > > database > > > > > > > > server. > > > > > > > > > > If you have the TCP/IP address specified in /etc/php.ini or for > > > > > phpmyadmin in > > > > > > > > > > config.inc.php or which ever tool you use than of course it will try > > > > > to connect to this IP address. > > > > > > > > > > Best regards > > > > > > > > > > Nils Valentin > > > > > Tokto/Japan > > > > > > > > > > 2003å¹´ 6æ 27æÂÂ¥ > éÂÂæÂÂæÂÂ¥ 11:02ãÂÂKeith > > > > > Bussey > > > > > > > ãÂÂãÂÂã¯æ¸ãÂÂã¾ãÂÂãÂÂ: > > > > > > Hrmmmeaning if I do "id mysql", that information (group etc..) > > > > > > ? > > > > > > > > > > > > I've halted that server and moved everything back to my original > > > > > > server > > > > > > > > for > > > > > > > > > > > now, I had too much downtime. I did notice something else > > > > > > interesting though: > > > > > > > > > > > > The old mahcine's IP is 192.168.1.71 > > > > > > New machine's IP is 192.168.1.79 > > > > > > > > > > > > Now that it's halted, instead of changing the IP back to .71 in my > > > > > > pages/scripts I added .79 to the .71 machine so it has both > > > > > > > > > > > > Now that machine experienced the exact same problem. Switching my > > > > > > code to use .71 again however, and no problems. > > > > > > > > > > > > Could somehow there be a problem with the IP address > 192.168.1.79?? > > > > > > It seems very strange, however tomorrow I will try putting the .71 > > > > > > on the new machine and see if it works or not > > > > > > > > > > -- > > > > > --- > > > > > Valentin Nils > > > > > Internet Technology > > > > > > > > > > E-Mail: [EMAIL PROTECTED] > > > > > URL: http://www.knowd.co.jp > > > > > Personal URL: http://www.knowd.co.jp/staff/nils > > > > > > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > > --- > > > Valentin Nils > > > Internet Technology > > > > > > E-Mail: [EMAIL PROTECTED] > > > URL: http://www.knowd.co.jp > > > Personal URL: http://www.knowd.co.jp/staff/nils > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL
Re: URGENT problem with mysql processes
No, replication is fine I can see those processes as they should be. The problem processes all come from the webservers' requests. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Dominicus Donny <[EMAIL PROTECTED]>: > If it is the replication problem...:: > Check the replication account on the master server: > ...[EMAIL PROTECTED] identified by ... > ...[EMAIL PROTECTED] identified by ... > ...[EMAIL PROTECTED] identified by ... > ... > ...[EMAIL PROTECTED] identified by ... > > or perhaps simply set to > ...replication_account@"%" identified by ... > > make sure the account has access to the specified db.tables, too. > > "Me fail English? That's unpossible" > ###___Archon___### > > - Original Message - > From: "Nils Valentin" <[EMAIL PROTECTED]> > To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 27, 2003 1:30 PM > Subject: Re: URGENT problem with mysql processes > > > Hi Keith, > > from your last e-mail I understand now finally that we are talking about > replication here. Would have been a short cut to mention it in your first > e-mail. > > The failed login attempts couldn't be from your slaves trying to login, but > you havent set them up on the master yet ? > > Just a guess, so. > > 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | > > | login NULL > > | > > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | > > | login NULL > > | > > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | > > | login NULL > > | > > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | > > | login NULL > > Best regards > > Nils Valentin > Tokyo/Japan > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
No, the slaves replicate fine and I can see their entries in the processlist normally (as their hostname), not as "unauthenticated user".. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > from your last e-mail I understand now finally that we are talking about > replication here. Would have been a short cut to mention it in your first > e-mail. > > The failed login attempts couldn't be from your slaves trying to login, but > you havent set them up on the master yet ? > > Just a guess, so. > > 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | > > | login NULL > > | > > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | > > | login NULL > > | > > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | > > | login NULL > > | > > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | > > | login NULL > > Best regards > > Nils Valentin > Tokyo/Japan > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
If it is the replication problem...:: Check the replication account on the master server: ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ...[EMAIL PROTECTED] identified by ... ... ...[EMAIL PROTECTED] identified by ... or perhaps simply set to ...replication_account@"%" identified by ... make sure the account has access to the specified db.tables, too. "Me fail English? That's unpossible" ###___Archon___### - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 1:30 PM Subject: Re: URGENT problem with mysql processes Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | > | login NULL > | > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | > | login NULL > | > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | > | login NULL > | > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | > | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a guess, so. 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | > | login NULL > | > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | > | login NULL > | > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | > | login NULL > | > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | > | login NULL Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
When you said you modified the scripts, are these the scripts on the 12 webservers (mysql clients) ? If not, then these mysql clients (webservers) would still be wanting to send to IP addres 192.168.1.71 as configured for php or in your client. Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました: > Neither of these two machines send the request. > > I have 12 webservers, which send the requests. > I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 > slaves(for selects). > > Machine A below was the current Master DB server, however it is old and was > being replaced by machine B > > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > Hi Keith, > > > > soory now I got confused. Which machine is sending the requests (client) > > and > > > > which machine is the mysql server (server). Do you use php or something > > like > > > > this (webinterface) on the client ? > > > > If yes, than my suggestions below apply. > > If no than I we will have to think the next step. > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > > 2003å¹´ 6月 27æ—¥ 金曜日 11:29ã€Keith Bussey ã•ã‚“ã¯æ›¸ãã¾ã—ãŸ: > > > Ok but that's not what I meant. > > > > > > I'll try to explain better. > > > > > > Machine A: IP = 192.168.1.71 > > > Machine B: IP = 192.168.1.79 > > > > > > 1) Scripts goto 192.168.1.71 - Everything is OK > > > 2) Changed scripts to 192.168.1.79 - Site works at first, but processes > > > pile up until server is killed > > > 3) Halt machine B > > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) > > > 5) Problem persists even though it's a different machine, site works > > > but then processes pile up and kill machine > > > 6) Change scripts to use 192.168.1.71 again > > > 7) Site works fine > > > > > > > > > What I don't get is why do processes run normally with IP 192.168.1.71, > > > > but > > > > > NOT with IP 192.168.1.79 even when they are on the same machine ? > > > > > > -- > > > Keith Bussey > > > > > > Wisol, Inc. > > > Chief Technology Manager > > > (514) 398-9994 ext.225 > > > > > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > > > Hi Keith, > > > > > > > > The wrong IP address could only avoid a client to connect to the > > > > database > > > > > > server. > > > > > > > > If you have the TCP/IP address specified in /etc/php.ini or for > > > > phpmyadmin in > > > > > > > > config.inc.php or which ever tool you use than of course it will try > > > > to connect to this IP address. > > > > > > > > Best regards > > > > > > > > Nils Valentin > > > > Tokto/Japan > > > > > > > > 2003å¹´ 6月 27日 > > > > 金曜日 11:02ã€ÂKeith > > > > Bussey > > > > ã•んã¯書ãÂÂã¾ã—ãŸ: > > > > > Hrmmmeaning if I do "id mysql", that information (group etc..) > > > > > ? > > > > > > > > > > I've halted that server and moved everything back to my original > > > > server > > > > > > for > > > > > > > > > now, I had too much downtime. I did notice something else > > > > > interesting though: > > > > > > > > > > The old mahcine's IP is 192.168.1.71 > > > > > New machine's IP is 192.168.1.79 > > > > > > > > > > Now that it's halted, instead of changing the IP back to .71 in my > > > > > pages/scripts I added .79 to the .71 machine so it has both > > > > > > > > > > Now that machine experienced the exact same problem. Switching my > > > > > code to use .71 again however, and no problems. > > > > > > > > > > Could somehow there be a problem with the IP address 192.168.1.79?? > > > > > It seems very strange, however tomorrow I will try putting the .71 > > > > > on the new machine and see if it works or not > > > > > > > > -- > > > > --- > > > > Valentin Nils > > > > Internet Technology > > > > > > > > E-Mail: [EMAIL PROTECTED] > > > > URL: http://www.knowd.co.jp > > > > Personal URL: http://www.knowd.co.jp/staff/nils > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > > --- > > Valentin Nils > > Internet Technology > > > > E-Mail: [EMAIL PROTECTED] > > URL: http://www.knowd.co.jp > > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Neither of these two machines send the request. I have 12 webservers, which send the requests. I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 slaves(for selects). Machine A below was the current Master DB server, however it is old and was being replaced by machine B -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > soory now I got confused. Which machine is sending the requests (client) and > > which machine is the mysql server (server). Do you use php or something like > > this (webinterface) on the client ? > > If yes, than my suggestions below apply. > If no than I we will have to think the next step. > > Best regards > > Nils Valentin > Tokyo/Japan > > > > 2003年 6月 27日 金曜日 11:29、Keith Bussey さんは書きました: > > Ok but that's not what I meant. > > > > I'll try to explain better. > > > > Machine A: IP = 192.168.1.71 > > Machine B: IP = 192.168.1.79 > > > > 1) Scripts goto 192.168.1.71 - Everything is OK > > 2) Changed scripts to 192.168.1.79 - Site works at first, but processes > > pile up until server is killed > > 3) Halt machine B > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) > > 5) Problem persists even though it's a different machine, site works but > > then processes pile up and kill machine > > 6) Change scripts to use 192.168.1.71 again > > 7) Site works fine > > > > > > What I don't get is why do processes run normally with IP 192.168.1.71, > but > > NOT with IP 192.168.1.79 even when they are on the same machine ? > > > > -- > > Keith Bussey > > > > Wisol, Inc. > > Chief Technology Manager > > (514) 398-9994 ext.225 > > > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > > Hi Keith, > > > > > > The wrong IP address could only avoid a client to connect to the > database > > > server. > > > > > > If you have the TCP/IP address specified in /etc/php.ini or for > > > phpmyadmin in > > > > > > config.inc.php or which ever tool you use than of course it will try to > > > connect to this IP address. > > > > > > Best regards > > > > > > Nils Valentin > > > Tokto/Japan > > > > > > 2003å¹´ 6æ 27æ¥ éææ¥ 11:02ãKeith Bussey > ããã¯æ¸ãã¾ãã: > > > > Hrmmmeaning if I do "id mysql", that information (group etc..) ? > > > > > > > > I've halted that server and moved everything back to my original > server > > > > > > for > > > > > > > now, I had too much downtime. I did notice something else interesting > > > > though: > > > > > > > > The old mahcine's IP is 192.168.1.71 > > > > New machine's IP is 192.168.1.79 > > > > > > > > Now that it's halted, instead of changing the IP back to .71 in my > > > > pages/scripts I added .79 to the .71 machine so it has both > > > > > > > > Now that machine experienced the exact same problem. Switching my code > > > > to use .71 again however, and no problems. > > > > > > > > Could somehow there be a problem with the IP address 192.168.1.79?? It > > > > seems very strange, however tomorrow I will try putting the .71 on the > > > > new machine and see if it works or not > > > > > > -- > > > --- > > > Valentin Nils > > > Internet Technology > > > > > > E-Mail: [EMAIL PROTECTED] > > > URL: http://www.knowd.co.jp > > > Personal URL: http://www.knowd.co.jp/staff/nils > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Ok but that's not what I meant. I'll try to explain better. Machine A: IP = 192.168.1.71 Machine B: IP = 192.168.1.79 1) Scripts goto 192.168.1.71 - Everything is OK 2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up until server is killed 3) Halt machine B 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) 5) Problem persists even though it's a different machine, site works but then processes pile up and kill machine 6) Change scripts to use 192.168.1.71 again 7) Site works fine What I don't get is why do processes run normally with IP 192.168.1.71, but NOT with IP 192.168.1.79 even when they are on the same machine ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > The wrong IP address could only avoid a client to connect to the database > server. > > If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in > > config.inc.php or which ever tool you use than of course it will try to > connect to this IP address. > > Best regards > > Nils Valentin > Tokto/Japan > > > 2003年 6月 27日 金曜日 11:02、Keith Bussey さんは書きました: > > Hrmmmeaning if I do "id mysql", that information (group etc..) ? > > > > I've halted that server and moved everything back to my original server > for > > now, I had too much downtime. I did notice something else interesting > > though: > > > > The old mahcine's IP is 192.168.1.71 > > New machine's IP is 192.168.1.79 > > > > Now that it's halted, instead of changing the IP back to .71 in my > > pages/scripts I added .79 to the .71 machine so it has both > > > > Now that machine experienced the exact same problem. Switching my code to > > use .71 again however, and no problems. > > > > Could somehow there be a problem with the IP address 192.168.1.79?? It > > seems very strange, however tomorrow I will try putting the .71 on the new > > machine and see if it works or not > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Hi Keith, The wrong IP address could only avoid a client to connect to the database server. If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in config.inc.php or which ever tool you use than of course it will try to connect to this IP address. Best regards Nils Valentin Tokto/Japan 2003年 6月 27日 金曜日 11:02、Keith Bussey さんは書きました: > Hrmmmeaning if I do "id mysql", that information (group etc..) ? > > I've halted that server and moved everything back to my original server for > now, I had too much downtime. I did notice something else interesting > though: > > The old mahcine's IP is 192.168.1.71 > New machine's IP is 192.168.1.79 > > Now that it's halted, instead of changing the IP back to .71 in my > pages/scripts I added .79 to the .71 machine so it has both > > Now that machine experienced the exact same problem. Switching my code to > use .71 again however, and no problems. > > Could somehow there be a problem with the IP address 192.168.1.79?? It > seems very strange, however tomorrow I will try putting the .71 on the new > machine and see if it works or not -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: URGENT problem with mysql processes
Hi Keith, 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > Major problem! > > I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is > > - quad-xeon (500mhz each cpu) > - 3 gig RAM > - Linux Redhat 7.3 > > When I start up mysql, processes looking like the following begin to pile > up > > until it kills the server: > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | > | login NULL I might be completely wrong but my guess would be that the mysql user account is not set up correctly. > | > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | > | login NULL > | > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | > | login NULL > | > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | > | login NULL > > I need to fix this immediately as my site cannot run ! > > Thanks in advance. I've seen this exact same situation happen to others > (posted on various boards), however never saw any solutions ;/ > > > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: urgent problem with mysql and phpmyadmin
My guess. . . I have seen this problem with other databases . . . don't know if it is true for MySQL as well. Try to change to your field definition to float(5,2) as it may be counting the (.) as part of your field size. So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into the price column using the phpmyadmin form, if for example i try to enter the price 34.99 it will only allow me to enter 34.9, and then when i go to the browse feature it shows the value as 34.90 any ideas on what's going wrong??? any help would be much apprecited. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent : Problem in Group by clause
Hi Shankar, This is your old buddy Scott S. Try order by rather than group byThis will get you what you are looking for Scott Salisbury - Original Message - From: "SankaraNarayanan Mahadevan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 16, 2002 3:42 PM Subject: urgent : Problem in Group by clause hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i need to use group by in select statement.. i want to display the details in the web page ... say there are 3 records as below against each field: 1. 'a.jpg','test','david','john','2002-02-14' 2. 'b.bmp','bmp file','richard','mary','2002-02-14' 3. 'c.htm','web','david','mary','2002-02-15' now i want to display the details grouped by Designer (the third field). when i use the following query: select FileName,Title,Designer,UploadedBy,SubmittedDate >From UploadDetails Group By Designer i get only one row... why? can anyone solve this problem... thanks in advance Shankar __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent problem : recovering a table with no MYI file ?
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote: > Hi, > > I'm administrating a machine which has just badly crashed, and a MYI > file has disappeared for one table. Is this possible to repair this > table? Try to touch the file (to create an empty one), and see if that is sufficient to get MySQL doing what it should. Don't know if it will help, but you never know. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW MySQL 3.23.29: up 28 days, processed 213,616,674 queries (88/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
