From: R&D Aust John Bonnett Date: December 4 2003 11:11pm Subject: RE: MySQL database List-Archive: http://lists.mysql.com/benchmarks/41 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" I have never tried this but if the two versions of MySQL are the same or close enough it may work. You may have to add any relevant GRANTs separately. I think the best thing would be to give it a try with a small database. It may be best to make sure both servers are shut down when you do it. John Bonnett -----Original Message----- From: Muhammad Waseem Arfi [mailto:waseem@stripped] Sent: Thursday, 4 December 2003 6:38 PM To: benchmarks@stripped Cc: win32@stripped Subject: MySQL database Dear members, In mysql whenever a new database is created, a separate folder in data directory is generated. If I copy that database folder and paste it on some other machine in the data folder. Will that database would be completely transferred to the other machine or not? Moreover, I have just seen a variable in MySQL in the following format: long_query_time 10 What this query time stands for? I mean This value of 10 means what for a developer? =============================== Best Regards. GOD bless you. From, Muhammad Waseem Arfi. Mobile: +923009487680