Jump to content

Export A MySQL Database / Back up Big Files via SSH/Putty


Dev Blaze

Recommended Posts


  • Group:  Members
  • Topic Count:  68
  • Topics Per Day:  0.02
  • Content Count:  212
  • Reputation:   5
  • Joined:  01/24/12
  • Last Seen:  

This example shows you how to export a database. It is a good idea to export your data often as a backup.

1. Put The Directory

#cd /root

2.Using SSH, execute the following command:

#mysqldump -p -u username database_name > dbname.sql 

 

Untitled_zps26082e67.png

 

3. Enter your phpmyadmin Passsword

DONE..

4. Open your winscp check the directory   /root    

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1702
  • Reputation:   238
  • Joined:  09/05/12
  • Last Seen:  

Topic approved! /no1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...