Mar
24
2010
MySQL “Can’t create table” error fix for WAMP
This is a post for the MySQL geeks out there, and also for anyone who had a similar problem and might be searching for a solution.
I was trying to copy our testing server’s database to my local machine, so I can do some local development (I’ve set up a web server and database on my personal computer, so that I can test things out before moving them to the development server). I’m using WAMP for that, which is a very simple way to set up a local webserver on Windows.
Well, when I tried to import the database I got the following error:
Error Code: 1005 - Can't create table 'whatever' (errno: 121)
So I edited my.ini, and increased max_allowed_packet, like so:
[mysqld] max_allowed_packet=32M
I’ve heard that some other people have also had to increase wait_timeout to something like 45 seconds to fix this error.