Re: restoring from sqldump with accented characters

2007-07-13 Thread Ananda Kumar 

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 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 apostroph like "l'état" for example. When running the
file I get an sql syntax error. When I remove the accented characters
the file runs fine.
I've been searching through the documentation, but I didn't find a
clear solution. The tables are InnoDB with the charset expicitly set
to latin1 (ENGINE=InnoDB DEFAULT CHARSET=latin1) So I don't think I
should need to add another charset. Still somehow the data was
entered into the original database.

Any hints on how I could solve this problem?





Thanks,


Peter Teunissen

-- Never argue with idiots; they'll drag you down to their own level
and beat you on experience.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL admin GUI

2007-07-13 Thread Manolov, Mihail 

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 2007
Subject: 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'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 
> www.giiexpress.com 
> www.etudes-marche.com
>  





-
Olaf Stein
DBA
Center for Quantitative and Computational Biology
Columbus Children's Research Institute
700 Children's Drive
phone: 1-614-355-5685
cell: 1-614-843-0432
email: [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

restoring from sqldump with accented characters

2007-07-13 Thread Peter Teunissen 

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 apostroph like "l'état" for example. When running the  
file I get an sql syntax error. When I remove the accented characters  
the file runs fine.
I've been searching through the documentation, but I didn't find a  
clear solution. The tables are InnoDB with the charset expicitly set  
to latin1 (ENGINE=InnoDB DEFAULT CHARSET=latin1) So I don't think I  
should need to add another charset. Still somehow the data was  
entered into the original database.


Any hints on how I could solve this problem?





Thanks,


Peter Teunissen

-- Never argue with idiots; they'll drag you down to their own level  
and beat you on experience.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL admin GUI

2007-07-13 Thread Olaf Stein 
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'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 
> www.giiexpress.com 
> www.etudes-marche.com
>  





-
Olaf Stein
DBA
Center for Quantitative and Computational Biology
Columbus Children's Research Institute
700 Children's Drive
phone: 1-614-355-5685
cell: 1-614-843-0432
email: [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL admin GUI

2007-07-13 Thread Jim Ginn 
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 Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com 
> www.giiexpress.com 
> www.etudes-marche.com
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL admin GUI

2007-07-13 Thread Jerry Schwartz 
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  
www.giiexpress.com  
www.etudes-marche.com

Re: Greater function ?

2007-07-13 Thread Yoge 

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(last_conneciton_date, insert_date)

Anybody knows the way to do it in Mysql ?

Thanks in advance
---
Amor o Pareja
http://www.amoropareja.com


  



--
Yoge,
AdventNet, Inc.
925-965-6528
[EMAIL PROTECTED]
site24x7.com

Re: Greater function ?

2007-07-13 Thread Mark Leith 

[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 LEAST()..

Cheers,

Mark

--
Mark Leith, Senior Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified?  www.mysql.com/certification


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Greater function ?

2007-07-13 Thread aa2788 
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.amoropareja.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: monitoring mysql

2007-07-13 Thread Yoge 
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:

Hi,

John Mancuso wrote:

I am running a fairly large Innodb database on mysql 5.x and would like
to know what would be the best variables to monitor (for Nagios)- for
instance: threads
connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow
queries etc


This is kind of a bottomless question.  Some people just monitor 
everything, period, in case they ever want to look back.


Good general suggestions are in Kristian's talk from the MySQL 
conference earlier this year:


http://mysqldump.azundris.com/archives/68-Monitoring-MySQL.html

Baron




--
Yoge,
AdventNet, Inc.
925-965-6528
[EMAIL PROTECTED]
site24x7.com

restore mysqldump

2007-07-13 Thread Ananda Kumar 

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
machine, and i dont want to disturb this.


regards
anandkl