I did a dump of a table from another database table and wanted to run the .sql file in another database. I used PHPadmin to do this and used phpadmin to run the .sql file against the other database
I have this is the error from mysql: SQL-query : CREATE TABLE tblmembers ( ID int(11) default NULL, FirstName text, Initial text, LastName text, Address1 text, Address2 text, City text, State text, Zip text, HomePhone text, WorkPhone text, Fax text, Email text, Userid text, Password text, Registered datetime default NULL, Modified datetime default NULL, Modified By text ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'By text ) TYPE=MyISAM' at line 19 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php