Database: Difference between revisions

From Server STB
Jump to navigation Jump to search
(Created page with "mysqldump -u database_username -p database_name > /home/cpanel_username/backup/backup_satu_database.sql")
 
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
mysqldump -u database_username -p database_name > /home/cpanel_username/backup/backup_satu_database.sql
<h3>Backup</h3>
 
mysqldump -u database_username -p database_name > /home/cpanel_username/backup/backup_satu_database.sql
 
 
<h3>Docker</h3>
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";
?>

Latest 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";
?>