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.
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
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