Struggling wiht move to new server

[MikeCaine]

I've had EE running OK for a while on my current server but I'm now moving because they keep having problems with their reliability

I've d/l the whole EE directory and done a sql dump using EE backup facility

I've copied all files to new host and created a database and altered connect.php to match.

I'm having problems uploading the sql dump. I'm trying to use myPhpAdmin but I get -

"Fatal error: Maximum execution time of 30 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/sqlparser.lib.php on line 307"

which has got me stumped and I don't know what to do next

I can't seem to use EE's backup facility to do it because I get the error -

"Could not retrieve authorization data, can not proceed.
Perhaps 'ee_admin' table is missing (wrong EE database version)? Is database online?"

which is what I'd expect because I haven't uploaded that tables and data yet

Any help would be very much appreciated. My old hosting expires very soon and I'd rahter now have to renew it+

[MikeCaine]

I've just tried

"- Exhibit Engine 1.5's EE Backup tool (download 1.5 and copy folder backup to your input folder, set up preferences.php)"

and get -

"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. "


Grrrr. Still stuck :-(

[MikeCaine]

I've also just tried breaking down the gallery sql file into chunks and trying myPhpAdmin again to insert the data into the database but I get

"#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '|EE|BACKUP|
CREATE TABLE `ee_accessory` (
`ee_accessory_id` "

The SQL version is "MySQL version 4.0.22-standard"

[Pekka]

Thoughts:

I can't seem to use EE's backup facility to do it because I get the error -

"Could not retrieve authorization data, can not proceed.
Perhaps 'ee_admin' table is missing (wrong EE database version)? Is database online?"

in backup/index.php change lines

include ("../../add/connect.php");
require("../SECURITY_check_authorization.php");
mysql_close ();

to

//include ("../../add/connect.php");
//require("../SECURITY_check_authorization.php");
//mysql_close ();

I've also just tried breaking down the gallery sql file into chunks and trying myPhpAdmin again to insert the data into the database but I get

"#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '|EE|BACKUP|
CREATE TABLE `ee_accessory` (
`ee_accessory_id` "

The SQL version is "MySQL version 4.0.22-standard"

PHPmyadmin expects delimiter ;

Do the backup without tables
- ee_message
- ee_uncookied

Do the restore with EE Backup using "Restore in SLOW MODE", unless you can change php timeout to something much bigger than 30 seconds in php.ini or htaccess file.

[MikeCaine]

Hi Pekka



in backup/index.php change lines

include ("../../add/connect.php");
require("../SECURITY_check_authorization.php");
mysql_close ();

to

//include ("../../add/connect.php");
//require("../SECURITY_check_authorization.php");
//mysql_close ();



That already seems to be the situation. I haven't previously altered backup/index.php and the lines

//include ("../../add/connect.php");
//require("../SECURITY_check_authorization.php");
//mysql_close ();

are already commented out

I still get the error

"Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.



Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request"



Do the backup without tables
- ee_message
- ee_uncookied



I've tired it without those tables and using myPhpAdmin again and still get the 30 second timeout



PHPmyadmin expects delimiter ;



Ah, I wonder if it worth trying to break down the .sql file again and use myPhpAdmin

[MikeCaine]

Hmmm, I removed a .htaccess file in the input/backup directory and have now seem to be getting somewhere with a slow restore. Fingers crossed....

[MikeCaine]

OK, it's sort of working except for the error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mikeuca/public_html/gallery/SCRIPT_uncookied.php on line 62

Which appears several times on each photo page

[Pekka]

OK, it's sort of working except for the error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mikeuca/public_html/gallery/SCRIPT_uncookied.php on line 62

Which appears several times on each photo page

This will happen if you restore on empty database and omit ee_uncookied table from backup. Save the following to fix.sql text file and upload it to your EE backup (/backup/ee_backup_files folder). The select it from the list and restore it.


DROP TABLE IF EXISTS `ee_message`|EE|BACKUP|
CREATE TABLE `ee_message` (
`ee_message_id` int(11) NOT NULL auto_increment,
`ee_message_text` text NOT NULL,
`ee_message_originator` varchar(255) NOT NULL default '',
`ee_message_timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ee_message_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_uncookied`|EE|BACKUP|
CREATE TABLE `ee_uncookied` (
`ee_uncookied_id` int(11) NOT NULL auto_increment,
`ee_uncookied_data` text NOT NULL,
`ee_uncookied_compression` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ee_uncookied_id`)
) TYPE=MyISAM COMMENT='uncookied data'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_uncookied_settings`|EE|BACKUP|
CREATE TABLE `ee_uncookied_settings` (
`ee_uncookied_splitter` char(50) NOT NULL default '|',
`ee_uncookied_foochar` char(50) NOT NULL default '',
`ee_uncookied_compressed` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM COMMENT='Uncookied settings'|EE|BACKUP|
INSERT INTO `ee_uncookied_settings` VALUES (',', '|...', '1')|EE|BACKUP|

[MikeCaine]

Woohoo! Thanks for that, all seems fine now. I'll just give it a good testing before I change nameservers

I take it that restore in slow mode breaks the sql file up into small chunks to get around any timeout problems? Damn good idea :-)