Bug #72374 Cannot import sql file in my database through phpmyadmin

Submitted: 17 Apr 2014 20:36 Modified: 18 May 2014 18:30
Reporter: Rohit Patil Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:MySQL Community Server 5.6.10 OS:Windows (8.1)
Assigned to: CPU Architecture:Any
Tags: Troubleshooting tablespace error while importing sql file

[17 Apr 2014 20:36] Rohit Patil
Description:
I am getting this below Error while importing the sql file:
#1813 - Tablespace for table '`jobsite`.`jobberland_admin`' exists. Please DISCARD the tablespace before IMPORT. 

Below is the exact error description which I am getting:

Error
SQL query:

--
-- Database: `jobtemp`
--
-- --------------------------------------------------------
--
-- Table structure for table `jobberland_admin`
--
CREATE TABLE IF NOT EXISTS  `jobberland_admin` (

 `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `username` VARCHAR( 16 ) NOT NULL ,
 `passwd` VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;

MySQL said: Documentation

#1813 - Tablespace for table '`jobsite`.`jobberland_admin`' exists. Please DISCARD the tablespace before IMPORT. 

I want to import sql file but cannot do it due to this error Please help me solving this problem I tried a lot to troubleshoot it but its not working

Thank You

How to repeat:
Please give me feedback me through my Email ID: rohitp777@gmail.com

Suggested fix:
Troubleshooting tablespace error while importing sql file, And Corrupted table Error due to which mysql server is getting lost
[18 Apr 2014 18:30] Sveta Smirnova
Thank you for the report.

Please provide output of SHOW TABLES FROM jobsite, SHOW VARIABLES LIKE 'innodb_file_per_table' and output of `dir MYSQL_DATADIR\jobsite`
[19 May 2014 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.