Link to home
Start Free TrialLog in
Avatar of sunrise9s
sunrise9sFlag for Taiwan, Province of China

asked on

How can i finish this import in the current syntax

windows Mysql 5 ;  http://www.cacti.net/downloads/docs/html/install_windows.html

mysql> CREATE DATABASE cacti;
mysql> mysql -u root -p cacti < c:\apache2\cacti\cacti.sql
ERROR:
Unknown command '\a'.
    -> ;
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 'acti.
sql' at line 1
mysql>
mysql> mysql -u root -p cacti <cacti.sql
    -> ;
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 root -p cacti <cacti.sql' at line 1
mysql>
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

you have to quit MySQL command line to run that command:
mysql> CREATE DATABASE cacti;
mysql> exit;
os> mysql -u root -p cacti < c:\apache2\cacti\cacti.sql

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial