Mysql Socket Errors

[altera]

I'm trying to upload a database for my website (I know my database isn't corrupted because I can upload it on other sites), whenever I do so the upload cuts off and I get a

 

"#2002 - can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2) the server is not responding (or the local server's socket is not correctly configured)."

 

aswell as it says the table its trying to upload doesn't exist, even though it does?

 

Error

SQL query:

 

-- --------------------------------------------------------

--

-- Table structure for table `reputation`

--

CREATE TABLE IF NOT EXISTS `reputation` (

 

`UserID` TEXT NOT NULL ,

`GivenIP` VARCHAR( 100 ) NOT NULL ,

`GivenID` TEXT NOT NULL

) ENGINE = INNODB DEFAULT CHARSET = latin1;

 

MySQL said: Documentation

 

#1146 - Table 'altera_main.reputation' doesn't exist

 

Does anybody know how to fix this?

[wolstech]

Change the Engine=InnoDB to Engine=MyISAM in that sql statement and it'll work. We do not support innodb.

 

Also, see http://www.helionet.org/index/topic/18875-stevie-mysql-common-questions-and-problems/

[altera]

I tried that, still got the same error, replaced all the Engines to what you said and same error.

[wolstech]

Try it in a fresh database. You likely created a phantom table when you first tried and failed...

 

Also, remove the 'if not exists' from the create table statement.