DM wrote:

Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 running Mysql 3.23.37 and restore it to a new Dell PowerEdge running Redhat 7.3 with Mysql 3.23.55.

I have tried from both the command line and using phpmyadmin
With Command line /usr/bin/mysql database -uuser -ppassword < 
/var/lib/mysql/mysql_database2003_0320.sql I get an error 1054 relating to a Colum count and field 
"net" which do not appear in the database anywhere.

D.Murray


Have you checked this 'net' field. Have you dropped the field from the table since making the backup?
Try adding a 'net' field to the current table to make the import happy. If you don't know what it was, just make it varchar(100) or something, then drop it after the import if you don't want it.


--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to