shah Posted May 7, 2009 Share Posted May 7, 2009 hi every one. I have a mysql dump file which was made in phpmyadmin. now i want to import it using mysql. i write the following command in mysql command line mysql> mysql -u 'arif' -p 'Ericsson' 'booktorn_simplenotefreetag' < 'booktorn_si mplenotefreetag.sql'; The error that i get is the following. ERROR 1064 (42000): 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 'mysql -u 'arif' -p 'Ericsson' 'booktorn_simplenotefreetag' < 'booktorn_simplenot' at line 1 I would appreciate if some one could help me with an example or could tell me where am i making the mistake. Thank you Link to comment https://forums.phpfreaks.com/topic/157221-mysql-dumpfile-restore-proble/ Share on other sites More sharing options...
shah Posted May 7, 2009 Author Share Posted May 7, 2009 i even tried to remove the single quotes like below mysql> mysql -u 'arif' -p 'Ericsson' 'booktorn_simplenotefreetag' < 'booktorn_simplenotefreetag.sql'; but no use. ??? Link to comment https://forums.phpfreaks.com/topic/157221-mysql-dumpfile-restore-proble/#findComment-828401 Share on other sites More sharing options...
fenway Posted May 7, 2009 Share Posted May 7, 2009 Why are you quoting the filenames? Link to comment https://forums.phpfreaks.com/topic/157221-mysql-dumpfile-restore-proble/#findComment-828736 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.