[snip] mysql -u root -p dbname < backupname.sql And getting:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 [/snip] Can we see the first 10 lines of backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]