How to Import .SQL Dump File into MySQL
Posted by Wing on 26 May, 2009
No comments yet
Go to Command Line Client \. C:\yourSQLfile.sql
Posts Tagged ‘Mysql’
Speed up Your WordPress Blog
Posted by Wing on 30 December, 2008
This item was filled under [ Wordpress ]
http://www.earnersblog.com/digproof-your-wordpress/ http://www.arnebrachhold.de/2007/02/16/four-plus-one-ways-to-speed-up-the-performance-of-wordpress-with-caching/ Install the Wp-Cache 2.10 Plugin WP-Cache 2.10 will cache a physical copy of each post into a specified folder on your server. Since WordPress usually serves content dynamically it has to query mysql everytime it goes to load a post. If you get dugg you’ll end up with an insane amount of mysql [...]
Creating MySQL Backups With AutoMySQLBackup
Posted by Wing on 4 November, 2008
Refer to: http://www.howtoforge.com/creating-mysql-backups-with-automysqlbackup 1. Using AutoMySQLBackup You can download AutoMySQLBackup as follows: cd /usr/local/bin wget http://mesh.dl.sourceforge.net/sourceforge/automysqlbackup/automysqlbackup.sh.2.5 Then open automysqlbackup.sh.2.5 and take a look at the configuration options. They are all well explained. You should at least configure the following settings: vi automysqlbackup.sh.2.5
Lighttpd with php
Posted by Wing on 29 October, 2008
yum install lighttpd-fastcgi vi /etc/lighttpd/lighttpd.conf server.modules = ( “mod_fastcgi”, ) fastcgi.server = ( “.php” => (( “bin-path” => /usr/bin/php-cgi”, “socket” => “/tmp/php.socket” ))) Reference http://redmine.lighttpd.net/wiki/lighttpd/TutorialLighttpdAndPHP http://www.howtoforge.com/lighttpd_php5_mysql_centos5.0
Crossgate私服架設
Posted by Wing on 23 August, 2008
This item was filled under [ Game ]
作業系統: RHEL AS4 x86 需要元件: mysql-server 4.1.20 準備工作: YUM for RHEL4 下載這個檔案 tar -zxvf yum.tgz cd yum rpm -ivh *.rpm rm -f /etc/yum.repos.d/* 下載這個檔案 tar -zxvf yum_repos_rhel4.tar.gz -C /etc/yum.repos.d/ Mysql server yum install -y mysql-server phpmyadmin 到http://www.phpmyadmin.net/下載 tar -zxvf phpmyadmin-xx-xx.tar.gz -C /var/www/html/ cd /var/www/html ln -s phpmyadmin-xx-xx phpmyadmin yum -y install php-mysql /etc/init.d/httpd start http://[ip]/phpmyadmin/ [...]
