locate database on diffrent disk

[daniel]

hello,

I would like to know if there is any option in the direct admin to decide, that all the files will be in disk 1 while all the data base (sql) files will be locate on disk 2

thanks

 

[redesb]

Maybe not the ideal way, but whath I make is to create a symlink of the DB dir to a new location:

ln -s /var/lib/mysql/my_database /path_to/other/disc/my_database

remember to stop mysql daemon, create the new dir on destination disk preserving permissions, owner and group and be quick due DA monitor system relaunch the stoped mysql on the minute boundary.

Hope this help

 

[daniel]

umm sounds nice

but does all the data bases which my users creates stored in this location?

Is there no other built in function in the directadmin which has this ability?

 

[redesb]

I could not find any script who do the creation of the users databases in the DA directory but I don't make a in depth search because I only need to move one special user database, but sure John say you some thing interesting about if you write him at [email protected], until now always it has responded to all the messages I send asking any thing.

 

[daniel]

thanks for your suggestion

and I will try the email too

thanks

 

[DirectAdmin Support]

Hello,

Here is a sample guide on exactly how to do this:
http://help.directadmin.com/item.php?id=12
It moves all data from /var/lib/mysql to /home/mysql using symbolic links. You can use any path you wish.

John

 

[intramanga]

same problem with mail folder

Hi John,

I like this solution very much, however in my case the culprit is the var/mail folder filling up all the space. However this folder is already a symlink to var/spool/mail ..
I would like to bring this to my home folder. Any manual somewhere how I can do this without breaking things ?

Thanks in advance,
Ed,

edit: its my var/spool/virtual filling up the space !! (some users seems to like to keep their mail on the server )

 

[daniel]

Hello,

Here is a sample guide on exactly how to do this:
http://help.directadmin.com/item.php?id=12
It moves all data from /var/lib/mysql to /home/mysql using symbolic links. You can use any path you wish.

John

Ok...

With this solution all the user data bases will be located where i want to?

Or only the bin and conf file of the database?

 

[smtalk]

It moves all databases (everything what is in /var/lib/mysql).

 

[daniel]

thank u very much i will try this on my server