Jump to content

Recommended Posts

Posted

I need help, I cant create table in my DB.

I get error SQL message:

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

 

How shoudl I discard it?

Thx!

 

Probably this could help me

 

"This works for me, but I use this in local server.

Open the directory where xampp is installed, for example

C:/xampp/mysql/data/...

Select the folder (it's like a database name) of the tablespace that you want to remove, then delete the file with extension idb. Delete only one file corresponding to the table that you want to create/remove.

In my case my file is karyawan.idb,

Hope this works for you."

 

but how to do it I am not local server admin.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...