Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Moving a Store ???

tim_ver

By tim_ver
in General Support

Recommended Posts

tim_ver

tim_ver

Posted
Posted

I need to move a Oscommerce website store. It is all setup and moded with several donations. What is the best way to move it from server A to server B? I donot want to have any issues or loss of data so need some help here. I figure export db and copy all files then import and reupload to new server and that would do it not sure though. Also How do I export out the full tables,ect in phpmy admin in Cpanel?

 

Thanks Much

Link to comment
Share on other sites
mtechama

mtechama

Posted
Posted
I need to move a Oscommerce website store. It is all setup and moded with several donations. What is the best way to move it from server A to server B? I donot want to have any issues or loss of data so need some help here. I figure export db and copy all files then import and reupload to new server and that would do it not sure though. Also How do I export out the full tables,ect in phpmy admin in Cpanel?

 

Thanks Much

 

setup a new database on the new server then upload the exsiting store to the new server then change the 2 configure.php files.

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
setup a new database on the new server then upload the exsiting store to the new server then change the 2 configure.php files.

 

And don't do it from a wireless link, what a mess that made :o

 

I've been thinking about compressing all the site files and uploading in one file then uncompressing on the new server. I think you can also just move two files from your Mysql/data directory but I've yet to try that, as anyono else ? It would take the risk out of exporting/importing sql statements.

 

Drifter.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
mtechama

mtechama

Posted
Posted
Ok so create a new db file on new server (same name as one using now) the ftp all php,etc files to new server and the import the sql I exported? How do I export out all the sql tables etc??

 

Thanks

 

1. Create new database on new server.

2. install the store database into MySQL database if you have a backup made.

3. Upload all the php files to the new server.

4. Do not do a store install go directly to your configure.php files-(catalog)/includes/configure.php and (catalog)/admin/includes/configure.php'

5. Change the following lines in configure.php files:

 

(catalog)/include/configure.php:

 

// define our database connection
 define('DB_SERVER', 'Name of your new server'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'New Database Name');
 define('DB_SERVER_PASSWORD', 'New Password');
 define('DB_DATABASE', 'New Database Name');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

 

same as in (catalog)/admin/includes/configure.php

 

6. Then you should be up and ready to go.

 

Good Luck!

Wade

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites
tim_ver

tim_ver

Posted
  • Author
Posted

ok so for step 2 is this import in phpmyadmin I am using and importing all the tables? I also have a db backup from the admin area of the store, do I need to run this also?

 

Or am I doing a fresh install through ie window?

 

Sorry just making sure I understand a 100%.

 

 

Thanks

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
??

 

Also what are good hosting companies? I have looked at godaddy and 1&1. Anyone use these any pros/cons??

 

Thanks

 

Import into the database and upload your files, edit the configs job done.

 

Hosts are down to what you can afford but I have said on here www.gearworx.net have an unbeatable offer on at the momment. I got a 8gig hosting for $79 for two years and so far it seems fine. Another company I like is www.ev1.net.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
tim_ver

tim_ver

Posted
  • Author
Posted

Driftwood ok thanks.

 

But import db in oscommerce or in the mysql phpadmin panel?

 

Since I have all the mods install I would thing I need to do both, Install fresh copy import in phpmyamin to create the new tables and then import in oscommerce admin panel also make changes in config done. right??

 

Just not crystal clear yet do not want to miss anything.

 

Thanks

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
Driftwood ok thanks.

 

But import db in oscommerce or in the mysql phpadmin panel?

 

Since I have all the mods install I would thing I need to do both, Install fresh copy import in phpmyamin to create the new tables and then import in oscommerce admin panel also make changes in config done. right??

 

Just not crystal clear yet do not want to miss anything.

 

Thanks

 

If you are just moving your don't do both tim.

 

The only time I have imported the backup from OSC it didn't included and products so I don't bother with that anymore. I do allmy work direct on the database or rather a copy.

 

Import the sql file you exported from mysql using phpadmin.

 

When you've done that open the sql file in a text editor and take a look at the construction of the file. You don't need to do that but I found you can learn a lot about what you can do and how OSC and the contributions are put together. You'll see how the tables of the database are setup and the data added. Just a thought.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
tim_ver

tim_ver

Posted
  • Author
Posted

Ok move seems to have gone good except one issue. When I goto the main page for the catalog I get this error on the top of the page:

 

Warning: I am able to write to the configuration file: /home/yc/public_html/Catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

On the server I moved it from I had the permissions set to: 704 and had no issues. On the new server I have it at 644 and still getting the error. Why is this it should have know issues.

 

 

Arghhhh, Please someone help me out quick.

 

 

Thanks much

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
Ok move seems to have gone good except one issue. When I goto the main page for the catalog I get this error on the top of the page:

 

Warning: I am able to write to the configuration file: /home/yc/public_html/Catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

On the server I moved it from I had the permissions set to: 704 and had no issues. On the new server I have it at 644 and still getting the error. Why is this it should have know issues.

Arghhhh, Please someone help me out quick.

Thanks much

 

It's importent because you don't want people to see your database login.

 

I'm no expert here but it one comes along check this site.

 

http://www.comptechdoc.org/os/linux/usersg...x_ugfilesp.html

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
tim_ver

tim_ver

Posted
  • Author
Posted

Hrmm, I just uploaded the files and it did this and then I did chmod and changed it to 644 and still same error. Is it the host that is causing this error? I do not have a clue on why it would be doing this with 644 or 704 for the file settings. Anyone??

Link to comment
Share on other sites
tim_ver

tim_ver

Posted
  • Author
Posted

I tried setting it to 400 but it always bumps back to 644.

 

It has owner permisions of read,write and execute.

Group & Public - No check boxes checked.

 

When it did work on the old host server I had it set to 704 and that gave owner permisions of read,write and execute.

Group - No check boxes checked.

Public - just read access.

 

So not sure why it is saying it has read access for the file when only one who does is owner.

 

Ideas??

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
I tried setting it to 400 but it always bumps back to 644.

 

It has owner permisions of read,write and execute.

Group & Public - No check boxes checked.

 

When it did work on the old host server I had it set to 704 and that gave owner permisions of read,write and execute.

Group - No check boxes checked.

Public - just read access.

 

So not sure why it is saying it has read access for the file when only one who does is owner.

 

Ideas??

 

often when I get errors I think shouldn't be there I rename the file or delete it, then try again. If it gives the same error you know is a proxy between you and the server. Put the file back and try it from another machine. Just an idea.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

1. Create new database on new server.

2. install the store database into MySQL database if you have a backup made.

3. Upload all the php files to the new server.

4. Do not do a store install go directly to your configure.php files-(catalog)/includes/configure.php and (catalog)/admin/includes/configure.php'

5. Change the following lines in configure.php files:

 

i did all of this but i keep getting this error now!

 

Warning: mysql_connect(): Host '88.88.88.888' is not allowed to connect to this MySQL server in /home/xxxxxx/public_html/carboxes/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

now im gettin this one:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

1. Create new database on new server.

2. install the store database into MySQL database if you have a backup made.

3. Upload all the php files to the new server.

4. Do not do a store install go directly to your configure.php files-(catalog)/includes/configure.php and (catalog)/admin/includes/configure.php'

5. Change the following lines in configure.php files:

 

i did all of this but i keep getting this error now!

 

Warning: mysql_connect(): Host '88.88.88.888' is not allowed to connect to this MySQL server in /home/xxxxxx/public_html/carboxes/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
1. Create new database on new server.

2. install the store database into MySQL database if you have a backup made.

3. Upload all the php files to the new server.

4. Do not do a store install go directly to your configure.php files-(catalog)/includes/configure.php and (catalog)/admin/includes/configure.php'

5. Change the following lines in configure.php files:

 

i did all of this but i keep getting this error now!

 

Warning: mysql_connect(): Host '88.88.88.888' is not allowed to connect to this MySQL server in /home/xxxxxx/public_html/carboxes/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

I don't know but it sounds like you have entered the wrong database host name.

 

Try localhost but don't leave it like that.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

I hadn't actually added the user to the new database in cpanel *blush* and I left off the www. in the domain settings.

 

ehhmmm :-" other than that pretty smooth!

Link to comment
Share on other sites
driftwood

driftwood

Posted
Posted
I hadn't actually added the user to the new database in cpanel *blush* and I left off the www. in the domain settings.

 

ehhmmm :-" other than that pretty smooth!

 

We've been there lad, racked our brains for ages only to find it was a loose nut on the keyboard :lol:

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...