Error restoring database
 

Hi,

I backed up my database on Pair Network and tried to restore it through PhpMyAdmin on a new GoDaddy.com Server.

I get the following error:

SQL query:

CREATE TABLE `pp_admingroups` (

`id` int( 3 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 35 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said:

#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5


I tried to back up the database using the Photopost Admin and got these errors (which is why I used Pair's web admin to do the DB backup):

Command being used to execute dumps (specific tables are executed individually):


Results:

Warning: pp_admingroups.sql is 0 bytes or did not get created.Warning: pp_admlog.sql is 0 bytes or did not get created.Warning: pp_cache.sql is 0 bytes or did not get created.Warning: pp_categories.sql is 0 bytes or did not get created.Warning: pp_comments.sql is 0 bytes or did not get created.Warning: pp_ecards.sql is 0 bytes or did not get created.Warning: pp_exif.sql is 0 bytes or did not get created.Warning: pp_extrafields.sql is 0 bytes or did not get created.Warning: pp_favorites.sql is 0 bytes or did not get created.Warning: pp_ipcache.sql is 0 bytes or did not get created.Warning: pp_iponline.sql is 0 bytes or did not get created.Warning: pp_laston.sql is 0 bytes or did not get created.Warning: pp_notify.sql is 0 bytes or did not get created.Warning: pp_photoextras.sql is 0 bytes or did not get created.Warning: pp_photos.sql is 0 bytes or did not get created.Warning: pp_photoviews.sql is 0 bytes or did not get created.Warning: pp_settings.sql is 0 bytes or did not get created.Warning: pp_sort.sql is 0 bytes or did not get created.Warning: pp_sortmemb.sql is 0 bytes or did not get created.Warning: pp_usergroups.sql is 0 bytes or did not get created.Warning: pp_users.sql is 0 bytes or did not get created.

You should double-check your .sql files to be sure the backup completed successfully.


HELP!!

Well the difference here you most likely backed up from pair on mysql 3 and maybe restoring on mysql 4. There are a few differences. You may need your host to assist you and try restoring that backup through a SSH prompt. Otherwise you may need to restore by hand chunks at a time through phpmyadmin