RE: Problem with BLOB Field

2002-08-13 Thread Dave Watkinson
There was a reply posted last week --- James Frankman [EMAIL PROTECTED] wrote: Blob limit is 64K use MEDIUMBLOB for your column and I got this from http://www.mysql.com/doc/en/Storage_requirements.html TINYBLOB, TINYTEXT L+1 bytes, where L 2^8 BLOB, TEXT L+2 bytes, where L 2^16

RE: How to Load a Database to other Server

2002-05-16 Thread Dave Watkinson
not sure about the Linux guys, but if you're using Windows just copy the directory for your database (in the mysql\data directory) to the new server. Restart MySQL Server on new machine Cheers Dave -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 10:05 To:

RE: ERROR 1030: Got error 127 from table handler / Optimize Table

2002-05-16 Thread Dave Watkinson
restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running HTH Dave -Original Message- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: