problems restoring a database I'm trying to restore a database backup to a fresh databse on a new server and its not playing:( I have tried to restore from the command line and from mysql administrator and from SQLyog* Whatever method the restore fails. The error is shown below. Can anyone help Query: DROP TABLE IF EXISTS aaggregate_temp_1228817400 Error occured at:2009-05-03 07:41:47 Line no.:1 Error Code: 1046 - No database selected Query: DROP TABLE IF EXISTS aaggregate_temp_1228817400 Error occured at:2009-05-03 07:42:14 Line no.:1 Error Code: 1046 - No database selected Query: DROP TABLE IF EXISTS aaggregate_temp_1228817400 Error occured at:2009-05-03 07:44:33 Line no.:1 Error Code: 1046 - No database selected Query: CREATE TABLE `games_savedgames` ( `gid` int(11) NOT NULL DEFAULT '0'* `uname` varchar(40) NOT NULL DEFAULT ''* `gameData` text NOT NULL* `savedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2009-10-28 10:18:46 Line no.:3834 Error Code: 1050 - Table 'games_savedgames' already exists Query: CREATE TABLE `games_savedgames` ( `gid` int(11) NOT NULL DEFAULT '0'* `uname` varchar(40) NOT NULL DEFAULT ''* `gameData` text NOT NULL* `savedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2009-10-28 10:20:52 Line no.:3834 Error Code: 1050 - Table 'games_savedgames' already exists Query: /*Data for the table `zipData` */ insert into `zipData`(`zipcode`*`ZipCodeType`*`City`*`CityType `*`State`*`StateCode`*`AreaCode`*`lat`*`lon`) values ('00501'*'U'*'Holtsville'*'D'*'New York'*'NY'*631*'40.81307'*'73.04638')*('00544'*'U' *'Holtsville'*'D'*'New York'*'NY'*631*'40.81322'*'73.04928')*('00601'*'S' *'Adjuntas'*'D'*'Puerto Ton of Zip data removed ('17759'*'P'*'Oval'*'N'*'Pennsylvania'*'PA'*570*'4 1.24033'*'77.04763') Error occured at:2009-10-28 13:41:52 Line no.:7137 Error Code: 1146 - Table 'mydb.zipData' doesn't exist |
الساعة الآن 02:39 PM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir