database file

Hi all,
I want to know if MySQL can shrink database file?
Because my friend told me when he deleted one table,
the size of database file still the same.

Regards
Edwin

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: database file

Read.

http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

edwin wrote:
> Hi all,
> I want to know if MySQL can shrink database file?
> Because my friend told me when he deleted one table,
> the size of database file still the same.
>
> Regards
> Edwin
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org