List:Database Benchmarks« Previous MessageNext Message »
From:R&D Aust John Bonnett Date:December 4 2003 11:11pm
Subject:RE: MySQL database
View as plain text  
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
Thread
MySQL databaseMuhammad Waseem Arfi4 Dec
RE: MySQL databaseR&D Aust John Bonnett4 Dec