rev.dennis Posted August 11, 2014 Share Posted August 11, 2014 Okay, my experience on exporting and importing mySQL Database Exporting (Pretty Easy) [root@ipsetest ~]# mysqldump -u root -p oaipse > oaipse.sql Importing (not too bad but learned a couple of things) [root@ipseweb ~]# mysql -u root -p oaipse < oaipse.sql Enter password: ERROR 1153 (08S01) at line 732: Got a packet bigger than 'max_allowed_packet' bytes To fix ERROR 1153 perform the following otherwise your database imported successfully. [root@ipseweb ~]# mysql -u root -p Enter password: mysql> set global net_buffer_length=1000000; mysql> set global max_allowed_packet=1000000000; mysql> exit Rerun the import command as noted above before error Verify your database imported [root@ipseweb ~]# mysqlshow -u root -p Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now