I am trying to export a huge MyISAM table in a MySQL database into a .SQL file. Will doing so lock the entire table and prevent applications from using it during the export?
If so, is there an alternative?
Asked
Active
Viewed 138 times
0
-
Use mysql yog to export table. Lock is not getting applied but perfomance of mysql get slowed down. But if you use mysql yog OR any other mysql client would be better enough – Anup Yadav Dec 16 '12 at 10:13
-
Thanks. I am using Sequel Pro. – Spartanblogger Dec 16 '12 at 10:20