Changed my servers . . . now I need HELP!

[janeausten72]

I changed to a new server to get more room. Now I've gone through Fantastico to setup a new ZenCart called Boutique. How do I get all my old info. into the new cart?

I do have a copy of everything that was in the cart before, including the .sql file, but I have no idea how to get that info. to be integrated or to replace the new cart.

Can someone please help?! My site is http://www.liddysloft.com/boutique
Thank you tons in advance!

[Absolute]

The easiest way to move your database is to export the database as an SQL file. Then open phpMyAdmin on the new site, and upload and run the SQL file on the new server.

You will now have exactly the same database on the new server as you had on the old server.

Next, if you had any modifications loaded on the old server, you will have to pain-stackingly go through and grab the altered files and upload those on to the new server.

Finally, you need to grab any images from the old, and place them on the new server.

Hey-presto - you just moved your store!

Hope this helps, or at least gets you started.

Absolute B)

[janeausten72]

After deleting all the preset tables, I went in to Import my _zc1.sql file and it give me this error:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 22, 2006 at 07:46 PM
-- Server version: 4.1.13
-- PHP Version: 4.3.11
--
-- Database: `hvandenb_zc1`
--
-- --------------------------------------------------------
--
-- Table structure for table `zen_address_book`
--
CREATE TABLE `zen_address_book` (

`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) NOT NULL default '',
`entry_company` varchar( 32 ) default NULL ,
`entry_firstname` varchar( 32 ) NOT NULL default '',
`entry_lastname` varchar( 32 ) NOT NULL default '',
`entry_street_address` varchar( 64 ) NOT NULL default '',
`entry_suburb` varchar( 32 ) default NULL ,
`entry_postcode` varchar( 10 ) NOT NULL default '',
`entry_city` varchar( 32 ) NOT NULL default '',
`entry_state` varchar( 32 ) default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =309;



MySQL said:

#1050 - Table 'zen_address_book' already exist


Any suggestions?

[Vger]

When you take a backup of your old database make sure to tick the box that says Drop Tables.

Vger

[janeausten72]

What happens if I don't do that and my old server has dropped my service? Is all hope lost?

[DrByte]

You can drop all the tables manually by going into phpMyAdmin and selecting them, and clicking the red X at the bottom of the list, or on each individual table.