daxcastro Posted January 24, 2005 Posted January 24, 2005 Okay after a month of editing and getting the cart all perfect with our transaction gateway, sorting products, etc. etc. I finally have a well running cart. (by the way thanks to all the mod creators) NOW ... boss wants to put the cart on another site. Our Dedicated server runs ensim and so it does an automatic initial installation of the unmodified cart. I thought I could just copy all the files from the original site to the new site overwriting the newly installed unmod'ed file and all would be well, then I remembered the database. I tried exporting the database and importing it to the new server but can't get it to work. (here comes the begging and pleading part) If anyone out there can help me make this happen I would be forever in your debt. Time is an issue and I could really use your help. Thanks [email protected]
ozcsys Posted January 24, 2005 Posted January 24, 2005 You have not said what problem you are having but you can move a store using the steps found HERE 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??
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 I appologize for not being clear. I have copied all the files over and am at the point of trying to get the database in. My problem is that I am using myphpadmin and when I export the database from one site then import it into the new database I get: Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/html/phpMyAdmin-2.5.6/libraries/read_dump.lib.php on line 77 The file is only a little over a meg so I am not sure why I am getting a time out error. I have tried copying and pasting the text as well and get the same error. your quick response to my request was very nice thanks. Dax
♥Vger Posted January 25, 2005 Posted January 25, 2005 FTP to the site, find the mysql folder, download the existing file to back it up. Then delete it on the website. Change the name of the sql file from the old site to match the name of the new sql file and upload it to the new site. Vger
TCwho Posted January 25, 2005 Posted January 25, 2005 and in the future... here is how I accomplished it.. When I knew I was going to have to move site.. I created a backup of the database from within osC admin Backup Tool.... then I created a backup of entire site.... so after all the configuring was sorted .. I did a restore database table from osC admin Backup Tool and everything worked. Drop_Shadow How Did You Hear About Us Email HTML Order Link ---- GMT -5:00
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 If it were only that easy.... The sql folder appears no where except for in the phpmyadmin panel. I looked through every folder. Dax FTP to the site, find the mysql folder, download the existing file to back it up. Then delete it on the website. Change the name of the sql file from the old site to match the name of the new sql file and upload it to the new site. Vger <{POST_SNAPBACK}>
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 The problem is not getting the data in. The problem is that I have modified OSC with several mods. So when I installed it from my ensim control panel, it creates the folder and the database automatically, but it is an un modified version. I need the one with the right database tables added. I guess I could go through the databases each table by table and figure out what is different, but I was really hoping to be able to copy the structure from the sql file. I am not terribly sql savvy so identifying the differnt tables will be the easy part. Figuring out how to take them from one and add them to the other might be a bit more tricky for a programming novice like me. All your help is appreciated. and in the future... here is how I accomplished it.. When I knew I was going to have to move site.. I created a backup of the database from within osC admin Backup Tool.... then I created a backup of entire site.... so after all the configuring was sorted .. I did a restore database table from osC admin Backup Tool and everything worked. <{POST_SNAPBACK}>
TCwho Posted January 25, 2005 Posted January 25, 2005 But cant you use the Backup Tool from osC Panel..... You could FTP you database Backup to osC Backup Folder used by Tools..... and let osC handle it? Hope Im clear. Im assuming your osC Backup Utility is still operational... but your scenario may be different...so sorry If I just dont get it. >_< :::Edited:::: oh and if you havent done it yet... Try Vger's solution. That sounds logical. I know sometimes you have to even delete your old database to import new one....... Drop_Shadow How Did You Hear About Us Email HTML Order Link ---- GMT -5:00
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 Okay.. let me take another stab at explaining this. I installed the following modifications to the script 1. Sort Order 2. Individual Shipping 3. Itransact Gateway Some of these add columns and tables to the original OSC. So what I have now is a different animal than the standard cart. A) I have copied all the html/php/inc files etc. over to the new server - that is no problem. B) I need to copy the database structure that matches to the new server C) I keep getting a time out error explained above when trying to copy/paste or point it to the sql statement to build the tables. Problem with the solutions provided so far. #1 I cannot ftp in and see the sql - Myphpadmin is the only way to access it. #2 I followed the instructions for transfer above and get the time out error. Anyone who can help (thanks to those who have tried so far) is appreciated. Dax
Guest Posted January 25, 2005 Posted January 25, 2005 use the osc backup tool as stated, on the local system open the file with wordpad, something like that copy a portion of the file and paste into another file. do this until you re blow your host limit for file siae then run the browse via phpmyadmin or find a host who lets u have shell access. then u dump the whole file via ftp and run mysql from the prompt and away you go
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 okay... made some progress. Here is what I did.... I exported the tables so now I am good on that point, just no data, sooooo like you said went to do a backup and got the following. Warning: set_time_limit(): Cannot set time limit in safe mode in /home/virtual/site2/fst/var/www/html/oscommerce/admin/includes/functions/general.php on line 733 Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site2/fst/var/www/html/oscommerce/admin/includes/functions/general.php:733) in /home/virtual/site2/fst/var/www/html/oscommerce/admin/includes/functions/general.php on line 18 getting closer!!! Dax
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 okay.. the backup seemed to save even with the error.. BUt NOW I am such a looser!!!! What is the default pw for the cart admin? the user name is admin and the pw is? I have been using "remember password" for so long I have forgotten!!! Crap.. what a night. Thanks Dax
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 Okay.. got the password issue straightened out at least. Now to get the data back in. (crossing fingers) Dax
daxcastro Posted January 25, 2005 Author Posted January 25, 2005 Can anyone translate this into english for me? thought I had it all dialed in. At least it seems to be but of course I am missing something. Warning: main(includes/languages/.php): failed to open stream: No such file or directory in /home/virtual/site1/fst/var/www/html/oscommerce/includes/application_top.php on line 285 Fatal error: main(): Failed opening required 'includes/languages/.php' (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site1/fst/var/www/html/oscommerce/includes/application_top.php on line 285 Dax
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.