Database

From Server STB
Jump to navigation Jump to search

Backup

mysqldump -u database_username -p database_name > /home/cpanel_username/backup/backup_satu_database.sql


Docker

docker run -d -p 3388:3306 --name db_record -e MYSQL_ROOT_PASSWORD=4rt1s4n -v /DATA/record:/var/lib/mysql mysql

PHP

<?php
$servername = "localhost"; // Nama server, biasanya 'localhost'
$username = "username"; // Username database
$password = "password"; // Password database
$dbname = "nama_database"; // Nama database
// Membuat koneksi
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Memeriksa koneksi
if (!$conn) {
   die("Koneksi gagal: " . mysqli_connect_error());
}
echo "Koneksi berhasil";
?>