Hi, everybody, I have installed the mysql server in /var/lib/mysql and created my database "Protein" under the this path as required in mysql and linux(the operationg system is linux). But the problem is the space for /var is not enough, there exists an exteral driver to try to solve this problem. My question is how to move my database "Protein" into the exteral driver so I later can use the database in external driver instead of current database? Do I need change mysql server from /var/lib/mysql to new external drive? Any other thing I need care about? I look at the command mysqlhotcopy which only can copy existing database for backup purpose not for working database? Anybody know how to do it? Thanks a lot! zhu liu
--------------------------------------------------------------------- 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