Re: How to move database from one directory to another

2003-02-17 Thread Diana Soares
Hi, If you only want to move database "Protein" (and not all your databses) you can use symbolic links to do that. You can move your database to the desired path (external drive) and create a symbolic link in /var/lib/mysql/ to it like: localhost:/var/lib/mysql# ln -s /desired_path/Protein Protei

How to move database from one directory to another

2003-02-16 Thread Liu, Zhu
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 proble