At 15:59 -0700 6/6/03, Titu Kim wrote:
>Hi I am new to Mysql. I have the following newbie
>questions.
>
>1. How can i find/set the file size of for my .MYI and
>.MYD file?
You can find the sizes using ls on Unix or dir on Windows.
You don't set the sizes. Let the server manage the files.
>2. How can i add another file to a table if the .MYD
>file grows too large?
Once the file size reaches its maximum, that's as far as you can go.
>
>3. How to configure mysql client to access two mysql
>database on two machines with each database using
>different port number?
Not sure what you mean? Do you mean at the same time?
If so, you cannot do that. If you mean at different
times, use appropriate --host and --port options
to specify the hostname and port number.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/