16 {{ upvoteCount | shortNum }}
16 {{ upvoteCount | shortNum }}

I need some help! I want to move my OpenCart MySQL database to new domain

by Mike German
7 replies
Hi everyone,

I set-up an OpenCart shopping cart for a collegue on a domain...

www.cromwellfire.co.uk/store

and now it needs to be moved to www.fireextinguishersonline.co.uk

...but I have tried everything and can't get it to work. :confused:

Any help would be appreciated.

Regards,
Mike
#database #domain #move #mysql #opencart
  • Profile picture of the author mywebwork
    Hi Mike

    When you say you have tried "everything" what exactly do you mean?

    I assume you have tried this:

    Moving to another hoster/domain

    Since you likely have tried this already perhaps you could let us know what error messages you received after you performed the steps that OpenCart suggests.

    Bill
    {{ DiscussionBoard.errors[2882752].message }}
  • Profile picture of the author Mike German
    Hi Bill,

    Thank you for your quick reply.

    I have tried the above with no luck.

    1. It states "Use phpMyAdmin to empty (not delete) the new created database." After you do this should the tables be empty? I used the emapty command and the table structure remained.
    2. It now asks for the "install" folder when I try to visit the site, but this has been deleted.

    This is the error message...

    Warning: Missing argument 2 for Response::addHeader(), called in /home/struggles/public_html/install/index.php on line 31 and defined in /home/struggles/public_html/system/library/response.php on line 6

    Notice: Undefined variable: value in /home/struggles/public_html/system/library/response.php on line 7

    Fatal error: Class 'Action' not found in /home/struggles/public_html/install/index.php on line 46

    I'm new to databases so forgive my ignorance with this post.

    Regards,
    Mike
    Signature
    Order Your CB COMMI$$ION Kits Today
    and earn $289.54 per sale

    {{ DiscussionBoard.errors[2883248].message }}
  • Profile picture of the author mywebwork
    Hi Mike

    Here is how I would interpret the instructions, please note that I haven't worked with this particular cart before:

    (1) Do the file and database backup from your old site as they suggest.
    (2) Install OpenCart on the new machine, exact same version as the one you have now.
    (3) OpenCart wil create a MySQL database in the installation process. Use PHP MyAdmin and delete all the tables from this new database.
    (4) Import your old database to the new installation with PHP MyAdmin
    (5) Use FTP and copy your saved files to the site, with the exception of the two configuration files mentioned in the article.
    (6) You can also use your FTP program (or the File Manager in your CPanel) to look at the file permissions on the old site and ensure the new one is setup in a similar fashion. If something doesn't work it could very well be a permissions issue.

    Not sure if that is of any help to you, let me know how it works out.

    Bill
    {{ DiscussionBoard.errors[2883699].message }}
    • Profile picture of the author Mike German
      Hi Bill,

      I think I did everything to the book, but now I'm seeing this...

      http://fireextinguishersonline.co.uk...tall/index.php

      After the new installation of OpenCart it asks you to delete the install folder. But when you copy across the index.php file I get the above in the address bar.

      Would you be able to take a look at the ftp area and see if there is something obvious I am doing wrong. Databases is not my strong point, I should stick with designing only.

      If you can do this for me how much would you charge?

      Regards,
      Mike
      Signature
      Order Your CB COMMI$$ION Kits Today
      and earn $289.54 per sale

      {{ DiscussionBoard.errors[2885010].message }}
  • Profile picture of the author careybaird
    You might need to change the URL of the site to the new one in a config file or in the database.
    Signature

    Owner of:

    [    Fresh Store Builder]

    The worlds most advanced Amazon store builder with over 17,000 members.
    {{ DiscussionBoard.errors[2886463].message }}
    • Profile picture of the author mywebwork
      Originally Posted by careybaird View Post

      You might need to change the URL of the site to the new one in a config file or in the database.
      I had thought about the database containing the URL as well, but none of the documentation on their site mentions that.

      As for the config file the instructions involve installing a new installation on the target server. The installation creates it's own server-specific config file.

      Mike I'm sending you a PM


      Bill
      {{ DiscussionBoard.errors[2886530].message }}
      • Profile picture of the author frasertk
        Right, hopefully I can help.

        I'm new to forums so please bear with me!

        I have just switched an opencart installation over from one server/domain to another. Here's how I did it:

        1. Made a full back up of site files and database
        2. Uploaded all files and database to new host/domain
        3. Downloaded both config files from / and /admin directories from previous server
        4. Change these config paths to your new site location
        5. *Not sure if this bit is necessary* Went into database and changed 'config url' in 'settings' table to new URL.
        6. download the whole 'image' folder from old server and reupload to new server in same location.

        All should then be sorted unless you have hard coded anything to your previous URL.

        Hopefully this works for you guys!
        {{ DiscussionBoard.errors[4353460].message }}

Trending Topics