Re: restoring from sqldump with accented characters

set this and try set session collation_database=latin1_swedish_ci; set session character_set_database=latin1; On 7/14/07, Peter Teunissen <[EMAIL PROTECTED]> wrote: Hi all, mysql 5.0.37 on CentOS4, default install using Mysql's rpm and using the standard mysql querybrowser and administrator

Re: MySQL admin GUI

In the os x version I am able to insert columns anywhere I want. Now I've noticed that there's no such option in windows' version. Strange. Cheers, Mihail - Original Message - From: Olaf Stein <[EMAIL PROTECTED]> To: Jerry Schwartz <[EMAIL PROTECTED]>; MySql Sent: Fri Jul 13 15:26:00

restoring from sqldump with accented characters

Hi all, mysql 5.0.37 on CentOS4, default install using Mysql's rpm and using the standard mysql querybrowser and administrator on Mac OSX. I've received a sql dumpfile from a database we need to restore on our development environment. In this file there are characters with accents and apo

Re: MySQL admin GUI

The only way I know how to do this with MySQL Admin is to alter the sql code it shows you after clicking apply (add and "after column_name") before executing On 7/13/07 3:05 PM, "Jerry Schwartz" <[EMAIL PROTECTED]> wrote: > Does anyone know how to add a field anyplace but at the bottom? I haven'

Re: MySQL admin GUI

Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com > Does anyone know how to add a field anyplace but at the bottom? I haven't > found any "insert here" functionality. > > Regards, > > Jerry Schwartz > The Infoshop by Global Information Incorpora

MySQL admin GUI

Does anyone know how to add a field anyplace but at the bottom? I haven't found any "insert here" functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com

Re: Greater function ?

You can use IF function ... */IF(last_conneciton_date> insert_date,last_conneciton_date, insert_date)/* --Yoge [EMAIL PROTECTED] wrote: Hi all, I'm looking for the mysql equivalent to oracle Greater function. In fact, I want to order by the greater of two timestamp fields order by greater(

Re: Greater function ?

[EMAIL PROTECTED] wrote: Hi all, I'm looking for the mysql equivalent to oracle Greater function. In fact, I want to order by the greater of two timestamp fields order by greater(last_conneciton_date, insert_date) Anybody knows the way to do it in Mysql ? GREATEST() - and it's opposite

Greater function ?

Hi all, I'm looking for the mysql equivalent to oracle Greater function. In fact, I want to order by the greater of two timestamp fields order by greater(last_conneciton_date, insert_date) Anybody knows the way to do it in Mysql ? Thanks in advance --- Amor o Pareja http://www

Re: monitoring mysql

You can use the Application Manager to monitor your mysql server. For more info http://manageengine.adventnet.com/products/applications_manager/mysql-management.html http://manageengine.adventnet.com/products/applications_manager/index.html --Yoge Baron Schwartz wrote:

restore mysqldump

Hi All, I have take mysqldump from one machine, now i want to restore this dump into another machine which is already have mysql up and running. I need to test this dump by restoring it into this machine. Can you please tell me how can i do this, becuase there is already mysql is running on this