Jooglar Logo
 Pathway : Home arrow Forum
Register. Lost Password?
Home
Download
Products
Help & Support
Sitemap
Other
 
 
Jooglar Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottom Post Reply Favoured: 0
TOPIC: Cannot restore database !
#496
STILLMAN (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Cannot restore database ! 2 Months, 1 Week ago  
Hi everybody,

First, thank you for your usefull product !

Actually, I have a big problem for restoring my database on my localhost.

Let me explain :

I run Virtual Newspaper Manager on Joomla 1.5.3 and it works well so far.
I make regular backup of the website and my database with Joomlapack 1.2.2 (stable).

I want to backup the entire website, to be able to work on my localhost.
I follow the restoration step by step but I get stuck with the restoration of my database, both with joomla pack or individually with phpmyadmin.
Of course Innodb is actived on localhost.

When I imported the database with php 5.1.6? I get the following message :

Erreur

requête SQL:

CREATE TABLE `jos_periodico_categoria_regla` (
`IDCaRe` int( 11 ) NOT NULL AUTO_INCREMENT ,
`IDCategoria` int( 11 ) default NULL ,
`IDRegla` int( 11 ) default NULL ,
PRIMARY KEY ( `IDCaRe` ) ,
UNIQUE KEY `IDCategoria` ( `IDCategoria` , `IDRegla` ) ,
KEY `IDRegla` ( `IDRegla` ) ,
KEY `IDCategoria_2` ( `IDCategoria` ) ,
CONSTRAINT `jos_periodico_categoria_regla_ibfk_1` FOREIGN KEY ( `IDRegla` ) REFERENCES `jos_periodico_regla` ( `IDRegla` ) ON DELETE CASCADE ,
CONSTRAINT `jos_periodico_categoria_regla_ibfk_2` FOREIGN KEY ( `IDCategoria` ) REFERENCES `jos_periodico_categoria` ( `IDCategoria` ) ON DELETE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =54 DEFAULT CHARSET = utf8;

MySQL a réponduocumentation
#1005 - Can't create table '.******jos_periodico_categoria_regla.frm' (errno: 150)

Can you help me please to solve this problem.

Greatfull thanks !!!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#512
garyedwardjohnston (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Re:Cannot restore database ! 1 Month, 3 Weeks ago  
Have no idea but I think you should try the JoomlaPack forum or Joomla forum itself.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply