Sysadmin test server

Hello,

---

Now, I have my website online based on centminmod and everything is running fine but there're some options I want to test it so what do you suggest to make another copy of my server and website to try the new options online first before I use it at the main one ?

Thanks

 

Thank you but should I install centminmod first on the remote server before starting the migration ?

 

1- Should I install CSF on the remote server ?

2- Where should I add this commands ? ( only write it on putty ? :
*remoterootpass ( the password of the remote root )
*yourremoteserver = ( is that the hostname ? ) server2.cloud as ex ???
*rootpassword = ( write the same root password again ???

Code (Text):

remoteip=111.222.333.444
port=22
comment=mykey
[U]remoterootpass=yourremoteserver_rootpassword[/U]

3- I didn't get this step
" First time you connect you'll be asked about authenticity of the remote host ip and get a fingerprint displayed and ask if you are sure you want to continue connecting. Answer yes "

, it takes me to this one :

snipped

Thanks

 

I have a question please, how the copy of my website will be accessible without editing DNS ?

 

Sorry, I didn't notice this point. I will update you with my steps once I finish it

 

Hello

I'm getting this error. I'm sure that database transferred :

Code (Text):

mysql -e "YOUR GRANT CMD"
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'YOUR GRANT CMD' at line 1

note that when I entered the exact below command nothing happened :

Code (Text):

 mysql --batch --skip-column-names -e "SELECT user, host FROM user" mysql | while read user host; do if [[ "$user" != 'root' ]]; then mysql --batch --skip-column-names -e "SHOW GRANTS FOR '$user'@'$host'" | sed -e 's|$|;|'; fi; done

What that mean ?

Thanks

 

I got you. The first created command run empty. But the second one gives me that error :

Code (Text):

 mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `DATABASENAME`.* TO 'DATBASEUSERNAME'@'localhost';"
-bash: DATABASENAME: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* TO 'DATABASEUSERNAME'@'localhost'' at line 1

* I ran both commands on the remote server after copying the both lines(GRANT...) from the main server.

Thanks for help

 

sorry for explaining what I did again :

I did what you said, I opened the live server and I ran this command :

Code:

mysql --batch --skip-column-names -e "SELECT user, host FROM user" mysql | while read user host; do if [[ "$user" != 'root' ]]; then mysql --batch --skip-column-names -e "SHOW GRANTS FOR '$user'@'$host'" | sed -e 's|$|;|'; fi; done

then I ran those commands on the remote server :

Code (Text):

mysql -e "GRANT USAGE ON *.* TO 'dbuser1'@'localhost' IDENTIFIED BY PASSWORD '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7';"

successfully

Code (Text):

mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `dbname2`.* TO 'dbuser1'@'localhost';"

giving me the error in the previous replay

and when I tried to check grants on the remote server it gives me the following :

Code (Text):

+-------------------------------------------------------------------------------------------------------------------+
| Grants for DATABASEUSER@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'DATABASEUSER'@'localhost' IDENTIFIED BY PASSWORD '*94ECAC90F8C83E94ACB7CCC7CA9581B9E3E69B73' |
+-------------------------------------------------------------------------------------------------------------------+

**The first command was added but the second NOT??

Thanks alot

 

the output on live :

Code (Text):

GRANT USAGE ON *.* TO 'userdb'@'localhost' IDENTIFIED BY PASSWORD '*94ECAC90F8C83E94ACB7CCC7CA9581B9E3E69B73';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `dbname`.* TO 'userdb'@'localhost';

 

Yes I understand, please check that what happened exactly with real info : please delete it after checking :