pixeltrace Posted September 5, 2007 Share Posted September 5, 2007 hi, i need help, i hava a DB backup that i need to dump into our new server and the size is 2.6GB i know that in mysql 5 the max load is only 1GB my problem now is whenever i am using shell> mysql -p -h localhost database < database.sql i am getting this error ERROR 1153 (08S01) at line 33: Got a packet bigger than 'max_allowed_packet' bytes i need to know what other options i can use so i can import the database hope you could help me with this. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/68007-how-to-split-database/ Share on other sites More sharing options...
pixeltrace Posted September 5, 2007 Author Share Posted September 5, 2007 hi, any updates on this? i tried using shell> split -b 32000000 database.sql and shell> split -l 400 database.sql the database was split but i dont know how to import them to mysql. hope you could help me with this. thanks so much! Quote Link to comment https://forums.phpfreaks.com/topic/68007-how-to-split-database/#findComment-341977 Share on other sites More sharing options...
effigy Posted September 5, 2007 Share Posted September 5, 2007 Does LOAD DATA give you the same problem? Quote Link to comment https://forums.phpfreaks.com/topic/68007-how-to-split-database/#findComment-342078 Share on other sites More sharing options...
pixeltrace Posted September 6, 2007 Author Share Posted September 6, 2007 hi, yes load data is giving me the same problem any other solution? thanks! Quote Link to comment https://forums.phpfreaks.com/topic/68007-how-to-split-database/#findComment-342618 Share on other sites More sharing options...
effigy Posted September 6, 2007 Share Posted September 6, 2007 How about just increasing the max, as stated here? Quote Link to comment https://forums.phpfreaks.com/topic/68007-how-to-split-database/#findComment-342997 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.