Skip to content
Indra Chaidir

Indra Chaidir

Share Anything & Learning by doing

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

Query

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

ActiveDataProvider Apache Backup centos cobit Codeigniter Console Database Framework git linkpage Linux listview MySQL mysqldump OOP pagination PHP Query repository Restore service Services SQL systemctl systemd timezone ubuntu Webserver yii2

Recent Posts

  • Change Time Zone in Linux Terminal
  • 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 (”)

Recent Comments

  • andre on Codeigniter : Function set_magic_quotes_runtime() is deprecated
  • Lintang on Membuat halaman login Webmail di Webhosting
  • satria on CentOS : Cara Upgrade dari PHP 5.1.x ke PHP 5.3
  • heri susanto on PHP 4 vs PHP 5
  • batikanggun on Membuat halaman login Webmail di Webhosting

© 2026 Indra Chaidir • Built with GeneratePress