Database Copy from local to remote server

This is DataBase copy form local to remote serve. i written the step by step

follow the command and just easy to copy your code local to remote serve.

1. Copy from local to remote serve cmd,

scp -i PlayGame_database.pem PlayGame-13.sql.tar.gz root@ec2-23-21-174-12.compute-1.amazonaws.com:/root

2. Connect the server cmd

ssh -i PlayGame_database.pem root@23.21.174.12

3. untar file cmd

tar xvfz PlayGame.sql.tar.gz

4. restore command

mysql -u root -p PlayGamelive < PlayGame-13.sql