And if you are using MySQL, then mysqldump (a command line program)
has just become your new best friend.

You could write a bash script which contain the necessary commands.

refreshdb.sh
#!/bin/bash
#drop database
mysql -u username -p pwd -h host "DROP DATABASE BLAH" (can't remember syntax)
mysql -u username -p pwd -h host < mysqldumpdata.txt



On Fri, 1 Oct 2004 14:22:20 +1000, Barry Beattie <[EMAIL PROTECTED]> wrote:
> of course, if it's SQLServer, you can get the create table script from
> saving table AND data (the Ent Mgr tool) and delete the DDL code,
> leaving the insert statements for each row...sloppy but do-able

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to