Production problem porting from PHP to ASP

2003-12-09 Thread David Potter
Dear Members, For the last two years we have had a large software application written in PHP 4.0.6 with a MySQL 3.23.56 database all running on a single box with RedHat Linux 9.0. This has worked fantasticly and it is very fast. For certain business reasons that I wont go into detail here, we

Re: Re: Possible bug or corruption ? - MY ERROR PLEASE IGNORE

2002-03-01 Thread David Potter
I have realized my error. Please disregard and ignore. - Original Message -=20 From: David Potter=20 To: [EMAIL PROTECTED]=20 Sent: Friday, March 01, 2002 1:53 PM Subject: Possible bug or corruption ? Hello, I am trying to figure

EMERGENCY - Our production database is crashed

2001-10-23 Thread David Potter
Dear list members, We are running Mysql 3.23 on Redhat Linux 7.1. We have an emergency. This is the first time we have ever had a problem. Our production database suddenly crashed. I have tried to repair the tables with myisamchk commands, -r, -o, etc and nothing works. Here is the

Please help - primary key column's auto_increment feature is going wild

2001-09-05 Thread David Potter
Hello, I have a mysql database with a table called cust. The primary key column custid is of type int and has the auto_increment feature which has been working perfectly for months. The auto_increment feature set numbers as high as 21700.But suddenly, it started over, setting numbers like

How to move a MySQL database from Windows to Linux machine.

2001-05-08 Thread David Potter
Hello, I have a question on moving a MySQL database from a Windows Me machine to a Linux machine. Most of our tables have over 22 million rows. I suppose the slow but safe way is to dump the whole database on the Windows machine using mysqldump and then ftp the dump file over to the Linux