LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysqlimport problem (https://www.linuxquestions.org/questions/linux-software-2/mysqlimport-problem-425703/)

alaios 03-17-2006 06:28 AM

mysqlimport problem
 
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...:tisk:


All times are GMT -5. The time now is 04:03 AM.