Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Location
    San Diego
    Posts
    159
    Plugin Contributions
    0

    Default Moving to new site different server & database name

    I have looked for an answer to this problem in vain
    I am looking to mirror my database on my wife's site -
    which is on a different server with a different name and different password for the database.
    I have made a back-up but when I do the restore to the new site I get a message:
    MySQL said: Documentation #1044 - Access denied for user 'cad'@'%' to database 'clonecop_clonecart'
    Thanx in advance

  2. #2
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: Moving to new site different server & database name

    You have to edit admin/includes/configure.php and includes/configure.php.

    This tutorial should help https://www.zen-cart.com/tutorials/index.php?article=99
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  3. #3
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: Moving to new site different server & database name

    Thinking about this some more... if you uploaded your database, the password, user and (possibly) the database name are different. Check the configure files I mentioned earlier.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  4. #4
    Join Date
    Sep 2008
    Location
    San Diego
    Posts
    159
    Plugin Contributions
    0

    Default Re: Moving to new site different server & database name

    Yup, database name and password are different - should I simply change database on wife's site to match the details on my database on my site = the sites are on different servers

  5. #5
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: Moving to new site different server & database name

    It's not clear to me what you're trying to do. Is your wife also running ZC on her site? If you edit the configuration files I mentioned earlier to match the information of your wife's database, it should solve the problem. If that information is already correct, there's a mismatch between the information and the data in the database because of the copy. You'll have to put the 2 in sync. Find out the name of the database, the user and the ID and adjust the configuration files accordingly.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

 

 

Similar Threads

  1. v154 Error 1044 when moving database to new server
    By Annie_zaz in forum Installing on a Linux/Unix Server
    Replies: 18
    Last Post: 19 Jan 2016, 03:04 PM
  2. moving site to different URL on same server
    By JohnBoyCR in forum General Questions
    Replies: 2
    Last Post: 12 Mar 2009, 08:08 PM
  3. Replies: 2
    Last Post: 24 Feb 2009, 09:43 AM
  4. Site Inaccessable After Moving to A Different Server
    By mtrantas in forum General Questions
    Replies: 1
    Last Post: 29 Jan 2008, 04:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR