CiviCRM Community Forums (archive)

I had a Windows installation of CiviCRM on Drupal and have just set up a server with Linux and installed Drupal and CiviCRM on that. I wanted to import the database that I had on the Windows install and import that to the Linux install. I tried but I am getting the following error:

Error

SQL query:

--
-- Database: `civicrm`
--
-- --------------------------------------------------------
--
-- Table structure for table `civicrm_acl`
--
DROP TABLE IF EXISTS `civicrm_acl` ;

MySQL said: Documentation
#1217 - Cannot delete or update a parent row: a foreign key constraint fails
Any thoughts on what I might be doing wrong?

Thanks,
Todd

I tried that. I dropped the table, created another, and did a successful import. When I tried to log in to drupal I got the following error message:
<code>
    * warning: mkdir() [function.mkdir]: Permission denied in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: Permission denied in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
</code>

The line on 115 is:
<code>
CRM_Utils_File::createDir( dirname( $path ), $abort );
        if ( mkdir( $path, 0777 ) == false ) {
            if ( $abort ) {
                $docLink = CRM_Utils_System::docURL2( 'Moving an Existing Installation to a New Server or Location', false, 'Moving an Existing Installation to a New Server or Location' );
                echo "Error: Could not create directory: $path.<p>If you have moved an existing CiviCRM installation from one location or server to another there are several steps you will need to follow. They are detailed on this CiviCRM wiki page - {$docLink}. A fix for the specific problem that caused this error message to be displayed is to set the value of the config_backend column in the civicrm_domain table to NULL. However we strongly recommend that you review and follow all the steps in that document.</p>";
                exit( );
            } else {
                return false;
            }
        }
        return true;
    }
</code>
I have little to no MySQL (or any database experience) to speak of so I'm not really sure what that is telling me. What is the document in the above error? Not sure where it's located.

Thanks again,
Todd

I looked in the file civicrm.settings.php and everything seemed to be correct. I am having trouble running

UPDATE civicrm_domain SET config_backend = NULL;

I went to /opt/lampp/bin/ and ran 'mysql' and at the prompt I got the error message:

mysql> UPDATE civicrm_domain SET config_backend = NULL;
ERROR 1046 (3D000): No database selected
mysql>

If there is a way to run this from phpmyadmin, I could not find it. Any thoughts on what I am doing wrong?

Thanks for all of your help.

Todd

It now seems that the data were imported into the civicrm database, it's just that I get the following errors when I log into the site:


    * warning: mkdir() [function.mkdir]: Permission denied in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: Permission denied in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.
    * warning: mkdir() [function.mkdir]: No such file or directory in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/File.php on line 115.

Can't seem to figure that part out...

Make sure to follow these instructions: http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location