Re: Steps to importing table data. - Daniel da Veiga - com.mysql.lists.win32

16 messages in com.mysql.lists.win32Re: Steps to importing table data.

From	Sent On	Attachments
John Fitzsimons	20 Nov 2004 18:07
Daniel da Veiga	20 Nov 2004 20:26
John Fitzsimons	20 Nov 2004 21:41
Patrick Questembert	21 Nov 2004 03:32
John Fitzsimons	21 Nov 2004 05:11
Daniel da Veiga	22 Nov 2004 06:50
John Fitzsimons	04 Dec 2004 15:55
John Fitzsimons	04 Dec 2004 23:11
Graeme St.Clair	05 Dec 2004 15:46
Fred Friedman	08 Dec 2004 05:55
Danny Willis	08 Dec 2004 14:25
Danny Willis	08 Dec 2004 14:33
Randy Clamons	08 Dec 2004 14:47
Danny Willis	14 Dec 2004 18:34
Randy Clamons	14 Dec 2004 19:17
Danny Willis	14 Dec 2004 19:29

Subject:	Re: Steps to importing table data.
From:	Daniel da Veiga (dani...@gmail.com)
Date:	11/20/2004 08:26:22 PM
List:	com.mysql.lists.win32

PhpMyAdmin is good, of course, but you see, it really hides a lot of details that you'll step on while you're a developer, it would be good if you learn the commands (console, SQL) instead of using this kind of wizard. Even if your machine isn't the server, you can install the client and connect to the database via console. The command "grant all privileges on *.* to 'jf'" might work... To import data, the command "load data infile" is a good way.

Best regards,

On Sun, 21 Nov 2004 13:07:28 +1100, John Fitzsimons <joh...@net2000.com.au> wrote:

Hi,

I still haven't solved my "1044 Access Denied" error...

http://www.aspects.org.au/sqdb4.jpg

even though Randy suggested that some edition of phpMyAdmin might have a 'Privileges' tab that could be the answer.

As can be seen at ;

http://www.aspects.org.au/sun1.jpg

There is no 'Privileges' tab. :-(

I thought however that someone here might be able to at least tell me whether I am taking the correct steps to importing data into a database and creating a table from it. Here are the steps I take....

(A) I go to phpMyAdmin 2.6.0

(B) Then double Click on my database jf_invcomma

(D) Where it says "Location of the textfile" I browse to my .sql tables file on my PC.

(E) I then press "go"

Does anyone know whether these are the correct steps please ? Or perhaps know a solution to the original problem ?

I am attempting this on a web server's Unix host.

Regards, John.