Page 1 of 1

Restore Old Database

PostPosted: Sat Oct 20, 2007 8:00 am
Author: dan0042
Hello Doin Best Restore Old Database from 2006....

Got mysqldumper But geting this On intill


Error in Query:

CREATE TABLE phpbb_cf_ip_to_iso3661_1( from int(11) unsigned NOT NULL, to int(11) unsigned NOT NULL, iso3661_1 enum('AD','AE','AF','AG','AL','AM','AN','AO','AQ','AR','AS','AT','AU','AW','AZ','BA','BB','BD','BE','BG','BH','BI','BJ','BM','BN','BO','BR','BS','BT','BW','BY','BZ','CA','CD','CF','CG','CH','CI','CK','CL','CM','CN','CO','CR','CS','CU','CV','CY','CZ','DE','DJ','DK','DM','DO','DZ','EC','EE','EG','ER','ES','ET','FI','FJ','FK','FM','FO','FR','GA','GB','GD','GE','GF','GH','GI','GL','GM','GN','GP','GQ','GR','GT','GU','GW','GY','HK','HN','HR','HT','HU','ID','IE','IL','IN','IO','IQ','IR','IS','IT','JM','JO','JP','KE','KG','KH','KI','KM','KN','KR','KW','KY','KZ','LA','LB','LC','LI','LK','LR','LS','LT','LU','LV','LY','MA','MC','MD','MG','MH','MK','ML','MM','MN','MO','MP','MQ','MR','MT','MU','MV','MW','MX','MY','MZ','NA','NC','NE','NF','NG','NI','NL','NO','NP','NR','NZ','OM','PA','PE','PF','PG','PH','PK','PL','PR','PS','PT','PW','PY','QA','RE','RO','RU','RW','SA','SB','SC','SD','SE','SG','SI','SK','SL','SM','SN','SO','SR','ST','SV','SY','SZ','TD','TF','TG','TH','TJ','TK','TL','TM','TN','TO','TR','TT','TV','TW','TZ','UA','UG','US','UY','UZ','VA','VC','VE','VG','VI','VN','VU','WS','YE','YT','ZA','ZM','ZW') DEFAULT 'AD' NOT NULL, KEY from (from, to) );
MySQL says:

Couldn't create table: phpbb_cf_ip_to_iso3661_1
..............................................................................

Thats Old ip flag mod ?

Re: Restore Old Database

PostPosted: Sat Oct 20, 2007 8:30 am
Author: Helter
im having a smilar problem with bigdump.php. I know the sql is correct because I can manually paste it in phpmyadmin and id reports no errors. I havent had tme to look into it further, but ill post it is I come up with something.

PostPosted: Sat Dec 01, 2007 8:10 am
Author: dan0042
hello HelterSkelter

any fix yet mate

Re: Restore Old Database

PostPosted: Sat Dec 01, 2007 11:36 am
Author: Helter
sorry, still no solution to this <img>

Re: Restore Old Database

PostPosted: Sat Dec 01, 2007 2:07 pm
Author: found it
I always use [url=http]mysqldumper[/url] for database back ups .... never a problem FYI