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

Database

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 cobit Codeigniter Console Database Framework git linkpage Linux listview MySQL mysqldump OOP pagination PHP Query repository Restore service Services SQL systemctl systemd Webserver yii2

Recent Posts

  • 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

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

© 2023 Indra Chaidir • Built with GeneratePress