Results 1 to 2 of 2
Thread: MySQL ERROR 1436 & ERROR 1062
May 13, 2012, 05:23 #1
- Join Date
- Jun 2010
- 0 Post(s)
- 0 Thread(s)
MySQL ERROR 1436 & ERROR 1062
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
/usr/local/zend/mysql/bin/mysql -u root -p < sakila-data.sql
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.
May 13, 2012, 12:05 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 59 Post(s)
- 3 Thread(s)
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