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 Quote 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. ??? Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/157221-mysql-dumpfile-restore-proble/#findComment-828736 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.