MySQL Forums
Forum List  »  InnoDB

Can't connect to local when running "source multiple_sectors_lookup.sql;"
Posted by: Andrew Johnstone
Date: October 27, 2008 07:30AM

Hi Can anyone explain the following?

This causes the following every time (The file to import is 7.2M):
source multiple_sectors_lookup.sql;

No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR: Can't connect to the server

CREATE TABLE `multiple_sectors_lookup` (
`multiple_sectors_lookup_id` bigint(20) NOT NULL auto_increment,
`multiple_sectors_id` int(11) default NULL,
`users_id` int(11) NOT NULL default '0',
`organisations_id` int(11) NOT NULL default '0',
`forward_features_id` int(11) NOT NULL default '0',
`section` enum('FREELANCE','PRESS_RELEASES','FORWARD_FEATURES','MEDIA_REQUESTS','SPOKESPEOPLE','STUDENT','MEDIA') NOT NULL default 'PRESS_RELEASES',
`press_releases_id` int(11) NOT NULL default '0',
`media_requests_id` int(11) NOT NULL default '0',
`spokespeople_id` int(11) NOT NULL default '0',
PRIMARY KEY (`multiple_sectors_lookup_id`),
KEY `user` (`users_id`),
KEY `section` (`section`),
KEY `sector` (`multiple_sectors_id`),
KEY `press_releases_id` (`press_releases_id`),
KEY `mr` (`media_requests_id`)
) ENGINE=InnoDB AUTO_INCREMENT=242519 DEFAULT CHARSET=latin1

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't connect to local when running "source multiple_sectors_lookup.sql;"
2397
October 27, 2008 07:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.