Click to See Complete Forum and Search --> : Tables question


ttohme
August 20th, 2003, 05:54 PM
Hi guys,

I have a MySql DB, I was wondering if I have a newer version of a table can I just simply copy the data file (.MYD) to the data directory and the table is updated, I have concerns that the DB will not let you copy the file because it is in use and will need to stop the service to overwrite.
Now I have tried it and it worked but I need to know if it is safe and reliable meaning that it will work all the time.
My other alternative is that my application will have to go row by row and update the current table.

Thanks

BlueGazoo
September 7th, 2003, 09:48 PM
Thats what i did. I copied all files of each new table i had into mysql/data/test at the dos prompt. Haven't had a problem yet.