Problems moving EE website

[gillyworld]

I am trying to move my EE website to another hosting company but I am having problems restoring my database on the new server. When I run the restore on the new server it seems to run for a short while and then the page goes blank. Some of the database seems to get restored but not all of it. I have done this before so I am reasonably confident that I am doing it correctly.

Is there a problem restoring on different versions of MYSQL?
the old server runs
MySQL version (reported by MySQL server): 4.0.22-standard
PHP version: 5.0.3

and the new server runs
MySQL version (reported by MySQL server): 4.1.7
PHP version: 4.3.6

Thanks

Alan

[Pekka]

What restore tool are you using? If it is EE Backup, then possible cause is php timeout. In this case use SLOW MODE RESTORE option. It might be also MySQL 4.1 incompatibility, I do not know all implications of character set system it has (especially on compressed EE Uncookied backup data).

If the backup is EE Backup, you can reduce its size by deleting unneccessary items. Open the backup to text editor and remove all complete lines starting with

INSERT INTO `ee_uncookied` VALUES

and

INSERT INTO `ee_performance` VALUES

and

INSERT INTO `ee_message` VALUES

Those are grouped, so it is easy to select the whole block and delete.

Because of many changes, best bet to upgrade database from MySQL 4.0 to MySQL 4.1 is to use mysqldump utility.

[gillyworld]

Yes I am using EE Backup. I will try your suggestion of slow mode and let you know how I get on. Where is the best place to find out about the mysqldump utility?

Thanks as always

Alan

[Pekka]

mysqldump is something you run on command line shell:
http://dev.mysql.com/doc/mysql/en/mysqldump.html

make backup:

mysqldump --user SQLUSERNAME --password=SQLPASSWORD DATABASENAME --opt > FILENAME.sql

restore backup:

mysql -u SQLUSERNAME -p SQLPASSWORD < FILENAME.sql

After restore run optimize command in EE.

[gillyworld]

Pekka,
Removing the lines you suggested and running in slow mode worked fine, it took about 3 hours to upload but that's ok

Many thanks for your help

Alan