Re: latin1/utf-8 problem

--- On Saturday 27 November 2004 12:52, Gleb Paharenko wrote: | Hello. | | Strange behavior. You said that both servers configured to use latin1? | What output produced Can only do with for the local server, access is denied to the mysql shell on the shared hosting. But it's the l

Re: latin1/utf-8 problem

--- On Saturday 27 November 2004 12:38, Steve Mansfield wrote: Seem to be answering my own questions here...:-) Looks like it's a MySQLcc problem. Dumped tables from the live server and then, rather than running them as a sql query via MySQLcc, I did it from the command

Re: latin1/utf-8 problem

--- On Saturday 27 November 2004 12:16, Steve Mansfield wrote: | --- | | On Friday 26 November 2004 17:58, Gleb Paharenko wrote: | | Hello. | | | | What charset produced mysqldump with --default-character-set=latin1 | | command line option? | | Hmm, that still

Re: latin1/utf-8 problem

--- On Friday 26 November 2004 17:58, Gleb Paharenko wrote: | Hello. | | What charset produced mysqldump with --default-character-set=latin1 command | line option? Hmm, that still produced a file with utf-8 characters, which means they must be stored that way in the table, no? (Al

latin1/utf-8 problem

I have a strange, irritating problem that I think is to do with MySQL. I have a table on a live (shared hosting) system that, when I use it on my local system, seems to wind up in utf-8 rather than latin1. Here's the set-up: Live system - MySQL 3.2.3.56, PHP 4.1.2, Apache 1.3.27. MySQL is config

Re: Can't find host.MYD

--- On Sunday 09 May 2004 05:29, you wrote: | > 040508 11:10:24 mysqld started | > 040508 11:10:24 /usr/sbin/mysqld: Can't find file: 'host.MYD' (errno: 2) | > 040508 11:10:24 mysqld ended | Check to see if mysqld is correctly reading your my.cnf, and that no other | --datadir

Can't find host.MYD

I know this is a thorny old problem, but I'm having trouble resolving it. Here's the set-up. I'm running Linux. The MySQL data directory (as configured in my.cnf) is /share/mysql/data/ because I was sharing the data between Linux and Windows on a dual-boot system. This set-up has been working fi

RE: Dual boot system

>>I don't see why it should be a problem. Data files are binary compatible between >>OS's, and by definition, one instance of mysqld will be shut down while the other >>operates on the data. >>Of course "copying" rather than "moving" is always a good recommendation until >>you're sure that everyth

Dual boot system

I have MySQL installed on a WinXP box, on drive C. Recently, I've installed Linux on the same machine - dual boot, as one does. Linux is sitting on a second HD on which I created a windows partition, seen to Linux as /share and to Windows as D:, in order to share data between the two systems. It i

RE: Linux install problem

>>I'll bet you didn't run mysql_install_db with the --user=mysql option. chown -R mysql.mysql /var/lib/mysql should do the trick. That's right, because I didn't see anything to that effect in the manual, although the manual is a little confusing at this point. Following another post (not in respon

Linux install problem

Having run MySQL successfully for a while in a WAMP environment, I'm trying to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1 version that came as an RPM with SuSE 8.2. The problem is - it doesn't work. Here's where the various elements have installed to: /usr/bin vario

delete using a join

I'm using Mysql 3.23.51 on redhat. does anyone know if there is a way of deleting records using a join. I read somewhere that this is only supported as of version 4.x Regards, Steve Mansfield [EMAIL PROTECTED] http://www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford

select query to give sum and distinct values

t_dur 08451340120179.9 0845134020615607.9 08451340214631.6 Anyone have any ideas as i just cannot get the query correct. Steve Mansfield [EMAIL PROTECTED] http://www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] 0870 757

adding values together

m for price for id 2. Regards, Steve Mansfield Head of Development [EMAIL PROTECTED] http://www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] 0870 757 7900 [Fax] 0870 757 8900 http://www.be-an-isp.comhttp://www.isdn4fre

More compile errors

No curses/termcap library found Any ideas any1?!?!?!?!?!?!?!?Q?Q?>Q?? Regards Steve Mansfield Technical Manager [EMAIL PROTECTED] www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] +44 [0] 1708 704433 [Fax] +44 [0] 1708 748859 [Mobile] +44 [0