I need your help guys! My client purchased Links SQL. Now he wants a directory of local businesses ala Yellow Pages. He is going to get his staff to create the various categories offline and then wants to import the database.
I've been trying to import a test database using the MySQL load commands posted by pugdog a while ago. This is what I tried:
LOAD DATA LOCAL INFILE '/u/web/free66/cgi-local/directory/admin/cattest.txt' REPLACE INTO TABLE Category.Links FIELDS TERMINATED BY '|' (ID,Name,Description,Meta_Description,Meta_Keywords,Header,Footer,Number_of_Links,Has_New_Links,Has_Changed_Links,Newest_Link)
All I get is an access for user denied error. I tried another MySQL command I found in a post in order to change permissions, but that didn't work.
I then contacted the hosting company. First they said "the ability to import text files into MYSQL has been disabled. This is due to a stability issue of importing invalid data into the sql server." omg - so I tell em not to be so stupid and now they have pointed me to a MySQL Monitor script on the hosting control panel. The load command doesn't work in that either.
Please can someone check the above command.
This is an extract from the cattest.txt file:
ID|Name|Description|Meta_Description|Meta_Keywords|Header|Footer|Number_of_Links|Has_New_Links|Has_Changed_Links|Newest_Link
1|Surrey||Directory of businesses in the Surrey area of the UK.|Surrey, reading|||2|No|No|1999-01-01
2|Sussex||Directory of businesses in the Sussex area of the UK|Sussex|||0|No|No|1999-01-01
Why doesn't the Import data function in the Links Admin Menu work??
I've been trying to import a test database using the MySQL load commands posted by pugdog a while ago. This is what I tried:
LOAD DATA LOCAL INFILE '/u/web/free66/cgi-local/directory/admin/cattest.txt' REPLACE INTO TABLE Category.Links FIELDS TERMINATED BY '|' (ID,Name,Description,Meta_Description,Meta_Keywords,Header,Footer,Number_of_Links,Has_New_Links,Has_Changed_Links,Newest_Link)
All I get is an access for user denied error. I tried another MySQL command I found in a post in order to change permissions, but that didn't work.
I then contacted the hosting company. First they said "the ability to import text files into MYSQL has been disabled. This is due to a stability issue of importing invalid data into the sql server." omg - so I tell em not to be so stupid and now they have pointed me to a MySQL Monitor script on the hosting control panel. The load command doesn't work in that either.
Please can someone check the above command.
This is an extract from the cattest.txt file:
ID|Name|Description|Meta_Description|Meta_Keywords|Header|Footer|Number_of_Links|Has_New_Links|Has_Changed_Links|Newest_Link
1|Surrey||Directory of businesses in the Surrey area of the UK.|Surrey, reading|||2|No|No|1999-01-01
2|Sussex||Directory of businesses in the Sussex area of the UK|Sussex|||0|No|No|1999-01-01
Why doesn't the Import data function in the Links Admin Menu work??