Stephano Mariani wrote: > > Use symbolic links :) Actually, that's a good idea; it does let me put my table data somewhere else, but it's my fault that I didn't reveal my secret motivation in my original post. I have a general backup scheme which backs up everything in a set of directories containing important data, which typically does not include program code that I can reinstall, like MySQL. Hence the separation of the MySQL stuff from my database.
If I use symbolic links and stick to my backup scheme, I will risk destruction of my table and index structures, and whatever else may be in the "mysql database". I have been able to reach a compromise solution by copying the entire mysql\data tree to another location, which allowed me to run mysqld --datadir, whereupon I merely deleted databases I didn't want from the new location. It still seems desirable to have a utility to create a fresh mysql database. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php