Hi.

On Mon, Nov 26, 2001 at 07:55:01PM +0100, [EMAIL PROTECTED] wrote:
> Dear Sir, Madam
> 
> I have a problem whit a tabel on a Mysql datbase V3.23 running on a Cobalt 
> Raq4I.
> 
> Some body whas create a tabel named kortbon ????. Now we have a SQL error on 
> line1. I cant drop the tabel from a telnet session or mysqlfront or phpadmin.

You have to to escape the name with backticks like `kortbon ????`.
This should work.

> Question: can i rename the files in /usr/local/mysql/var/abp/
> kortbon ?????.MYD  
> kortbon ?????.MYI
> kortbon ?????.frm
> 
>  to 
> 
> kortbon.MYD
> kortbon.MYI
> kortbon.frm
> 
> Whit out running in more troubel?

Yes, but you have to make sure, that the tables are neither accessed
nor opened by the mysqld meanwhile. Safest is to shut down the server,
change the names and restart it. 

Even better is to rename them using MySQL:

ALTER TABLE `kortbon ?????` RENAME kortbon;

Bye,

        Benjamin.

-- 
[EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to