RE: Looking for consultant

2012-07-19 Thread Stillman, Benjamin
7.2 introduces geographic clustering: https://blogs.oracle.com/MySQL/entry/synchronously_replicating_databases_across_data http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html (section titled: Enhancing Cross Data Center Scalability: Multi-Site Clustering) Data nodes can be

Reading in NA's into a column with Decimal datatype

2012-07-19 Thread Fred G
Hi guys-- I am having some trouble importing a csv file correctly as a table in my new database. In particular, there are 4 NA's in a column with 10,000+ other rows that have decimal values for that column. How can I get MySQL to read in these NA's as some sort of null that is accepted by the

RE: Reading in NA's into a column with Decimal datatype

2012-07-19 Thread Rick James
The online doc for LOAD DATA gives an example of how to read the data into an @variable, then do arithmetic (etc) on it before putting it into the 'real' field. In your case, some something like @foo, BF1 14:46:20 ~$ yinst self-update -br yinst7test Password: yinst: Need help?

Disable DB without deleting data

2012-07-19 Thread Kirk Hoganson
I need to find an easy way to make a database unavailable without deleting the data, so that it could be easily and quickly restored if necessary, without impacting the availability of the other databases. Something like moving the databases subdirectory to a different directory, or the

Re: Disable DB without deleting data

2012-07-19 Thread Reindl Harald
Am 20.07.2012 00:47, schrieb Kirk Hoganson: I need to find an easy way to make a database unavailable without deleting the data, so that it could be easily and quickly restored if necessary, without impacting the availability of the other databases. Something like moving the databases

Re: Disable DB without deleting data

2012-07-19 Thread Andrew Moore
Revoke all privileges to it. No access, no use. On Thu, Jul 19, 2012 at 11:47 PM, Kirk Hoganson kirkhogan...@gmail.comwrote: I need to find an easy way to make a database unavailable without deleting the data, so that it could be easily and quickly restored if necessary, without impacting the