Originally Posted by siva balan
in my fedora machine i gave
mysqldump <database-name> > bakup.sql
in my solaris machine i gave
mysql <newly created dbname> < bakup.sql
it shows the below error
ERROR 1064 at line 25: 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
mysql version in my fedora machine is
mysql Ver 14.14 Distrib 5.1.47
mysql version in my solaris machine is
mysql Ver 12.22 Distrib 4.0.24
please guide me
First create a blank MySQL Database, as well as a MySQL user account that has permissions to write the the database.
mysql -uuser_name -ppassword database_name < bakup.sql
Note: most mysql clients do not seme to like "-u user_name -p password" so omit the space, "-uuser_name -ppassword"