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 erico...@gmail.com wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
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
narula...@gmail.comwrote:
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 and
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
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,
...@gmail.comwrote:
Kishore,
No, as already explained, it is not possible, Innodb datafiles *never*
shrink.
Cheers
Claudio
On May 22, 2012 10:05 AM, Kishore Vaishnav kish...@railsfactory.org
wrote:
Hi,
I understand that if I set the innodb_file_per_table then once the table
is drop the datafile
.
On 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, where records get updated / deleted
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 anan...@gmail.com wrote:
do u have one file per table or just one system tablespace datafile