How to export a mySQL table

[kag]

Hi,
I'm trying to export my current mySQL table so I can import it on another computer........... is it "do-able"?

What's the command for this


thx
Guillaume

 

[RedRooster]

If you're going to do it from the command line:
Try this

Otherwise, if you're using something like phpmyadmin or some fancy front end, it should be very easy to dump the table structure and/or data.

 

[kag]

thanks
now i got another question

I'm running mySQL on machine 1 and I'm coding on machine 2. Machine1 runs Win98 (yeah I know I suck, but it's temporary), so how can I connect to mySQL from machine2?

Machine1's C: drive is mapped as J: on machine2..... and
J:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

I was used to telnet the machine running mysql, but i dont think it is possible to telnet win98....