CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Database transfer
Pages: [1]

Author Topic: Database transfer  (Read 1261 times)

Simon147

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 3
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.30
  • MySQL version: 5.0.92
  • PHP version: 5.2.9
Database transfer
November 23, 2010, 06:52:56 am
Hello all,

I'm getting a terrible headache when trying to move my civicrm database from one server to another (to mention that both servers have mostly the same configurations).

After creating a database dump, I try to import the database in an empty database created on the new server. But then I get the following errors:
#1227 - Access denied; you need the SUPER privilege for this operation

I didn't have SUPER privilege on the old server, so I don't really understand what's wrong. Any idea?

An additional information that might help: The database import gets stuck at the table "civicrm_address".

Simon

« Last Edit: November 23, 2010, 07:08:48 am by Simon147 »

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: Database transfer
November 23, 2010, 01:04:08 pm
Do you have different mysql versions, e.g. going from 5.1 to 5.0? You might need super in 5.0

Simon147

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 3
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.30
  • MySQL version: 5.0.92
  • PHP version: 5.2.9
Re: Database transfer
November 23, 2010, 01:31:41 pm
On my old server, I have MySQL version 5.1.47-community-log and the new one runs 5.0.91-community. Do you think this has an influence?

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Database transfer
November 25, 2010, 04:49:30 am
I guess to create/run triggers in mysql 5.0 your db user should has to have 'SUPPER' privilege.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

hope this help

kiran
You Are Designed To Choose... Defined By Choice.

Simon147

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 3
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.30
  • MySQL version: 5.0.92
  • PHP version: 5.2.9
Re: Database transfer
November 25, 2010, 07:03:49 am
Well, actually, the reason why I changed from one hosting provider to another was that the old one didn't allow to activate triggers.

Somehow I think it must be linked to that, but in the same time, I'm having some doubts...

Simon
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Database transfer

This forum was archived on 2017-11-26.