On Wednesday 09 July 2003 00:53, Nils Valentin wrote:
> Hi Rudy,
>
> How about changing the port number in my.cnf and restarting the server ?
> All clients will look on the wrong port number and not be able to connect.
> That should do it while you take your backup.
>
> When finished change the por
did you try the --skip-networking option?
This option still allows local connections, so, not sure if it serves your purpose
though...
HTH,
SB
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:08 AM
To: [EMAIL PROTECTED]
Subject: backup / s
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port number back to 3306.
Best regards
Nils Valentin
Tokyo/Japan
I wonder if you could make a backup of your original users table, then make one
of JUST your super user... Then when you go to do your back up you would copy
your table with JUST your super user in there and go to work... After you are
done with the backup copy your old table back and restart mysql
