Backing Up MySQL Database on Web Hosting without CPanel
When your web hosting uses CPanel to control the web hosting so backing up MySql using CPanel is easy, but it will be difficult when your web hosting has no CPanel.
Now we have solution to backup MySql database manually using SSH connection using Putty.
- Download Putty if you don’t have one
- Run Putty, fill the host form with your domain name then press connect
- Login using your username and password then press enter
- Use linux command ls to see directories in your position
- Use linux command cd to change your position to html directory.
ex: cd domainfolder.com/html
- Use linux command to backup mySql
ex: mysqldump -u [username] -p [databasename] > [backupfile.sql]
mysqldump -u username -p databasename > backupfile.sql press enter then type your password
That is it, we backup the file in html so we can download it via ftp
Cara Belanja Di damastera
Silahkan pesan item ini dengan menghubungi Contact Toko yang tertera di sidebar kanan (untuk device mobile ada di bagian bawah), harap disertakan Kode Item atau Nama Item ketika order barang. Barang dikirimkan sehari setelah transaksi selesai. Atau silahkan pesan langsung via tombol Whatapps dan SMS di bawah ini. Admin toko akan langsung merespond pesanan Anda.
Pesan Sekarang SMS Sekarang
EmoticonEmoticon