Changed my servers . . . now I need HELP!

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!

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)

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?

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

Vger

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

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.