Moving EE database to another host server

[noopara]

I set up a photo data base a couple of years ago using EE and now I have to move it to another server. My provider says I have to recreate the data base after moving to the new server and I'm not sure what that means. Do I have to re-enter all the info for each image or what? Any help would be appreciated. I'm a real neophyte as far as sql databases go. EE was a quick and easy path to take. Here's a link to my gallery: http://www.flamincaiman.org/gallery/index.php

-- greg

[Pekka]

Simple instructions are:

- backup MySQL database.
- download MySQL backup dump home.
- download all photos and EE files (whole folder structure) to home.
- upload all photos and EE files (whole folder structure) to new server.
- upload MySQL backup dump to new server.
- restore MySQL database.
- update EE's paths to point to new server.

You can do MySQL backup using:
- PhpMyAdmin tool from http://www.phpmyadmin.net/home_page/index.php
- Exhibit Engine 1.5's EE Backup tool (download 1.5 and copy folder backup to your input folder, set up preferences.php)
- system command mysqldump (it needs specific parameters and shell access to system).

To restore a MySQL dump, you'll have to use the same tool, exept for backups made with mysqldump you'll use command mysql.

[noopara]

Pekka,

Thank you for the reply so quickly.

I have done some snooping around in the forum and found various threads pertaining to the problem of moving an EE database from one server to another.

I am using EE 1.22 but I assume I would follow the same procedure except for using the 1.5 backup tool. I have downloaded the PhpMyAdmin tool and will look that over and see if that will work for me. I'm not sure that upgrading to 1.5 is worth the effort as the 1.22 version is performing well for this application.

Thanks again for your attention to my problem. I'l post again if I get stuck.

-- greg