DB Memo + Linux SFTP stuff.

Back-up DB:

  • mysqldump -u <UserName> -p db_name table_name > saveFileName

Restore From File:

  • mysql -u <user_name> -p db_name
  • source <full_path>/saveFileName

Using sftp in CentOS( or other linux-like OS)

Available commands:
bye                                Quit sftp
cd path                            Change remote directory to ‘path’
chgrp grp path                     Change group of file ‘path’ to ‘grp’
chmod mode path                    Change permissions of file ‘path’ to ‘mode’
chown own path                     Change owner of file ‘path’ to ‘own’
df [-hi] [path]                    Display statistics for current directory or
filesystem containing ‘path’
exit                               Quit sftp
get [-Ppr] remote [local]          Download file
help                               Display this help text
lcd path                           Change local directory to ‘path’
lls [ls-options [path]]            Display local directory listing
lmkdir path                        Create local directory
ln [-s] oldpath newpath            Link remote file (-s for symlink)
lpwd                               Print local working directory
ls [-1afhlnrSt] [path]             Display remote directory listing
lumask umask                       Set local umask to ‘umask’
mkdir path                         Create remote directory
progress                           Toggle display of progress meter
put [-Ppr] local [remote]          Upload file
pwd                                Display remote working directory
quit                               Quit sftp
rename oldpath newpath             Rename remote file
rm path                            Delete remote file
rmdir path                         Remove remote directory
symlink oldpath newpath            Symlink remote file
version                            Show SFTP version
!command                           Execute ‘command’ in local shell
!                                  Escape to local shell
?                                  Synonym for help

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s