On Tue, 30 Apr 2002, Liam Gibbs wrote:
>> Before starting a test, dump your database with the
>> mysqldump command.
>> Edit this file to create/use your test database.
>> Load your test database with this file.
> Hmm. No I didn't do this. Not too familiar with all
> the intricacies of MySQL (or SQL). I'll take a look at
> dumping the database.

Something like:

   mysqladmin -u root create temp_db
   mysql -u root -e 'grant all access on temp_db to real_user'
   mysqldump -u real_user real_db | mysql -u real_user temp_db

and then when you're done:

   mysqladmin -u root drop temp_db

obviously adding -p to those lines as appropriate.

But it's not going to be that fast with large databases, and you'll have 
to work out some scheme for dealing with multiple users each needing their 
own copy.

We don't know nearly enough about your project to really work out 
alternatives for you, but I bet there's a good one somewhere. Temp tables, 
shadow tables in the same database, something.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to