Find out what version I am using?

Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Unicode

Howdy All! How do I activate unicode support for my tables? I searched the mysql manual and found a section that says MySQL software now offers extensive Unicode (UTF8) support but I could not find a section that went through how to do it. Secondly, if I turn on unicode support for a tables,

Moving to version 4.1

Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my add or remove programs utility, I see MySQL ODBC 3.51 Driver and MySQL Servers and Clients 3.23.55. If I use Windows add or remove programs utility to remove MySQL

Removing old service in Windows XP

Howdy All! When I tried to install the new MySql, I got the result below: C:\mysql\binmysqld --install The service already exists! The current server installed: C:\mySql\bin\mysqld-nt C:\mysql\bin My problem is this: I used the add remove programs utility to remove the old MySql server, but in

RE: Removing old service in Windows XP

Howdy All! When I tried to install the new MySql, I got the result below: C:\mysql\binmysqld --install The service already exists! The current server installed: C:\mySql\bin\mysqld-nt C:\mysql\bin My problem is this: I used the add remove programs utility to remove the old MySql server,

Re: Passwords don't work in a WinME installation?

Howdy All! I encountered a 1045 error myself and in searching Google found this thread from March 2003. I am not sure if it was solved, so, for the record, here is what I did to solve it. I tried logging into mysql as default with just this command: mysql --local-infile -h localhost I then

View Warnings

Howdy all! mysqlLOAD DATA LOCAL -INFILE /Rob/architecturalScreens/prototype/v1/database/insertPart.dat -INTO TABLE part; Query OK, 496 rows affected (0.08 sec) Records: 496 Deleted: 0 Skipped: 0 Warnings: 1494 I am glad it loaded my file (it took me ages to build it)...

RE: MySQL on windows

Hi Simon, The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ What about Java + JDBC? Rob :) - Before posting, please check:

mysqld-max but still no referential integrity?

Howdy all! I thought InnoDB tables enforced referential integrity? I believe I have set up MySql to use InnoDB tables and I have created tables of type InnoDB, yet I can still enter an illegal row! Can anyone tell me what I am doing wrong? The final insert into PET below should not work! Rob

RE: mysqld-max but still no referential integrity?

Hi Oliver, I tried as you suggested, but I have a different problem now.. == my.ini My my.ini file: [mysqld] basedir=C:/mySql/ datadir=C:/mySql/data [WinMySQLAdmin] Server=C:/mySql/bin/mysqld-MAX-nt.exe innodb_data_home_dir = C:\mySql\ibdata

Closing mysqld-max - was RE: mysqld-max but still no referential integrity?

I think I solved this.. I deleted C:\mySql\ibdata and I could start it up again.. I think I know why it happened too.. when I start a connection with this: mysqld-max-nt.exe --console --standalone it takes the console over.. How do I properly close it down from another console? Rob :)

RE: mysqld-max but still no referential integrity?

Howdy all! I have changed my my.ini but my problem remains... details below. Any further assistance would be greatly appreciated! I apolagise to all if it seems I am flooding.. :( Rob :) :- :-} == my.ini [mysqld] basedir=C:/mySql/ datadir=C:/mySql/data [WinMySQLAdmin]

RE: mysqld-max but still no referential integrity?

\ibdata Rob :) -Original Message- From: Robert Mark Bram [mailto:[EMAIL PROTECTED] Sent: Sunday, 23 February 2003 1:03 AM To: Mysql Subject: RE: mysqld-max but still no referential integrity? Howdy all! I have changed my my.ini but my problem remains... details below. Any further

Different User, Different datadir

Howdy all! I would like to create a user that will only access my current project's database. I would also like to store the data for my current project's database in a particular location. Can I use my.ini to do this? For example, - user = newProject - pwd = newProject -

mysqld-max-nt.exe as a service

Howdy all! How do I open mysqld-max-nt.exe as a service (so I don't have to see a DOS console open for it all the time). Here is the command I use to open it currently: mysqld-max-nt.exe --console --standalone Any help would be appreciated! Rob :) :- :-}