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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]