I've designed new web page for Magic The Gathering Online bot chain called WESTERNBOTS.
If you play MTGO and are looking to buy some cards than check it out.
You may find some common / uncommon sets for very reasonable prices there.
You can go find the site here: http://westernbots.com
2012-12-07
2012-04-26
#2006 - MySQL server has gone away using XAMPP
Today I had to import database into MySQL.
I am running XAMPP version 1.7.7 which includes:
Offending variable is called max_allowed_packet which by default is set to 1 MB.
As I was trying to import database larger than 1 MB I had to change the limit to something larger:
[mysqld]
port= 3306
socket= "D:/xampp/mysql/mysql.sock"
basedir="D:/xampp/mysql"
tmpdir="D:/xampp/tmp"
datadir="D:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 10M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
#bind-address="127.0.0.1"
You have to restart MySQL for changes to take effect.
I am running XAMPP version 1.7.7 which includes:
- Apache 2.2.21
- MySQL 5.5.16
- PHP 5.3.8
#2006 - MySQL server has gone away using XAMPP.The solution was to change MySQL configuration in my.ini file that can be found in xampp folder: xampp\mysql\bin.
Offending variable is called max_allowed_packet which by default is set to 1 MB.
As I was trying to import database larger than 1 MB I had to change the limit to something larger:
[mysqld]
port= 3306
socket= "D:/xampp/mysql/mysql.sock"
basedir="D:/xampp/mysql"
tmpdir="D:/xampp/tmp"
datadir="D:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 10M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
#bind-address="127.0.0.1"
You have to restart MySQL for changes to take effect.
2012-02-04
Przekierowanie 301 za pomocą pliku .htaccess
Aby przekiwerować cały ruch z jednej domeny na drugą wystarczy na serwerze ze starą domeną w pliku .htaccess umieścić:
Po wstawieniu zaś do pliku .htacces następującego kodu:
Options +FollowSymLinks
RewriteEngine on
RewriteRule (.*) http://www.newdomain.com/$1 [R=301,L]
Po wstawieniu zaś do pliku .htacces następującego kodu:
Options +FollowSymlinks
RewriteEngine on
rewritecond %{http_host} ^domain.com [nc]
rewriterule ^(.*)$ http://www.domain.com/$1 [r=301,nc]
przekierujemy wszystkie wywołania domena.com na www.domena.com
Subskrybuj:
Posty (Atom)