#1005 - Can't Create Table 'xxxx_Xx.xxxx' (Errno: -1)

[Louis53]

Hi,

 

I have a problem I had a database hosted locally(on my computer) but than I wanted to host a website using a database and I found your site who has remote mysql access(thx god) so I dump my sql files from my old database.It has 51mb so I compressed in gzip using the format xxxx.sql.gz. It has now 4mb.So I started uploading it in phpmyadmin. Some tables works but some returned me these errors:

 

#1005 - Can't create table 'louis53_bd.quests' (errno: -1)(details...)

#1005 - Can't create table 'louis53_bd.full_morphs' (errno: -1) (Détails...)

 

and some others errors

 

 

When I clicked details to see why is this error from it brought me to InnoDB Status!It has no errors or no indications!

 

So guys I need your help to resolve it!

 

Louis53

[Louis53]

help?

[wolstech]

Innodb is hosed on Johnny now as well as Stevie. In fact, Johnny's MySQL reportedly has problems with myisam too...

 

Best solution to guarantee it'll work is to move to Stevie and convert the database to myisam.

[Louis53]

How can I move to stevie(and thanks by the ways I really appreciate )

[wolstech]

http://wiki.helionet.org/Moving_your_account

 

When creating the stevie account, registration opens everyday at midnight pacific time.

[Louis53]

I got this while trying to delete my account: We're sorry, but we either could not find that account in the database, or it is not listed as active. Please contact an administrator if you feel this message is in error.

[wolstech]

What is your username?

[Louis53]

Louis53(Thx you are really helping me but Steve registration are close D:)

[wolstech]

It doesn't exist as far as I can see...try signing up for Stevie when you can.

[Louis53]

ok thx maybe it is already deleted

[wolstech]

Re: DNS issues...I moved that here, separate issue: http://www.helionet.org/index/topic/19871-remove-dns-entries/

 

An admin needs to fix that.

[Louis53]

kk thx

 

But maybe they wont know the original problem if they dont read this before reading the new one!

[wolstech]

They're fixing the DNS issue, which many people have after they delete an account. I separated them so they don't get confused and miss the DNS problem. They often leave topics with tons of replies to last since someone is already helping them.

[Louis53]

Should I delete serveurwaros@heliohost.org while they fix the dns issues

[wolstech]

No. It shouldn't exist anyway since creation failed.

 

If you tried again and it worked, then the DNS issue is no longer a problem and you can just use your new account normally.