116 reputation
12
bio website
location Pakistan
age 26
visits member for 2 years, 10 months
seen Jul 26 '13 at 0:42

I m a web developer lives in Karachi Pakistan, I works with magento, wordpress ,joomla, ASP.Net, PHP, Client side(JQuery Prototype), ExtJS and Mootools.

I like CakePHP n CodeIgniter for PHP.


Jul
24
awarded  Notable Question
Aug
10
awarded  Popular Question
Nov
4
comment MySQL “server has gone away” using SQLyog
Uncheck "Use Bulk Insert" in sqlyog did the job, thank u Mr.Rolando, Now I don't need to import through dumpsql.sql file, but still the problem exist if someone only have a dumpfile
Nov
4
comment MySQL “server has gone away” using SQLyog
Sorry I never heard anything about -hex blob, I don't know how to implement -hex, I 've created a dump file from the server and now trying to import into my local mysql server
Nov
4
comment MySQL “server has gone away” using SQLyog
MYISAM is used as DBEngine for all tables. it burst b/c of field "option_value" and its type is longtext
Nov
4
comment MySQL “server has gone away” using SQLyog
insert into wp_options(option_id,blog_id,option_name,option_value,autoload) values ('1','0','siteurl','abc.net','yes'),('2','0','blogn…:\"MagpieRSS‌​\":19:{s:6:\"parser\";i:0;s:12:\"current_item\";a:0:{}s:5:\"items\";a:30:{i: ..... Tones of data, around 6803738 character when query just break. See how its merging all insert queries, wp puts everything inside its db
Nov
4
comment MySQL “server has gone away” using SQLyog
thanks, I'm copying it from another DB directing not dumping it through a dumpfile.sql
Nov
4
comment MySQL “server has gone away” using SQLyog
Thanks, I just tried with 512M, 1024M and 2048M, (my machine has 4GB only) but still wp queries r too big for it, [mysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 384M max_allowed_packet = 2048M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M
Nov
4
awarded  Student
Nov
3
asked MySQL “server has gone away” using SQLyog