[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: convert  access data to mysql data ?...
From:       Sasha Pachev <sasha () direct1 ! com>
Date:       1999-06-30 16:48:12
[Download RAW message or body]

"Mr. B.HARI" wrote:
> 
> Dear  Sir,
> 
> We have access database.
> Now our objective is  to load these tables  as mysql  tables   in to
> MYSQL  SERVER
> We have tried several  methods    but could not do it?
> 
> In our local NTSERVER  we could able to convert access to mysql table
> in the follwing ways.
> 
> I) converted  the  access files into text files
> 
> II) LOAD DATA INFILE ?c:\\textfile? INTO TABLE ?mysql table name? is
> command used
>   for storing text files into mysql files.
> III) they were stored  in the   local NTSERVER/DATA directory.
> 
> But same thing we could not do  for  mysql  SERVER   our ISP is
> Communitech,  our server  is  mars
> 
> I am facing an error ?access denied to username@localhost ?
> 
> Please let us know how to  store data?
> 
> Bharadwaj
> 

Your privilege system is not properly configured. Make sure to read the
sections of the manual (#6 I believe) on the privilege system.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread6286@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]