Transfering Categories and Products

[theangel2g]

I created a live store and had to change my domain name. I still have the live store up but I want to transfer all of those files to my new site. How do I do that? I really don't want to start all over.

Any help is appreciated.

[theangel2g]

I contacted my hosting server and this is the advice I got but now I need to know what file name do I dump this information to within zen?

To Export the Complete Database

1. Log in to your Account Manager.
2. Under the Hosting & Email section, select Hosting Account List.
3. Next to the hosting account you want to modify, click Open.
4. Under the Databases section of the Hosting Manager, click the icon for the type of database you want to manage. On this page, you can create new databases, delete databases, make changes to existing databases, or export databases.
5. To access more advanced management functions, click Open Manager next to the database you want to export.
6. Enter your username and password for your database.
7. On the phpMyAdmin page, click Export under MySQL.
8. In the Export field on the left side of the View Dump pane, select the database you would like to export.
9. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
10. When you are satisfied with your options, click the Go button. Your exported data displays.
11. Click Select All and paste it into a SQL file.

Your database has been exported.
To Export Selected Tables Within a Database

1. Log in to your Account Manager.
2. Under the Hosting & Email section, select Hosting Account List.
3. Next to the hosting account you want to modify, click Open.
4. Under the Databases section of the Hosting Manager, click the icon for the type of database you want to manage. On this page, you can create new databases, delete databases, make changes to existing databases, or export databases.
5. To access more advanced management functions, click Open Manager next to the database you want to export.
6. Enter your username and password for your database.
7. Click on the Databases icon under MySQL.
8. Click the database name you wish to export tables from.
9. Click the Export tab.
10. In the Export field on the left side of the View Dump pane, select the tables you would like to export. Use the CTRL-key to select multiple tables.
11. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
12. When you are satisfied with your options, click the Go button. Your exported data displays.
13. Click Select All and paste it into a SQL file.

The selected tables have been exported.

[schoolboy]

It does not really matter what PROCESS you have to use to "export" the dbase.

It seems (from your posting) that what happens is that when you've gone through all this, you are being confronted with a screen of text that you are now being told to SAVE AS a sql file.

Just do this...

Get CRIMSON EDITOR off the web - it's a FREE text editor, and anyone working with php, sql and html ought to have it (or something like it)

Anyway, get CRIMSON EDITOR working on your computer.

Open up Crimson Editor, and start a new file (just like you would in MS Word.)

Then, when you're confronted with that block of text from your database (also known as a database dump), place your cursor right at the start of it.

Hold down your SHIFT key..

Scroll to the bottom of that big text block..

Put your cursor right at the end of it...

There will be a final " ; " which you must include...


COPY (ctrl+c)

Then PASTE (ctrl+v) into your new crimson editor file

Choose SAVE AS in crimson editor and select the SQL option from the file type

Call the file " my_database_backup_15_march_2007.sql "

Save it to a folder called DATABASE BACKUP

(This SQL file is little more than a simple TXT file, but by giving it the SQL extension, crimson editor will recognise it as sql and display it in the proper manner).


You now have your database all sewn up, on your hard drive!


FTP all your zencart folders FROM your host, TO your Hard Drive.


You now have a copy of your webshop on your hard drive.

Get the sql file and the zencart folders/files to your new host - either by ftp, or by putting them on a disk and popping it in the post


Ideally, you should do a fresh install at your new host, and there are instructions elsewhere in this forum for doing that and dumping your SQL file into the new database.

But you should consider hosting with a certified zencart host... They will help you get the new site up and running.

[schoolboy]

Sorry.... just noticed in CRIMSON editor that there's no filetype option for SQL... but this does not matter. Choose "ALL FILES" as filetype, and still use sql extension

[theangel2g]

Sorry.... just noticed in CRIMSON editor that there's no filetype option for SQL... but this does not matter. Choose "ALL FILES" as filetype, and still use sql extension

THANK YOU THANK YOU THANK YOU.

Angel

[schoolboy]

Pleasure Angel...

Please note that there are some CONFIGURATION settings that need to happen when you get set up on your new host, and also some issues regarding the database.

You can't just "upload" everything and expect it to work...

This is another reason that I advise you to host with a certified zen cart host because they know how to get you up and running quickly and easily. Please consider this as good advice.

Here's a list of hosts that I strongly recommend.