Many Thanks for the kind replies.
I have decoded in my code but just wondering in case I missed any solution
to decode via query.
On Thu, Mar 20, 2014 at 3:05 PM, Michael Dykman wrote:
> Short answer, no. There is nothing in MySQL to facilitate this. In
> general, storing structured data as a
May also be of interest;
http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql
On Fri, Mar 21, 2014 at 12:27 PM, Sukhjinder K. Narula
wrote:
> Many Thanks for the kind replies.
>
> I have decoded in my code but just wondering in case I missed any solution
> to decode via q
Frequently, we import a production dump that contains only 1 or 2 databases
into one of our QA instances that contains many more databases. (i.e.
"database" being a "schema" or a "catalogue).
At the beginning of the import script, we first drop all objects in the QA
database so that it will be a
Frequently, we import a production dump that contains only 1 or 2 databases
into one of our QA instances that contains many more databases. (i.e.
"database" being a "schema" or a "catalogue).
At the beginning of the import script, we first drop all objects in the QA
database so that it will be a
Thanks Wayne. This a great idea to prevent user activity on the server. I’ll
use it in the future.
But I’m looking for a way to prevent user activity on a database ((i.e.
"database" being a "schema" or a "catalogue).
David.
David Lerer | Director, Database Administration | Interactive |
Hi David.
On 3/21/2014 1:42 PM, David Lerer wrote:
Frequently, we import a production dump that contains only 1 or 2 databases into one of our QA instances
that contains many more databases. (i.e. "database" being a "schema" or a
"catalogue).
At the beginning of the import script, we first dro
Hi list,
I'd like your advice, (one more time ;) ) about this case :
The context is :
A huge database using InnoDB engine from filling about several years
(without possible shrinking, as I've seen, except dropping all databases
to recreate them ... ) the ibdata file , which is taking over 9GiB o
Hello Christophe,
On 3/21/2014 4:47 PM, Christophe wrote:
Hi list,
I'd like your advice, (one more time ;) ) about this case :
The context is :
A huge database using InnoDB engine from filling about several years
(without possible shrinking, as I've seen, except dropping all databases
to recr
