45 minutes to check table to complete

2005-08-25 Thread Peter J. Schoenster
Hi, I've got a database that is closed to 7G. I'm using the Standard 4.1.14 version. The table was corrupt and I had to do a lot of moving of data to free up enough space on the partition as I discovered I needed at least twice the database size to do a recover. Well, using myisamchk -o work

Re: ISP

2001-03-26 Thread Peter J. Schoenster
On 26 Mar 2001, at 19:48, Daniel Mercury wrote: > Who knows any good ISP giving root access to Mysql? Best I know of is iserver.com. http://www.iserver.com/support/virtual/mysql/install.html Peter --- "Reality is that which, when you stop believing in it, doesn't go a

Re: ISP

2001-03-26 Thread Peter J. Schoenster
On 26 Mar 2001, at 17:54, Curtis Maurand wrote: > I would give you root access to your database, but not to Mysql as a > whole unless you want a dedicated server. Too dangerous. I have used iserver.com for about the last 4 years. I can start mysql,create databases etc. I find the entire

Re: MySQL Perl list

2001-04-06 Thread Peter J. Schoenster
On 6 Apr 2001, at 15:03, Kristopher Briscoe wrote: > Does anyone know of a good list(s) relating to PERL and MySQL? Also, > any good repositories of example code? As you are using the DBI you should be on the DBI list: http://lists.perl.org/showlist.cgi?name=dbi-users but you might be interes

does mysqlimport actually recreate the table schmea as well as import data?

2002-10-20 Thread Peter J. Schoenster
Hi, A cohort wrote a script to import tab delimited files. He uses mysqlimport. He uses the -d option to ONLY empty the data from the table before importing the new data. My cohort believes that mysqlimport is also dropping the table and then recreating the table from somewhere and then insert

Re: capturing mysql errors in Perl

2001-04-20 Thread Peter J. Schoenster
On 20 Apr 2001, at 14:16, yogi wrote: > errors mySQL throws are not captured by the Perl CGI using mySQL, but > are thrown regardless, meaning that a CGI that provokes an error in > mySQL will produce an unspecified "Internal Server Error", which is > not very helpful for debugging purposes. It l