RE: when rebuilding keys?

2007-04-12 Thread Addison, Mark
From: wangxu Sent: Thu 12/04/2007 08:38 - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:17 PM Subject: Re: when rebuilding keys? yes. before load data. You want to rebuild the

RE: Converting TEXT to BLOB with special chars

2006-07-18 Thread Addison, Mark
From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having a problem, and am hoping this is the wright list to post to. I have a TEXT field with text in them (duh!)... this text also contains special characters like é ß ü etc... But when i convert the TEXT field to a BLOB

RE: Backup problem from 5.0 to mysql 4.1

2006-07-18 Thread Addison, Mark
From: Amir Bukhari Sent: 18 July 2006 09:23 I have local mysql 5.0 and I have developed an arabic site. The database encoding is utf8-bin. Localy everything work fine, all arabic text are displayed OK. Now I want to move it to a server in internet. The server has mysql 4.1 and as I

RE: Converting TEXT to BLOB with special chars

2006-07-18 Thread Addison, Mark
From: Mike van Hoof Sent: 18 July 2006 12:18 To: Addison, Mark Subject: Re: Converting TEXT to BLOB with special chars Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having a problem, and am

RE: queue select

2006-07-10 Thread Addison, Mark
From: Vittorio Zuccalà Sent: 10 July 2006 14:26 Hello, i've two tables and they have the same field. I'd like to make a select which take records in a table and after it shows record in the other table in the same field... I try to explain: Table1 FieldA - FieldB AAA123 - Cellular

RE: Date functions

2006-07-07 Thread Addison, Mark
From: Chris W Sent: 07 July 2006 09:23 It's late and I just gave up reading the manual. Can someone please tell me the easiest way to do a query that will return all rows with a time stamp that is X number of seconds older than the current time? Something like this. SELECT *

RE: Character set problem

2006-07-06 Thread Addison, Mark
From: Spiros Philopoulos Sent: 06 July 2006 13:32 Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm trying to set the charcter set collation at the database level but can't get it to work. It works by setting it at the server level (in my.cnf) but I want to set

RE: remote monitoring of mySQL

2006-07-06 Thread Addison, Mark
From: Andy Ford Sent: 06 July 2006 17:06 What would be the best approach to remote monitoring of numerous mySQL databases remotely i.e. number of threads. number of open tables etc etc Can I do it with DBD::Perl You could, run queries such as SHOW STATUS; SHOW TABLE STATUS; against

RE: comparing 2 dbs and generating 'upgrade sql'

2006-04-13 Thread Addison, Mark
From: starmonkey Sent: 13 April 2006 01:51 hey guys, A while ago I remembered using SQLYog or some other tool that could look at two databases (say dev and test versions) and work out the differences in structure between the two, and generate some SQL to 'upgrade' one to the other

RE: ~problem with select into outfile~

2006-04-13 Thread Addison, Mark
From: Mohammed Abdul Azeem Sent: 13 April 2006 07:29 Hi Iam having a problem using select into outfile command, iam getting the following error. can anyone help me trace the problem. mysql SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table WHERE last_time_update =

RE: mysql query and version problem .... Help!

2006-03-21 Thread Addison, Mark
-Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider is using mysql 4 and I'm using mysql 5 the one query I