vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello! I have tried to upload mysql database to xampp portable server (PHP + MySQL). I have used such code: mysql -u XXXX -p DB < c:\mysql_db_saved_file.sql (file size is: 14,1 MB) Unfortunately I got such error: ERROR 2006 (HY000) at line 19609: MySQL server has gone away I have read in documentation that I should set huge limit in wait_timeout parameter. [mysqld] port= 3306 socket= "I:/xampp/mysql/mysql.sock" basedir="I:/xampp/mysql" tmpdir="I:/xampp/tmp" datadir="I:/xampp/mysql/data" skip-locking key_buffer = 36M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 16M wait_timeout=9999999999999999 I set up wait_timeout but unforutnately it haven`t solved my problem and I still get the same error message. I don`t know what it is going on. Could you help me? What should I do more not to get the error? Thank you in advance for help K. |