Monday, January 19, 2009

mysql - copying data to other db using sqlyog

Sqlyog is pretty good client to access mysql and doing various operation on MySQL. I wanted to make copy of full DB for backup purpose. I took dump using sqlyog (structure+ data). then I was going to create new DB by running this script but noticed
functionality of copying db to other DB in sqlyog. I thought that would be safe. but it turned out that it was taking lots of time. so I suggest its better to copy data using taking dump of db and run those script to create fresh db. wat do you think?

No comments: