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? :-)

Your Friend,

John

--
John Kopanas
john@kopanas.com

http://www.kopanas.com
http://www.cusec.net
http://www.soen.info

> 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