Skip to content

emka.web.id

Menu
  • Home
  • Indeks Artikel
  • Tutorial
  • Tentang Kami
Menu

Backup MySQL via SSH

Posted on January 11, 2013 by Syauqi Wiryahasana
This article will show you how to create a backup of your MySQL database using the command line Linux MySQL tools. 1. Connect to your Linux server via SSH 2. Use the mysqldump utility to create your database backup. The command is run in the format: [sourcecode]mysqldump –host server_name –user username --password db_name > backup_file_name.mysql[/sourcecode] Host: the hostname or IP Address of the MySQL server that hosts your database User: your MySQL user name Password: your MySQL password. You will be prompted to enter this when the command is executed. DB Name: the name of your MySQL database Backup File Name: this is the file that will contain the backup of your database. 3. When prompted enter your database password. 4.Your database is now being backed up to the specified file. 5.Additional options can be found by running "mysqldump –help" or by viewing the MySQL reference manual
Seedbacklink

Recent Posts

TENTANG EMKA.WEB>ID

EMKA.WEB.ID adalah blog seputar teknologi informasi, edukasi dan ke-NU-an yang hadir sejak tahun 2011. Kontak: kontak@emka.web.id.

©2024 emka.web.id Proudly powered by wpStatically