psx's questions

I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently.

I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but I get the following output:

mysql.columns_priv
Error    : Incorrect file format 'columns_priv'
error    : Corrupt

Is there any other way to repair this table, or how do I go about replacing it with a blank table? What would I lose by doing that?

Thank you

Edit (Additional Info) mysqld is currently using 100% cpu constantly.

Looking at show processlist, I get:

mysql> show processlist;
+-----+------------------+-----------+-------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
| Id  | User             | Host      | db    | Command | Time | State             | Info                                                                                                 |
+-----+------------------+-----------+-------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
|   5 | debian-sys-maint | localhost | mysql | Query   | 1589 | Opening tables    | ALTER TABLE tables_priv
   MODIFY Column_priv set('Select','Insert','Update','References')
     COLL |                                                                        |
| 752 | root             | localhost | NULL  | Query   |    0 | NULL              | show processlist                                                                                     |
+-----+------------------+-----------+-------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

During boot of VMware ESXi 3.5 install CD, I got the message

Unsupported BIOS setting (CPUID is limited). Disable 'limit CPUID value' or 'Support legacy/NT4 OS' in BIOS

After googling, this is a common problem and after following the fix at http://vm-help.com/esx/esx3i/ESXi_35_common_issues.php#CPUID_is_limited , everything worked fine.

My question is, what does this mean for me? Do I have a crippled install of VMware because I've effectively bypassed this check that obviously it really cares about? (pink screen of death). What features, if any, am I losing out on?

Problem:

Windows clients unable to see Windows Server 2008 shares when server is powered on after a laptop (with wireless). The server and other client have cabled connections.

Example situation

Laptop powered on (wireless) (L), another client powered on (C), Server powered on (S). C cannot see S but can see L. Turn laptop wireless off, C can see S.

Already checked

There are no IP address conflicts. What else can I check / any suggestions as to what may be causing this?

Is there a way to get the PHP script filename that is currently hammering my VPS?

For example, when I view "top", I see:

PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
7622 itil      17   0 61388  11m 6004 R 45.8  2.3   0:00.13 php
7626 itil      17   0 58360 8632 5440 R 24.6  1.6   0:00.07 php

How can I find out what file is being processed by PHP at that particular time?

Possible Duplicate:
Everything You Ever Wanted to Know about Mod_Rewrite Rules but Were Afraid to Ask?

The below code adds www. to any url that does not start with it:

RewriteCond %{HTTPS} !on [OR]
RewriteCond %{HTTP_HOST} !^www\.
RewriteCond %{HTTP_HOST} ^(www\.)?(.+)
RewriteRule ^ https://www.%2%{REQUEST_URI} [L,R=301]

However, I want it to do this only when the url is of the format:

something.com

If the url is like:

something.something.com

I do not want the rule adding www.

How do I change this?

I am running a mysqldump via a bash script and have encountered a problem with a password that contains special characters.

mysqldump -hlocalhost -uUSERNAME -pPA$$W0RD DATABASE | 
                                gzip > /home/USERNAME/backups-mysql/BACKUP.gz

How do I escape the password?