free result and close db

If I make a connection as follows: $getcnnctd = @mysql_connect('this', 'that', 'bigsecret'); then select my db, then $res = mysql_query(select * from thedb); when finished using the db etc., am I assuming correctly that I should: mysql_free_result($res); to free the memory up and

miving dbs etc from one machine to another

have MySQL 4.0.20 on my mac os x 10.3.x client machine. My question is, how do I go about getting my MySQL databases that I created to another computer. I have been told my databases are in /usr/local/mysql/data. When I try to get into the sub-directory /data it says I do not have

insert data from text file

Should mysql version 4.0.20 support the Insert data from a textfile into table which is shown at the bottom of the page while in phpmyadmin with a database and table selected? I am getting this error: #1148 - The used command is not allowed with this MySQL version. Thanks for any help, Doug

showing dbs in terminal window opposed to phpmyadmin

How come when I am using the terminal on my mac os x 10.3.x and give the command show databases I only see one database (the 'test' database that is included in the install') as compared to viewing databases with my browser and phpmyadmin I can see 6 databases (that same 'test' database, a