mysql importing inq

Robin01 · 11-29-2003, 07:33 PM

mysql> show databases;
+------------+
| Database |
+------------+
| mysql |
| tutorial |
| testdb1 |
+------------+

mysql> tutorial < ./var/www/html/testingsite/catalog/install/learning.sql;
ERROR 1064: 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 'oscommerce < ./var/www/html/testingsite/catalog/install/learning

why am i not able to import the database

bleah-man · 11-30-2003, 09:12 AM

try

cd /var/www/html/testingsite/catalog/install/
mysql -u<yourusername> -p<yourpassword> <nameofdatabase> < learning.sql

then

mysql -u<yourusername> -p<yourpassword> <nameofdatabase>

and

mysql> <your query string>

Bleah!