Muldrick Posted July 4, 2006 Posted July 4, 2006 Could someone post a link to help on moving my entire database, including data and structure, to a new web host? Of course I'm googling it, just haven't found anything yet.
ozcsys Posted July 4, 2006 Posted July 4, 2006 Could someone post a link to help on moving my entire database, including data and structure, to a new web host?Of course I'm googling it, just haven't found anything yet. Steps to follow when moving a site 1. Backup database in your osC admin. 2. Ftp all your files to your local computer 3. Create new database and user at new location making sure you assign user to database. ( It is a three step process, create database, create user, add user to database) 4. Edit your two configure.php files using your new database info and path info on your new server 5. Ftp all your files to new location 6. using phpmyadmin (or whatever tool your hosting company supplies) populate database with sql file from last backup you did (from step 1) Store should be up and going. The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right??
Muldrick Posted July 4, 2006 Author Posted July 4, 2006 Alternatively, could I install OSC at my new domain/hosting, then populate the sql file from my last backup? Then swap some files (like headers, footers, index etc) I am really lost on #4, 1. I only found one configure.php, and I'm confused on what to edit. (unless I post the file here?
Muldrick Posted July 5, 2006 Author Posted July 5, 2006 Well, I transferred all the files. I edited one config. Could someone check the code please? Old web was aaa.customcarputers.com. New web is eglobal-mart.com. Lets just say the password is abcdefg. Do I have it correct? This config is in the includes directory: <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright ? 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://eglobal-mart.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://eglobal-mart.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'eglobal-mart.com'); define('HTTPS_COOKIE_DOMAIN', 'eglobal-mart.com'); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', '/'); define('DIR_WS_HTTP_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); 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', 'pub/'); define('DIR_FS_CATALOG', '/home/richard/public_html/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'richard_osc1'); define('DB_SERVER_PASSWORD', 'abcdefg'); define('DB_DATABASE', 'richard_osc1'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> What other config file do I edit? Where is it. Seems there's nothing to edit on the ones that I did find. Pleeeeeze help. Thanks BTW: the new site hasn't propagated (or whatever) yet.
mtechama Posted July 5, 2006 Posted July 5, 2006 Please do not ever ever give out your Database information okay. The 2 files you need edit is as fallows: (catalog)/includes/configure.php and (catalog)/admin/includes/configure.php Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP!
Silverado05 Posted July 5, 2006 Posted July 5, 2006 Please do not ever ever give out your Database information okay. I think he knows that already or he wouldn't have put in a fake password like he stated he did in his last post. Yes, that looks good, I can't spot anything wrong of right off the bat. Guess you'll know once it's upload. If you have any problems, you know where to find us... LoL. Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
Muldrick Posted July 5, 2006 Author Posted July 5, 2006 Please do not ever ever give out your Database information okay. The 2 files you need edit is as fallows: (catalog)/includes/configure.php and (catalog)/admin/includes/configure.php Thanks for the advise (and info) on that (no sarcasm) But yes, that's just a sample password. I don't quite understand (I believe) line 40: define('DB_SERVER_PASSWORD', 'abcdefg'); Should that show the EXACT password, like it does there? Because on the old web...when the password was one thing, it showed something else. I'm talking to a guy at mu hosting support. He says www.eglobal-mart.com is coming up fine. Well, it's not for me, I only get "page can't be displayed" (I cleared cache and all) Would someone here check it? See if it comes up for you? www.eglobal-mart.com Thanks EDIT: now the tech guy is saying I have to wait for the propagation. So I wonder, if he says it works...how is he seeing it? (which he said he did)
mtechama Posted July 5, 2006 Posted July 5, 2006 Thanks for the advise (and info) on that (no sarcasm) But yes, that's just a sample password. I don't quite understand (I believe) line 40: define('DB_SERVER_PASSWORD', 'abcdefg'); Should that show the EXACT password, like it does there? Because on the old web...when the password was one thing, it showed something else. I'm talking to a guy at mu hosting support. He says www.eglobal-mart.com is coming up fine. Well, it's not for me, I only get "page can't be displayed" (I cleared cache and all) Would someone here check it? See if it comes up for you? www.eglobal-mart.com Thanks EDIT: now the tech guy is saying I have to wait for the propagation. So I wonder, if he says it works...how is he seeing it? (which he said he did) I am using IE 6 and it is working fine Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP!
Muldrick Posted July 5, 2006 Author Posted July 5, 2006 Thanks for checking. I guess the PropaG takes place at different times, for different locations. And my area is last :(
Silverado05 Posted July 5, 2006 Posted July 5, 2006 Worked for me as well but in FF. Can you call your site by it's IP? Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
choosealogin Posted July 5, 2006 Posted July 5, 2006 I don't quite understand (I believe) line 40: define('DB_SERVER_PASSWORD', 'abcdefg');Should that show the EXACT password, like it does there? Because on the old web...when the password was one thing, it showed something else. Yes, it should be the exact password. I've seen where Fantastico installs will put an encrypted password in there, I think...that might be what you had noticed before.
Muldrick Posted July 5, 2006 Author Posted July 5, 2006 Yes, it should be the exact password. I've seen where Fantastico installs will put an encrypted password in there, I think...that might be what you had noticed before. I changed it in the includes/configure.php. How about the admin/includes/configure.php. I don't see a line in there to change it. Any other file(s) that should modified?
Silverado05 Posted July 6, 2006 Posted July 6, 2006 No those are the only two. Just look towards the bottom. The two files are pretty much exactly the same looking. Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
Muldrick Posted July 6, 2006 Author Posted July 6, 2006 You guys are awesome. I could've NEVER done this without you. I got it all done (well, NEVER finished) but I got the site changed over. Only problem I see, is when I log into admin and click on "configure", I get the following error: The requested URL /admin/configuration.php was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.36 Server at www.eglobal-mart.com Port 80 Also...(nother dumb question)...how do I put an external link in proper code. I want "link" to go to www.link.com. Is it like so: <a href="http://www.link.com"></a>
Silverado05 Posted July 6, 2006 Posted July 6, 2006 Make sure the /admin/configuration.php is there and all the information in it is correct. Yes that is correct, be something like this though just to dress it up so it doesn't look like a link <a href="http://www.link.com">YOU TEXT HERE</a> So with that all that will display is YOUR TEXT HERE instead of just a plain'ol URL. Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
Muldrick Posted July 6, 2006 Author Posted July 6, 2006 Also...(nother dumb question)...how do I put an external link in proper code. I want "link" to go to www.link.com. Is it like so: <a href="http://www.link.com"></a> I figured that out, and the people at my hosting say they are working on the other issue. Still tring to figure out the "command" for adding an image.
Muldrick Posted July 6, 2006 Author Posted July 6, 2006 I'm in the information.php file: How do I add a line for an image that is allready in the image folder. The image won't be linked to anything. Lines 24-26 from information.php below (stock) '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a>');
mtechama Posted July 6, 2006 Posted July 6, 2006 I'm in the information.php file: How do I add a line for an image that is allready in the image folder. The image won't be linked to anything. Lines 24-26 from information.php below (stock) '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a>'); like for an example on your first line <p><img border="0" src="images/imagefile.jpg" width="312" height="390"></p><br>'. Try that Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP!
Silverado05 Posted July 6, 2006 Posted July 6, 2006 I am using PRIVACY as an example. Replace it with the file you are wishing to call. <a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . tep_image('IMAGE FILE HERE', IMAGE_TEXT_HERE) . '</a>' Then add to your english.php file define('IMAGE_TEXT_HERE', 'Text that will be viewed on mouse over'); Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
Silverado05 Posted July 6, 2006 Posted July 6, 2006 Sorry left out something on the one above, use this one. '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . tep_image('IMAGE FILE HERE', IMAGE_TEXT_HERE) . '</a><br>'. Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.