So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up, so i think it
was a compatability issue.
Now - I don't want to un-install mysql on the new
server so I did a dump from the test server and tried
to import it but it encountered some errors on the way
and imported only 9 tables out of 14.
So, I dumped table by table and imported table by
table and was able to import 12 tables and found out
the tables that were giving problems. They are syntax
errors, however - I have been battling with them over
the past 8 hours, everything seems right to me and
they run on the old version of mysql I copied the frm,
MYD and MYI files to - but when I did a dump to the
same server on another database or the new server - it
gives the ff errors.
1.
CREATE TABLE xrates (
date date default NULL,
time time NOT NULL default '00:00:00',
amount_from decimal(15,5) NOT NULL default
'0.00000',
currency_from char(6) NOT NULL default '',
amount_to decimal(15,5) NOT NULL default '0.00000',
currency_to char(6) NOT NULL default '',
order tinyint(1) unsigned NOT NULL default '0',
UNIQUE KEY date (date,currency_from,currency_to)
) TYPE=MyISAM;
MySQL says
ERROR 1064: You have an error in your SQL syntax near
'order tinyint(1) unsigned NOT NULL default '0',
UNIQUE KEY date (date,currency' at line 8
2.
CREATE TABLE user_log (
id mediumint(8) NOT NULL auto_increment,
number varchar(7) NOT NULL default '',
when timestamp(14) NOT NULL,
what varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL says
ERROR 1064: You have an error in your SQL syntax near
'when timestamp(14) NOT NULL,
what varchar(255) NOT NULL default '',
PRIMARY ' at line 4
Plz assist.
__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
