Did you tried this..
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, May 29, 2014 at 11:22 AM, Érico wrote:
> I have ran the following to test a fix for an app issue :
>
> delete from mysql.user where user='';
> 2lines got effecte
Hi,
http://blog.ulf-wendel.de/2013/mysql-5-7-sql-functions-for-json-udf/
This is not the exact solution for you query, but might help you better if
you add the libraries.
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, Mar 20, 2014 at 11:35 AM, Sukhjinder K. Narula
wrote:
> Hello,
> I would lik
Is it the question that "how to dump drupal database ?" then here is one of
the option. You can look at the details mentioned in the
default/settings.php file and use mysql to export the data. Or the other
option to install a module in Drupal "Backup & Restore" which can you just
login thru drupal
Hi All,
Not sure if anyone has implemented a Proxy for a Master Master Replication
of MySQL, is it doable ? If yes, how, which tools can be used ?
[image: Inline image 1]
Generally Master A will be Master when Proxy hits Master A and Master B
will be slave
When Master A is not able to reach or
LTER TABLE"
> without real changes
>
> Am 22.05.2012 11:28, schrieb Kishore Vaishnav:
> > Right now one tablespace datafile. But does it matters if i have one file
> > per table.
> >
> > On Tue, May 22, 2012 at 2:56 PM, Ananda Kumar wrote:
> >
> >>
n Tue, May 22, 2012 at 2:20 PM, Kishore Vaishnav <
> kish...@railsfactory.org> wrote:
>
>> Thanks for the reply, but in my case the datafile is growing 1 GB per day
>> with only 1 DB (apart from mysql / information_schema / test) and the size
>> of the DB is just 600MB,
ishore,
> No, as already explained, it is not possible, Innodb datafiles *never*
> shrink.
>
> Cheers
>
> Claudio
> On May 22, 2012 10:05 AM, "Kishore Vaishnav"
> wrote:
>
>> Hi,
>>
>> I understand that if I set the innodb_file_per_table th
Hi,
I understand that if I set the innodb_file_per_table then once the table
is drop the datafile will also be lost. But is there a way where I truncate
the table and the datafile shrinks itself ?
*thanks & regards,
__*
Kishore Kumar Vaishnav
*
*
On Mon, May 21, 2012 at 6:43 PM,
