mysqlimport problem

alaios · 03-17-2006, 06:28 AM

Hi i have a mysql file localhost.sql which starts with
--
CREATE DATABASE `2enoriaka_gr`;
USE 2enoriaka_gr;

-- --------------------------------------------------------

--
-- Table structure for table `mos_banner`
--

I have tried to import it withy mysqlimport command but i didnt make it because it needs as parameter the database name which is not created

RobertP · 03-17-2006, 08:17 AM

Just use mysql. It can execute the commands from the file.
mysql -u root -p < localhost.sql
Supply the password for the root user of the mysql database management system.

alaios · 03-17-2006, 09:15 AM

Thx a lot .. but change the << with <

RobertP · 03-17-2006, 01:08 PM

Oops! I usually do a lot of >> and I was thinking backwards...