Re: Problem with ALTER - Bjarte Vasstrand - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: Problem with ALTER

From	Sent On	Attachments
Sean Fahey	04 Dec 1999 22:19
Sinisa Milivojevic	05 Dec 1999 05:31
Bjarte Vasstrand	05 Dec 1999 07:21

Subject:	Re: Problem with ALTER
From:	Bjarte Vasstrand (bvas...@online.no)
Date:	12/05/1999 07:21:30 AM
List:	com.mysql.lists.win32

At 23:19 04.12.99 -0700, you wrote:

Any insights? I'm relatively new to MYSQL

mysql> CREATE TABLE JOBS -> (CustomerID INT(11) -> ,OrderID INT(11), -> JobID TINYINT(4)); Query OK, 0 rows affected (0.11 sec)

mysql> ALTER TABLE JOBS ADD City VARCHAR(50); ERROR 7: Error on rename of './sas/jobs.frm' to './sas/B-3.frm' (Errcode:17)

In fact, no ALTER stmts have worked

it's a documented bug in the shareware version. You hav to run :

MysqlAdmin refresh

before altering, to close all threads. Also delete temp files (if any) before altering.

This works with me.

Bjarte

Here's some othe info:

mysql> \s

-------------- C:\mysql\bin\mysql.exe Ver 9.13 Distrib 3.21.29a-gamma, for Win95 (i586)

Connection id: 3 Current database: sas Server version 3.21.29a-gamma-debug Protocol version 10 Connection localhost via TCP/IP TCP port 3306 Uptime: 3 hours 12 min 58 sec

Running threads: 1 Questions: 75 Opened_tables: 24 Reloads: 1 Open tables: 3 Memory in use: 1070K Max memory used: 1246K

-------------- .