遨遊飛翔

學習筆記 For php、jQuery、MySql、Centos、Suse、Server、CodeIgniter

Main menu

Skip to primary content
Skip to secondary content
  • 首頁

Category Archives: MySQL

Mysql backup to Dropbox

Posted on 二月 14, 2011 by shian
Reply
Share

先前介紹過安裝Dropbox於centos中後,接下來我們可以把一些資料備份的dropbox裡面,本篇將介紹備份Mysql資料於Dropbox裡,方式相當的簡單容易。

Continue reading →

Posted in MySQL, 隨手記 | Tagged MySQL | Leave a reply

MySql Report – Replication Error

Posted on 四月 26, 2010 by shian
Reply
Share

之前公司的mysql有做 Mysql Replication,所以把一些常發生的錯誤以及發生斷線(沒同步)時,要如何處理以及建議改善的簡易評估報告。

Continue reading →

Posted in MySQL | Tagged MySQL | Leave a reply

MySQL Query Cache

Posted on 一月 18, 2008 by shian
1
Share

MySQL 也有 cache可以使用! 提高資料庫效能有很重要的效用,可以節約大量的 CPU 時間 ,並且設定也非常的簡單,但是MySQL的版本要4以上才有這功能!!

Continue reading →

Posted in MySQL | Tagged centos, Linux, MySQL | 1 Reply

Mysql 5.1.22 Replication Master to Slave

Posted on 一月 15, 2008 by shian
Reply
Share

Mysql 5.1.22 Replication Master to Slave

Continue reading →

Posted in MySQL | Tagged centos, Linux, MySQL | Leave a reply

Tarball MySQL

Posted on 十一月 23, 2007 by shian
Reply
Share

安裝MySQL有很多方式,像是 CENTOS的YUM或是SUSE的YAST2,或是下載RPM來安奘,
但是為了想要讓MySQL預設的編碼為UTF-8,所以就自己用Tarball的方式來安裝

Continue reading →

Posted in MySQL | Tagged Linux, MySQL | Leave a reply

分類

  • CodeIgniter (12)
  • CSS (4)
  • javascript (1)
  • jQuery (10)
  • Linux (27)
  • MongoDB (6)
  • MySQL (5)
  • Node.js (4)
  • PHP (8)
  • works (10)
  • 隨手記 (5)

近期文章

  • less 規劃使用配置
  • less 基本介紹
  • Linode Facilities Speedtest
  • install less
  • node.js forever
  • Long Polling in node.js
  • node.js connection mysql
  • centos install node.js
  • Apache install mod_fastcgi & php-fpm
  • Mysql backup to Dropbox
  • centos install dropbox
  • ipflow
  • CSS Selectors
  • CodeIgniter Facebook Librarie
  • Codeigniter Compress HTML
  • Flash Game – Cathaylife
  • Flash Game – deltamac
  • Flash Game – ZESPRI
  • CodeIgniter QUERY STRING GET
  • Nginx Virtual Host
Proudly powered by WordPress