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. > >> > > >>

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, >

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 > a

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

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

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. > > SEL

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; again

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

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: 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

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 o