Scaffolding deprecated? Then?

[eluser]jedd[/eluser]
I tend to make my test data in text files - I have a bunch of CREATE_<tablename>.mysql files, and a main CREATE.mysql that sources each of those.

I have a comparable bunch of INSERT_<tablename>mysql and a wrapper, INSERT.mysql, that in turn sources each of those.

I prefer this to scaffolding for a number of reasons. It's faster to create my test data, I can cookie-cutter my files, I can do FK's more easily, I can re-create my database and my test data with just two commands, and errors are immediately visible and easier to resolve.

You mention SSH - so you presumably have command line access to your database, and it's not on your local computer - is that right?