Solved

How can i finish this import in the current syntax

Posted on 2007-03-22
2
330 Views
Last Modified: 2009-12-16
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>
0
Comment
Question by:sunrise9s
  • 2
2 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18772047
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

0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 18772059
alternative: use the SOURCE command:

http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

mysql> CREATE DATABASE cacti;
mysql> source -u root -p cacti < c:\apache2\cacti\cacti.sql
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Creating and Managing Databases with phpMyAdmin in cPanel.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now