Skip to main content.

.:: WELCOME ::.
TopResource.NET is complete Resources and Articles for each topik. The resources will be add more and more by personal experience to share everything about interesting information.

TopResource.NET Articles:

Category : Computers (IT)

Easy Way to Backup with mysqldump and Compression Together
Post by: admin at July, 2010

MySQL database is one of the most popular used for either profit or nonprofit purposes, this occurs because the MySQL database server is open source and free for use by anyone. MySQL is also very popular by the internet user and the many servers hosting for the website.

In this article we will discuss how to perform backups of the database size from an internet server. The example : I would use is to perform backups, including the compression process with gzip in the Linux computer.

Example:

  • MySQL Database Server: mysql.aa.com
  • MySQL user: theuser
  • MySQL Password: thepassword
  • MySQL Database Name: thedata

Command at Linux Shell (I use Putty with SSH Protocol) :

mysqldump -u theuser -p -h mysql.aa.com - databases thedata | gzipped> mybackup.gz

Description:

  • U = username
  • P = password
  • H = hostname

Hopefully this article useful for all.

 
Related Category :

Other Category :