I was trying to import Sakilla database and ran into some problem and would be grateful if someone could help me out please.
I ran the following command successfully :
/usr/local/zend/mysql/bin/mysql -u root -p < sakila-schema.sql
but When I ran this command :
/usr/local/zend/mysql/bin/mysql -u root -p < sakila-data.sql
I got an error after typing my password :
ERROR 1436 (HY000) at line 81: Thread stack overrun: 5752 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.
I tried running it a second time and I got the following output :
ERROR 1062 (23000) at line 26: Duplicate entry '1' for key 'PRIMARY'
Once again I would be grateful if you could help me out please.
you need to :
login : /usr/local/zend/mysql/bin/mysql -u root -p
and then issue the command :
then go to your Zend Community Server installation, which comes with a default my.cnf file in which the thread_stack size was set to 128K, and comment out the line in /usr/local/zend/mysql/data/my.cnf, restart the mysql daemon, and vwalah!!! the default is 192K