1 Topic by peter81

  • peter81
  • Member
  • Offline

Topic: Database empty error

I am new to the forum so apologize if my questions are out of context here. I have setup the Labstore as per instructions, set up a new database named labstock, and placed the labstore.sql in the folder created in MySQL data. I can open the main pages index.php and admin.php without errors. In myPHPadmin I created the labstock database, but when I try to import the file labstock.sql to populate the database appears the following error:

Error

SQL-query :

SET NAMES utf8

MySQL says:

You have an error in your SQL syntax near 'NAMES utf8' at line 1

Any suggestions welcome.
Thanks in advance

2 Reply by testly

  • testly
  • Member
  • Offline

Re: Database empty error

The 'set names utf8' line may cause problems on MySQL versions older than 4.1 (not exactly sure of the version number). It is very likely that your .sql import will work fine once you delete that line.