Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Transfering one site from one Domain to another on the same server?

Transfering one site from one Domain to another on the same server?

Views: 5,707

Results 1 to 20 of 22
11 Feb 2012, 3:57 PM
#1
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Transfering one site from one Domain to another on the same server?

Hi
I having trouble with a simple transfer of a site into another domain. I want to have two sites work on the same server. the old site domain is https://www.flproducts.gr which I dont want to delete offcourse. Now the new one is https://www.pelagosmarine.gr.
I'm writing all the steps that I have been doing until now.

  1. I downloaded the https://www.flproducts.gr site contents with the database as a backup.
  2. I changed the configuration files both in admin/includes and includes.
  3. Then I changed the sql file the SQL command to
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE pelagos;
    by simply changing the name of the database name because they cannot have the same db_name as they both are in the same server.
  4. then I transfered the backup into the new dir and then I import the sql file through phpmyadmin. And the new site does not seems to work properly please see https://www.pelagosmarine.gr.

Please tell me what am I doing wrong here? It seems to be something wrong with the database but I cannot trace it.

11 Feb 2012, 3:58 PM
#2
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Please help! I'm trying t figure out these for weeks now and I find a solution

11 Feb 2012, 4:00 PM
#3
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi
I having trouble with a simple transfer of a site into another domain. I want to have two sites work on the same server. the old site domain is https://www.flproducts.gr which I dont want to delete offcourse. Now the new one is https://www.pelagosmarine.gr.
I'm writing all the steps that I have been doing until now.

  1. I downloaded the https://www.flproducts.gr site contents with the database as a backup.
  2. I changed the configuration files both in admin/includes and includes.
  3. Then I changed the sql file the SQL command to
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE pelagos;
    by simply changing the name of the database name because they cannot have the same db_name as they both are in the same server.
  4. then I transfered the backup into the new dir and then I import the sql file through phpmyadmin. And the new site does not seems to work properly please see https://www.pelagosmarine.gr.

Please tell me what am I doing wrong here? It seems to be something wrong with the database but I cannot trace it Please help.

11 Feb 2012, 4:29 PM
#4
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Transfering one site from one Domain to another on the same server?

I don't see what's wrong with the site other than you need to change the permissions on includes/configure.php to 444. If you can't do that using FTP, you may be able to use your hosting account's control panel file manager.

11 Feb 2012, 4:32 PM
#5
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi
I having trouble with a simple transfer of a site into another domain. I want to have two sites work on the same server. the old site domain is https://www.flproducts.gr which I dont want to delete offcourse. Now the new one is https://www.pelagosmarine.gr.
I'm writing all the steps that I have been doing until now.

  1. I downloaded the https://www.flproducts.gr site contents with the database as a backup.
  2. I changed the configuration files both in admin/includes and includes.
  3. Then I changed the sql file the SQL command to
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE pelagos;
    by simply changing the name of the database name because they cannot have the same db_name as they both are in the same server.
  4. then I transfered the backup into the new dir and then I import the sql file through phpmyadmin. And the new site does not seems to work properly please see https://www.pelagosmarine.gr.

Please tell me what am I doing wrong here? It seems to be something wrong with the database but I cannot trace it.

11 Feb 2012, 4:34 PM
#6
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi
I having trouble with a simple transfer of a site into another domain. I want to have two sites work on the same server. the old site domain is https://www.flproducts.gr which I dont want to delete offcourse. Now the new one is https://www.pelagosmarine.gr.
I'm writing all the steps that I have been doing until now.

  1. I downloaded the https://www.flproducts.gr site contents with the database as a backup.
  2. I changed the configuration files both in admin/includes and includes.
  3. Then I changed the sql file the SQL command to
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE pelagos;
    by simply changing the name of the database name because they cannot have the same db_name as they both are in the same server.
  4. then I transfered the backup into the new dir and then I import the sql file through phpmyadmin. And the new site does not seems to work properly please see https://www.pelagosmarine.gr.

Please tell me what am I doing wrong here? It seems to be something wrong with the database but I cannot trace it.

11 Feb 2012, 5:03 PM
#7
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,607
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Moderator's note: multiple posts have been merged together .

Please stop reposting.

11 Feb 2012, 6:13 PM
#8
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

What do you mean what is wrong with the site? please check again
https://www.pelagosmarine.gr

11 Feb 2012, 6:15 PM
#9
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

the site comes with this error
1142 SELECT command denied to user 'pelagosuser'@'localhost' for table 'ezpages_content'
in:
[select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.toc_chapter, et.pages_title from ezpages e, nutriverse.ezpages_content et where e.pages_id = et.pages_id and et.languages_id = '6' and status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title]

I'm trying to solve it

11 Feb 2012, 6:20 PM
#10
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Could you please tell me what I'm doing wrong here because all the steps I made where correct.

11 Feb 2012, 10:09 PM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Transfering one site from one Domain to another on the same server?

gmartakis:

the site comes with this error
1142 SELECT command denied to user 'pelagosuser'@'localhost'
That means that your database user account hasn't been granted ALL permissions on the database.
If you don't know what that means, contact your hosting company server administrator for help.

12 Feb 2012, 10:48 AM
#12
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Please can someone help?

12 Feb 2012, 10:49 AM
#13
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Sorry I did not understand the problem?

12 Feb 2012, 10:51 AM
#14
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

When I test the site locally is doing the same thing. So I don't know if it has to do with my hosting company.

13 Feb 2012, 6:50 AM
#15
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

1146 Table 'nutriverse.ezpages_content' doesn't exist
Hello,
Can anyone help please?
I've been trying the last few days, & that's just my latest batch of attempt to get this sorted!
I am on a Linux server.
I was having the same problems when I tried all of this on my computer using Wamp5;
I load in Zen Cart 1.3.9.c, because that is what I used when I first created my shop.
I have no problem with this at all.
I had just transfer my eshop to another domain ('www.pelagosmarine.gr') on the same server. these are the steps I've made

  1. I downloaded the old site contents with the database as a backup.
  2. I changed the configuration files both in admin/includes and includes.
  3. Then I changed the sql file the SQL command to
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE pelagos;
    by simply changing the name of the database name because they cannot have the same db_name as they both are in the same server.
  4. then I transfered the backup into the new dir and then I import the sql file through phpmyadmin. And the new site does not seems to work properly. I've go a strange error of:
    1146 Table 'nutriverse.ezpages_content' doesn't exist. The name nutriverse is from the previous site and I though I've changed it when I entered in the sql this code:
    DROP DATABASE pelagos;
    CREATE DATABASE pelagos DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    but that did help that much. Please can anybody help here I would be grateful.
    Thanks very much, in advance, for any help you can give.
    Regards
13 Feb 2012, 6:56 AM
#16
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Transfering one site from one Domain to another on the same server?

'nutriverse' is coming from the DB_XXXXXX settings in the configure.php files.

and "ezpages_content" is related to tables added with an addon. That table is not part of original Zen Cart code.

13 Feb 2012, 7:08 AM
#17
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi DrByte thanks again for your quick prompt,
my configuration file in includes folder is this:

<?php /** * @package Configuration Settings circa 1.3.9 * @copyright Copyright 2003-2009 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * File Built by zc_install on 2011-09-24 06:50:46 */ /*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ // Define the webserver and path parameters // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com define('HTTP_SERVER', 'http://www.pelagosmarine.gr'); define('HTTPS_SERVER', 'https://www.pelagosmarine.gr'); // Use secure webserver for checkout procedure? define('ENABLE_SSL', 'false'); // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes! // * DIR_WS_* = Webserver directories (virtual/URL) // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder) define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/'); define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/'); define('DIR_WS_PHPBB', '/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/ define('DIR_FS_CATALOG', '/var/www/vhosts/pelagosmarine.gr/httpdocs/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/'); define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', ''); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'pelagosuser'); define('DB_SERVER_PASSWORD', 'pelagos1'); define('DB_DATABASE', 'pelagos'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'db'); // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'none'); define('DIR_FS_SQL_CACHE', '/var/www/vhosts/pelagosmarine.gr/httpdocs/cache'); // EOF could you please point to me what do I have to change in order to be correct?
13 Feb 2012, 7:15 AM
#18
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi DrByte,
What do I need to change in order the name nutriverse is completely erased from the db?
any advice would be appreciated,
Thanking you in advance, Hope hearing from you soon
regards

13 Feb 2012, 7:16 AM
#19
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Transfering one site from one Domain to another on the same server?

DB_DATABASE must point to the correct database.

If the file ON THE SERVER is read-only, then any changes you make on your PC and try to upload will fail. And if your FTP program isn't telling you about the failure, then that probably explains why you THINK you're using the correct settings, when you're really NOT correct.

An additional possibility is that maybe the addon you're using is incorrectly written and has hard-coded database names into the addon code and thus is forcing it to point to the wrong database. You could try searching ALL the PHP files on your server for the database name that's showing incorrectly. But, I can't speak to how that addon works, because I'm not familiar with its code, and offer no support for it.

13 Feb 2012, 7:30 AM
#20
gmartakis avatar

gmartakis

New Zenner

Join Date:
Feb 2011
Posts:
73
Plugin Contributions:
0

Re: Transfering one site from one Domain to another on the same server?

Hi DrByte,
Thanks for your quick response once again. I can ensure you that the
configure files that I'm downloading through ftp are the correct one since I change the file permissions. Obviously the problem is somewhere else....I will try to search from dreamveaver the php files. I hope I can find something. Thanks again for your help!:smile: