Hi All,
After many long nights, I'm finally ready to transfer my site from my local machine to my new web host (Host Gator).
I installed a fresh copy of Zen-Cart, uploaded my custom template, and transferred my database.
I was assuming that once I transferred my database, all my products, admin settings, etc would be preserved, but they're not.
I can browse the DB using phpMyAdmin and see all my products and setting, but no products are displayed on my site or listed in admin. There is only one database installed, so I know I'm looking at the correct database.
How do I get all my products and settings transferred over?
Thread: Transferring DB to new server
Results 1 to 7 of 7
-
23 Mar 2009, 01:30 AM #1
New Zenner
- Join Date
- Feb 2009
- Posts
- 95
- Plugin Contributions
- 0
Transferring DB to new server
-
23 Mar 2009, 01:36 AM #2
Totally Zenned
- Join Date
- Apr 2006
- Location
- London, UK
- Posts
- 10,569
- Plugin Contributions
- 25
Re: Transferring DB to new server
Could you post a link to the new location?
Kuroi Web Design and Development | Twitter
(Questions answered in the forum only - so that any forum member can benefit - not by personal message)
-
23 Mar 2009, 02:10 AM #3
New Zenner
- Join Date
- Feb 2009
- Posts
- 95
- Plugin Contributions
- 0
Re: Transferring DB to new server
www.thetoolspot.us
But I currently have it down for maintenance. Unfortunately I cant' open just yet because I just transferred that domain from my yahoo merchant account and I don't want customers getting confused by the unfinished layout. Also, don't have ssl properly configured yet.
Maybe I could temporarily add your IP to the list.
-
23 Mar 2009, 03:56 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: Transferring DB to new server
Did you perhaps use a different table-prefix when you did the zc_install step, and thus the tablenames it's using are pointing you to the wrong set?
Related FAQ: https://www.zen-cart.com/tutorials/i...hp?article=100.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
23 Mar 2009, 04:11 AM #5
New Zenner
- Join Date
- Feb 2009
- Posts
- 95
- Plugin Contributions
- 0
Re: Transferring DB to new server
Dang, you are good!
Originally Posted by DrByte
After few hours of head scratching, I just figured this out.
I actually use fantastico to install Zen-Cart. Since it pretty much automated the install, I didn't realize it added a zen_ prefix to the tablenames. I edited the 2 configure.php files to remove the prefix and everything just started working like majic.
Only problem now is that I have a database full of duplicate tables. One with a zen_ prefix and one without. Can a wildcard be used to delete all those tables with zen_ prefix at once?
-
23 Mar 2009, 04:15 AM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: Transferring DB to new server
Use phpMyAdmin and check the box next to each of the tables you want to drop, and then choose "drop" from the pulldown at the bottom of the list, and confirm the action when prompted.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
23 Mar 2009, 05:27 AM #7
New Zenner
- Join Date
- Feb 2009
- Posts
- 95
- Plugin Contributions
- 0
Re: Transferring DB to new server
Excellent!
Problem solved.
Thank you very much!!!
Similar Threads
-
v151 Internal server error after transferring site to new folder
By wagnerguy in forum Templates, Stylesheets, Page LayoutReplies: 1Last Post: 25 Jul 2014, 06:11 PM -
v138a Transferring database to new server
By rand486 in forum General QuestionsReplies: 4Last Post: 11 Jul 2012, 04:23 PM -
v150 Transferring install on same godaddy server to a new domain
By reachesfar in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 29 May 2012, 03:21 PM -
Missing a few modules after transferring to new server
By john_c in forum All Other Contributions/AddonsReplies: 3Last Post: 12 Mar 2010, 10:34 PM
