RE: MySQL password issue

2012-10-24 Thread Nitin Mehta
Hi Tim, It looks like your '.sql backup file' has changed the password for root user and why it is persisting is perhaps you have data directory outside the install directory. How you correct the problem: Stop the service, start the service with option '--skip-grant-tables', login with root u

MySQL password issue

2012-10-24 Thread Tim Thorburn
Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Windows Update. I downloaded the Windows Installer version of MySQL

Re: Backup Error while backing up MySQL Cluster

2012-10-24 Thread Bheemsen Aitha
Just for others to know, it was the memory problem. I re-set the memory parameters for ndbmtd (two nodes) to minimum. Then I could run the backup successfully. Thanks BA On Wed, Oct 24, 2012 at 11:57 AM, Bheemsen Aitha wrote: > Hi, > > After following the steps at the following website, I tried

Re: get a partial dump

2012-10-24 Thread Stefan Kuhn
Ok, but I can't trace foreign key references, can I? Plus I can't run this from Java (well, I can, but it's cumbersome)? But thanks for the hint Stefan On Wednesday 24 October 2012 05:33:22 Eric Bergen wrote: > mysqldump has a --where argument that allows you to pass in a where clause. > > On Th

Re: Backup Error while backing up MySQL Cluster

2012-10-24 Thread Shawn Green
On 10/24/2012 11:57 AM, Bheemsen Aitha wrote: Hi, After following the steps at the following website, I tried to do an online backup of the cluster. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html It is a plain vanilla command which is below. The cluste

Backup Error while backing up MySQL Cluster

2012-10-24 Thread Bheemsen Aitha
Hi, After following the steps at the following website, I tried to do an online backup of the cluster. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html It is a plain vanilla command which is below. The cluster is almost an empty database, but backup is cra