How to change owner and permission for sql. database?

[zigi00x]

Hii,

i copied the sql database from one user to another by FileManager in cwp, but when i was do, i get wrong owner and permissions, as u can see in the picture.



How i change the owner acces from phpmyadmin to moved database by filemanager?

Sorry for my ENG.

Thank you.

[iraqiboy90]

To change ownership:

Code Select Expand

chown user:user filename
To change permission [x being a number]

Code Select Expand

chmod xxx filename
I don't know which permission you want. So I can't give you the number. You could also google it.

I recommend backing up the SQL through phpmyadmin and then import it. I feel like this would minimize database corruption.

but if you insist on copying it like you did, then you need to use this extra command option with the copy command to copy the ownership and permissions with it:

Code Select Expand

cp -p