Monday 21 July 2014

Export Data From Server Using Terminal

To Export Data from Terminal Use Following Command :


mysql -p -u databasename > databasename.sql 
OR
mysqldump -p -u databasename > databasename.sql




To Import Data from Terminal Use Following Command :

mysql -p -u databasename < databasename.sql

OR
mysqldump -p -u databasename > databasename.sql

Copy Data from server to localhost using ssh



 First Of all compress the file using following command

tar -cf name.tar name_of_folder

To copy a compressed folder from the server use following command

scp user@remotehost.com:/filepath/file.txt /some/localhost/folder

scp user@remotehost.com:/var/html/project.tar /var/www/



Keep Exploring