mysqlsql-serversqlyogmysql-error-1050

Is .sql file different for MySQL and SQL?


I have a .sql file and I want to load it into MySQL database. I don't know from which database (MySQL or MS-SQL) it was created.

Now, I am trying to import that file into MySQL database. It is showing errors while importing and executing that file.

Q1. So, my question is whether the .sql file generated from MySQL and MS-SQL are different?

Note: I am using SQLYog software (graphical interface for MySQL) for importing the file.

Here is the ERROR:

Query: CREATE TABLE ads ( id bigint(20) NOT NULL auto_increment, city_id int(11) NOT NULL, type text collate utf8_bin NOT NULL, town text collate utf8_bin NOT NULL, address text collate utf8_bin NOT NULL, price text collate utf8_bin NOT NULL, info text collate utf8_bin NOT NULL, link text collate utf8_bin NOT NULL, hasImage int(11) NOT NULL, language varchar(2) collate utf8_bin NOT NULL, time_added varchar(255) collate utf8_bin NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1

Error occured at:2009-09-08 17:41:01 Line no.:35 Error Code: 1050 - Table 'ads' already exists

Query: CREATE TABLE ads ( id bigint(20) NOT NULL auto_increment, city_id int(11) NOT NULL, type text collate utf8_bin NOT NULL, town text collate utf8_bin NOT NULL, address text collate utf8_bin NOT NULL, price text collate utf8_bin NOT NULL, info text collate utf8_bin NOT NULL, link text collate utf8_bin NOT NULL, hasImage int(11) NOT NULL, language varchar(2) collate utf8_bin NOT NULL, time_added varchar(255) collate utf8_bin NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1

Error occured at:2009-09-08 17:41:21 Line no.:35 Error Code: 1050 - Table 'ads' already exists

Query: CREATE TABLE ads ( id bigint(20) NOT NULL auto_increment, city_id int(11) NOT NULL, type text collate utf8_bin NOT NULL, town text collate utf8_bin NOT NULL, address text collate utf8_bin NOT NULL, price text collate utf8_bin NOT NULL, info text collate utf8_bin NOT NULL, link text collate utf8_bin NOT NULL, hasImage int(11) NOT NULL, language varchar(2) collate utf8_bin NOT NULL, time_added varchar(255) collate utf8_bin NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1

Error occured at:2009-09-08 17:41:35 Line no.:35 Error Code: 1050 - Table 'ads' already exists

Query: CREATE TABLE ads ( id bigint(20) NOT NULL auto_increment, city_id int(11) NOT NULL, type text collate utf8_bin NOT NULL, town text collate utf8_bin NOT NULL, address text collate utf8_bin NOT NULL, price text collate utf8_bin NOT NULL, info text collate utf8_bin NOT NULL, link text collate utf8_bin NOT NULL, hasImage int(11) NOT NULL, language varchar(2) collate utf8_bin NOT NULL, time_added varchar(255) collate utf8_bin NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1

Error occured at:2009-09-08 17:42:07 Line no.:35 Error Code: 1050 - Table 'ads' already exists

Query: 1 Stanford University 6700 http://www.orkut.co.in . . .


Solution

  • The file extension ".sql" is essentially meaningless: it's just there so that you know what the file is. It will just be a plain text file containing SQL, which you can open in Notepad. Therefore, there's no special "mysql" or "sql server" extensions.

    The errors you're getting there "Table 'ads' already exists" are because you're trying to create a table which already exists in the database. (Did you read the error?) You have a few options:

    1. Change the SQL to this:

      CREATE TABLE IF NOT EXISTS ads ( id bigint(20) ...
      
    2. Change the SQL to this:

      DROP TABLE IF EXISTS ads;
      CREATE TABLE ads (id bigint(20) ...
      
    3. Clear out all the tables in the DB first.