Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Mar 2008, 17:34
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
Error when trying to restore my database

i'm getting this error code:

#1005 - Can't create table './*******_vbulletin/boxmail.frm' (errno: 150)
And this is the SQL consult:

CREATE TABLE `boxmail` (
`id_mail` int( 6 ) NOT NULL AUTO_INCREMENT ,
`id_group` int( 4 ) NOT NULL default '0',
`mail` varchar( 50 ) NOT NULL default '',
PRIMARY KEY ( `id_mail` ) ,
UNIQUE KEY `mail` ( `mail` ) ,
KEY `id_group` ( `id_group` ) ,
CONSTRAINT `boxmail_ibfk_1` FOREIGN KEY ( `id_group` ) REFERENCES `groupfull` ( `id_group` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
WTF is happening? can you help me
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
  #2  
Old 13 Mar 2008, 17:36
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Post the full error
Reply With Quote
  #3  
Old 13 Mar 2008, 17:42
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
Here it's an image of what i'm getting



I used to have the hosting on 3ix.com (very bad one) and i'm uploading it to Hostmonster.com, i have already restores a few tables, but this one is give me error.
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
  #4  
Old 13 Mar 2008, 17:49
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Try removing the key's, then run it again.
Reply With Quote
  #5  
Old 13 Mar 2008, 17:50
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
i'm a newby on this things, do i need just to delete the line about the keys, or just the phrase:

FOREIGN KEY ( `id_group` )
thanks
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
  #6  
Old 13 Mar 2008, 18:42
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Yes, try removing just the foreign key and run it again, if it dont work go key by key.
Reply With Quote
  #7  
Old 13 Mar 2008, 18:46
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
MySQL error code 150: Foreign key constraint is incorrectly formed

This is not a vBulletin table, vBulletin doesn't use any foreign key constraints.

Are you restoring to the same MySQL version as the backup was made on? If not, what are the versions?

Most likely cause is that this is a foreign key constraint and the foreign table (groupfull) has not been restored yet, so the constraint can not be created.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #8  
Old 13 Mar 2008, 18:53
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
i used to work with an older version of php, and the database that i'm uploading is generated by vbulletin, on the older server.

so, can i erase the table then?
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
  #9  
Old 13 Mar 2008, 18:56
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
PHP version is not relevant. MySQL versions are.

I don't know if you can drop the table, it is not a vBulletin table, looks like something to do with a mail application.

Also how was the backup create?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #10  
Old 13 Mar 2008, 18:59
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
Yeah sorry, i mean the sql also was the older one

it was created by the asistant of the vbulletin admincp backup

can i have your personal email so i can have more help from you?
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
  #11  
Old 13 Mar 2008, 19:33
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Do you still have access to the old server, if so please give the exact MySQL versions old the new and old server. Also do you have shell access on both servers and is there a control panel (like cPanel) installed on these servers?

PS No i don't give out my email.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #12  
Old 13 Mar 2008, 20:59
kurtmorrison's Avatar
kurtmorrison kurtmorrison is offline
 
Join Date: Oct 2007
Real name: Oswaldo
Hey, i could fix the problem manually, i had to copy/paste more than 20mb of info jajaja my pc was about to die xD

now i just have a problem with dinamic url, i'll fix that soon, thank you all!
__________________
Tijuiliando.com - Taller & Racing Team
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 11:11.

Layout Options | Width: Wide Color: