I am doing tests so I want to easy take my DB and make a full copy of
it into a test db everytime I want to test something against the
non-produciton version of DB. What is the easiest way to do this.
So I have a DB called "backlog" and I want to copy it's structure and
data into "backlog_test" with ease :-). Any sexy suggetions? :-)
This is what I do...
mysqldump -v --lock-tables=false backlog | mysql backlog_test
Not practical if your dataset is huge, but if it's not that big, works
great.
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]