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