Database: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 6: | Line 6: | ||
<h3>Docker</h3> | <h3>Docker</h3> | ||
docker run -d -p 3388:3306 --name db_record -e MYSQL_ROOT_PASSWORD=4rt1s4n -v /DATA/record:/var/lib/mysql mysql | docker run -d -p 3388:3306 --name db_record -e MYSQL_ROOT_PASSWORD=4rt1s4n -v /DATA/record:/var/lib/mysql mysql | ||
<h3>PHP</h3> | |||
<?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"; | |||
?> |
Revision as of 06:51, 20 June 2024
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"; ?>