ERROR 1030: Got error 127 from table handler?

2003-07-05 Thread Jonathan Chen
Hi everyone! I recently bought Mr. DuBois' MySQL book and got through the tutorials just fine. Since I wanted to venture into the wild without the help of the tutorials, I decided to make a project of my own. I have a guitar magazine collection with song transcriptions and all; I own around

where to find a code of libmySQL

2003-07-05 Thread Arkadiusz Balcerek
Hello, where can I get a source code of libmySQL library? I have installed MySQL but there are no source-code files. I would like to compile and link libmySQL on ma computer because I can't link a program using compiled libmySQL delivered with MySQL thanks for help Arkadiusz Balcerek

database table is read only

2003-07-05 Thread HA. Mooduto
dear all, i has a problem to installing phpbb using mysql database. An error has occured during installation (An error occured trying to update the database Table 'phpbb_config' is read only). what is the problem ? please help me... --

RE: database table is read only

2003-07-05 Thread electroteque
this is a phpbb specific question notice its a custom error message -Original Message- From: HA. Mooduto [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 8:13 PM To: [EMAIL PROTECTED] Subject: database table is read only dear all, i has a problem to installing phpbb using mysql

can add a record, but not update...

2003-07-05 Thread Michael Sorbera
Running 3.23.56, from phpmyadmin all works fine. I'm building an admin page, I can add a record, but when I try and update, I get this error: ERROR Number=8 Description=Error: quot;Undefined index: ad_numquot; on line 26 of /web/home/hovey/public_html/update.php./ Anyone have any ideas?

The difference between 1.9G and 2.2G table when create Index

2003-07-05 Thread James Yang
Hello MySQL, I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. But when I reduce the records to 16,000,000, about 1.9G, the same index can be finished within 35 minutes. Can anyone explain it? Thanks in advance. I

Re: The difference between 1.9G and 2.2G table when create Index

2003-07-05 Thread Fred van Engen
On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote: I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running? Was there still disk or CPU activity after 4 hours?

Re: The difference between 1.9G and 2.2G table when create Index

2003-07-05 Thread Fred van Engen
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote: On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote: I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running? Was

efficient table

2003-07-05 Thread awarsd
I tried to look everywhere @ mysql.com but i couldn't my question is how many records can a table handle so it stays fairly fast? What is the maximum records it can handle?? Thanx for any answers Anthony

New DBManager 2.1.1

2003-07-05 Thread Crercio O. Silva
The release 2.1.1 is a major bug fix and a few new features. If you are using an older Professional version, please consider updating it. Bellow, you can see the list of changes: NEW FEATURES -Added support to load/export binary data into/from a table (for blob fields). From now on BLOB fields

behavior of SELECT NOW ()

2003-07-05 Thread Rubens Jr.
Hi ! In a server with Conectiva Linux 6.0 (A Brazilian version) and Mysql 3.23.36 the comand SELECT NOW() returns 2003-07-05 10:00:00 both in the server and in the clients (Windows 98 with mysql-front and many programs writen in Delphi and MYODBC 2.50 or Zeos). In a new server with Conectiva 8

Getting started (again)

2003-07-05 Thread David Wilson
Hi. I'm a relative MySQL newbie. A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box. After some use, the system began to run very slowly, e.g, the login box, start menu, and other apps were taking a few seconds to respond to my mouse. Rebooting did not solve the problem. By trial

RE: Possible OT: ADONewConnection Error

2003-07-05 Thread marvc
I take it no one is familiar with particular error? Didn't get anything on google. -Original Message- From: marvc [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:00 PM To: [EMAIL PROTECTED] Subject: Possible OT: ADONewConnection Error Anyone here familiar with the following

Optimal Disk Configuration

2003-07-05 Thread Jim McAtee
What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? Thanks, Jim -- MySQL General Mailing List For list

Compiling 4.2.3 with MySQL ... what does it look for?

2003-07-05 Thread -{ Rene Brehmer }-
X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL 4.0.13. The Apache 2.0.40 and PHP 4.2.2 that came w. RH8 didn't work correctly,

Re: [PHP-DB] Compiling 4.2.3 with MySQL ... what does it look for?

2003-07-05 Thread olinux
try --with-mysql=/usr --- -{ Rene Brehmer }- [EMAIL PROTECTED] wrote: X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL

Re: Optimal Disk Configuration

2003-07-05 Thread Dathan Vance Pattishall
It depends on what your goal is and how many disks your system will contain. Personally I like a disk configuration with multiple spindels for performance. I also require redundancy, RAID-5 sounds good and is but I want the most out of writes, so I go with RAID-1+0. Hope this helps. On

Re: The difference between 1.9G and 2.2G table when create Index

2003-07-05 Thread James Yang
Thanks guys, Actaully my Hard disk is 10G, just for one table. There is enough table space. I noticed when I created index for 1.9G table, at the first phase, mysql copy table, but mysql doesn't write to the tmp index file, I means the filesize of the tmp index didn't increase. When I create

Re: Optimal Disk Configuration

2003-07-05 Thread colbey
My favourite for dedicated db servers (good amount of data, but a ton of access, queries/sec) is raid 0+1 ... fast access, but requires a good number of disks.. Be sure to use a good raid controller, multiple channels for the disks if possible.. On Sat, 5 Jul 2003, Jim McAtee wrote: What

Re: Optimal Disk Configuration

2003-07-05 Thread Jim McAtee
That's it? The entire system - OS, swap space and data in a single array? Nothing more involved? [EMAIL PROTECTED] wrote: My favourite for dedicated db servers (good amount of data, but a ton of access, queries/sec) is raid 0+1 ... fast access, but requires a good number of disks.. Be