Re: Alter table command don't work

2006-06-18 Thread David Logan
Graham Reeds wrote: Quentin Bennett wrote: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_na

Re: Alter table command don't work

2006-06-18 Thread Graham Reeds
Quentin Bennett wrote: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER

RE: Unknown tables

2006-06-18 Thread Quentin Bennett
"but I assume you mean to check the information_schema "database" and the schemata table?" No, Rich meant "check the mysql data directory for a karate directory." MySQL databases (for MyISAM tables) are stored in their own directory, and each table is a set of 3 files, so its easy to check f

RE: Re: Alter table command don't work

2006-06-18 Thread Quentin Bennett
http://dev.mysql.com/doc/refman/4.1/en/alter-table.html >From MySQL 4.1.2 on, if you want to change the table default character set and >all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a >statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

Re: Alter table command don't work

2006-06-18 Thread Graham Reeds
Graham Reeds wrote: Using the text mode mysql client program I tried to alter a table - but received a syntax error. Why? This is using MySQL 4.0.25 btw. mysql> alter table blog convert to character set utf8; ERROR 1064: You have an error in your SQL syntax. Check the manual that correspo

Alter table command don't work

2006-06-18 Thread Graham Reeds
Using the text mode mysql client program I tried to alter a table - but received a syntax error. Why? mysql> alter table blog convert to character set utf8; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to

Re: SHOW TABLES Problem

2006-06-18 Thread vitaliy . okulov
Здравствуйте, Ivan. Вы писали 14 июня 2006 г., 21:57:16: IR> Hi! IR> I use Visual FoxPro as a front end to a MySQL server, via MyODBC 3.51. IR> Since I have updated MySQL from 4.1.x to 5.0.18 (SuSE RPM), I get no IR> result from SHOW TABLES (used for up/downloading). Any ideas? IR> Ivan Russell

SHOW TABLES Problem

2006-06-18 Thread Ivan Russell
Hi! I use Visual FoxPro as a front end to a MySQL server, via MyODBC 3.51. Since I have updated MySQL from 4.1.x to 5.0.18 (SuSE RPM), I get no result from SHOW TABLES (used for up/downloading). Any ideas? Ivan Russell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: can't start daemon

2006-06-18 Thread Dan Trainor
Anthony Ettinger wrote: i actually don't have anything valuable in my database, it's on my home pc. I upgraded with the standard procedure. On 6/17/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Anthony Ettinger wrote: > I just upgraded to mysql 5, and can't restart the daemon. > > > 060617 11:57:2

Re: Unknown tables

2006-06-18 Thread Jesse
I'm not very experienced in this area, but I assume you mean to check the information_schema "database" and the schemata table? I checked there, and it is there. However, I've simply gone through the process of completely re-building my tables from scratch. I didn't receive any answers at all