Mysql dump in terminal mode

For taking Dump : mysqldump -u username -p test> test>

Then Enter Password if prompts for password


For Restoring Dump :  mysql -u username -p test> < test>

Then Enter Password if prompts for password

Now I have restored the dump. So no need to take dump and restore.

scp -r <username>@<domainname/ip address>:/<file path>  <destination path>


For Windows
mysql.exe -uroot -p dbname < dump
you need to do this in xampp/mysql/bin/ path

Basic Linux Commands

1. mkdir - make directories
2. cd - change directories
3. mv- change the name of a directory
   Ex: mv testdir newnamedir
4. pwd - print working directory
   will show you the full path to the directory you are currently in.
   This is very handy to use, especially when performing
   some of the other commands on this page
5. rmdir - Remove an existing directory
6. rm -r
   Removes directories and files within the directories recursively.
7. chown - change file owner and group
8. chmod - change file access permissions
9. reboot - Reboots the system (requires root privileges).
10.ping host - Sends an echo request via TCP/IP to the specified host. A response confirms that the host is operational.