CiviCRM Community Forums (archive)

This may help you in the first instance: http://wiki.civicrm.org/confluence/display/CRMDOC33/Moving+an+Existing+Installation+to+a+New+Server+or+Location

But there may be further issues regarding standalone to Drupal, which I'm sure other people will help with.

Just wanted to give you a (very useful) starting off point to help solve your problem.

Best,

RJB

I've tried this way:
1. i've installed a fresh copy of Drupal, after creating db named 'drupal_1'
2. i've just loaded CiviCrm as an extension, following the ordinary installation instructions
3. i0ve tried to import the db from phpmyadmin to 'drupal_1'

But, unfortunately, I get this message:


Errore
query SQL:

-- -- Database: `civicrm` -- -- -------------------------------------------------------- -- -- Struttura della tabella `civicrm_acl` -- CREATE TABLE `civicrm_acl` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID', `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ACL Name.', `deny` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is this ACL entry Allow (0) or Deny (1) ?', `entity_table` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)', `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'ID of the object possessing this ACL', `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke','Search') COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?', `object_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'The table of the object controlled by this ACL entry', `object_id` int(10) unsigned DEFAUL[...]

Messaggio di MySQL:

#1050 - Table 'civicrm_acl' already exists


I've even tried to install a fresh standalone on the db 'civicrm_1' (being 'civicrm' db the one from which I've made the data backup)
and then loaded the 'civicrm' backup to 'civicrm_1', but it's not working yet.

I really can't wonder why, it's odd: I try to log in via myopenid but it's like something is badly broken.

Maybe I should try to install a fresh mamp -> fresh drupal -> fresh civicrm -> backup data?

Hershel,

I've tried adding the 'drop table' function to the db export,
but now after importing (to another standalone installation) I get this error message:


Errore
query SQL:

--
-- Database: `civicrm`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `civicrm_acl`
--
DROP TABLE IF EXISTS  `civicrm_acl` ;

Messaggio di MySQL:

#1217 - Cannot delete or update a parent row: a foreign key constraint fails


Any other suggestion?
Gosh, I f****n' need my data back!!! 

Now also check off "Disable foreign key checks" when you do the dump (presuming you are using phpMyAdmin) and that should fix that error.

I tried and it worked, importing was successful! Many thanks, Hershel!

Unfortunately, at log in the fresh Standalone installation gives me back

"Unknown status returned."

and the Joomla (I've tried importing to it too) returns

OpenID authentication failed: Bad signature
Sorry. A non-recoverable error has occurred.
DB Error: no such field

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'is_deleted' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

=> -19
   

[message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  id, is_deleted 
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id, is_deleted 
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, is_deleted 
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' in 'field list']"]




What else can I add?

When I created the various db and installed the various CiviCrm (both the old and new standalone, and for the new joomla and the new drupal)
I've always used the same user and password during the various installation processes.
 
Maybe is it somehow related to this?

I don't understand a thing about where the REAL problem maybe,
but it sounds to me that there's something broken about my OpenId account, which is the user I used everytime to access CiviCrm and so to build the db I'm trying to restore. It's something like the user is 'stored' inside that db and that it is no longer recognized as the one with the permissions to access.

Maybe I'm just terribly wrong, but, really I can't imagine what's going on!

Your help would really be appreciated,
and I thank you a lot for alla the support you've already given!