used move_domain.sh

[chriske21]

Hello,

I moved some website to a different user using move_domein.sh from the scripts dir. Everthing seemed rite but all the databases are not moved to this new user. Only the websites are. How do i get all the databases under the right account now?
________
BMW K75

 

[smtalk]

You need to rename them. move_domain.sh script does not rename databases, because it can cause some propblems with PHP scripts. Change the prefix from olduser_ to newuser_.

 

[nobaloney]

Martynas, do you then have to also change the username part of the database name in all your scripts?

Jeff

 

[smtalk]

If you rename the databases But if you don't - the script doesn't touch MySQL at all.

 

[IT_Architect]

One other thing I ran into doing this is I needed to
chown -R <username>:apache public_html
chown -R <username>:apache private_html
since after the move they were set to <username><username> thereby not allowing Apache access to the web pages.

 

[floyd]

Actually chown username:username is correct at least for RedHat based systems. Maybe Debian is different. If you are using Debian and Debian requires this then please make sure you specify this so users on RedHat based systems do not mess up their permissions. If I remember right chown username:apache is dangerous but I could be wrong about that.

 

[IT_Architect]

I should have specified I am using FreeBSD.

 

[floyd]

Cool. I could not remember which one you were using. I knew it was something other than RedHat based. I don't know why FreeBSD does something different.