Skip to content
Indra Chaidir, M.Kom

Indra Chaidir, M.Kom

Share Anything & Learning by doing

  • Home
  • Curriculum Vitae
  • Articles
    • Software
    • Linux
    • PHP
    • MySQL
    • Techno
    • Java
    • Yii2 Framework
    • Git
    • IT Study
    • Gadget
  • Galeri
    • Jam Gadang Bukittinggi

Restore

Backup & Restore database which have text with single quotes (‘) not escaped (”)

September 15, 2022January 26, 2022 by Indra

Cara backup database yang memiliki single/double quotes (‘) pada sebuah kata yaitu menggunakan character set UTF8.

[apps@server ~]$ mysqldump -u root -p --default-character-set=utf8 db_name > db_name.sql

Read more

Categories Linux, MySQL Tags Backup, Database, Linux, MySQL, mysqldump, Query, Restore, SQL

 

Recent Posts

  • Cara Mengganti Zona Waktu Server ke WIB
  • Menambah Parameter Pada URL Pagination Yii2
  • Menambahkan .gitignore ke dalam existing Repository
  • Cara Buat Service di Linux
  • Backup & Restore database which have text with single quotes (‘) not escaped (”)
  • [Solved] : XAMPP Port 80 in use by “Unable to open process” with PID 4
  • Cara Mengubah Port SSH pada CentOS
  • CentOS : Cara Upgrade dari PHP 5.1.x ke PHP 5.3
  • Cara Membuka Port di Firewall Linux CentOS
  • Force Monitor Resolution on Ubuntu 10.10

© 2026 Indra Chaidir, M.Kom • Built with GeneratePress