Thank you Bryan O'Neal, Amit Nepal, and Todd Millecam!! I was able to
import the data and the app is running!!
On 2014-12-04 20:46, Todd Millecam wrote:
Net buffer, probably not, max_packet, it'd be a good idea to tune it
to your hard-drive+cache speed, which is typically about 120MB, unless
your database is on NAS hardware, in which case it can be as high as
6.5GB.
On Thu, Dec 4, 2014 at 7:20 PM, Keith Smith
<[email protected]> wrote:
Amit,
Your commands seem to have worked - thank you!!
Do I need to set :
1) global net_buffer_length=1000000;
2) global max_allowed_packet=10000000000000;
to some lesser value?
Any way it is detrimental to leave at these values as set?
Thanks!!
Keith
On 2014-12-04 17:22, Amit Nepal wrote:
You can just change the value of max packet for that session and
import the file . This article might be helpful .
http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
[1]
[2]
Thanks
Amit K Nepal
Chief Information Officer
(RHCE, CCENT, C|EH, C|HFI, GIAC ISO 27000 Specialist)
omNovia Technologies Inc. On 12/4/2014 3:47 PM, Bryan O'Neal
wrote:
1) Max allowed packet is usually a replication not an important
error. It can be described as a "I can not find the information it
is looking for inside my search window" error.
2) It is more often associated with corruption then a true packet
size error. It also occasionally manifests when moving from 64 to
32
bit. But it is possible that it is just a max packet problem
3) using the client is more direct and less prone to error then
using PHP my admin
On Dec 4, 2014 2:34 PM, "Keith Smith" <[email protected]>
wrote:
Hi,
I'm trying to import a file into MySql on CentOS 6.6 and mysql
Server version: 5.1.73.
Un compressed the file is 611,285,457b or about 610MB. This is
a production server and I am concerned about setting PHP
upload_max_filesize that large.
I tried to import via the command line and that failed. Tried
uploading as a gz via PhpMyAdmin... that failed also. And I
surely do not want to increase the memory allotted to PHP...
I tried this:
mysql --max_allowed_packet=650M -u root -p database < data.sql
And received this error : ERROR 1153 (08S01) at line 1370225:
Got a packet bigger than 'max_allowed_packet' bytes
Thanks in advance!! Any suggestions?
Keith
--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2] [1]
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2] [1]
Links:
------
[1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
[2]
http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
[1]
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
--
Todd Millecam
Links:
------
[1]
http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
[2] http://lists.phxlinux.org/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss
--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss
