copying table

[johno77]

Hello

I am not very familiar with mysql but am having to port a table i have created to another machine. I am running the latest mysql. Could someone please inform me how this is possible from the command line.

thanks

 

[hos2]

if you have phpmyadmin you can export you're table with structure and data as an sql statement. you can run that statement on the other machine in mysql and everything is the same then.

sorry don't know how to do this from commandline

 

[tshot]

if both machines have mysql the either use PhpMyAdsmin as hos2 suugested or if any one of them is Windows then u can try MySql Front from

http://www.mysqlfront.de.

Alternatively, cmd line options are
From Unix cmd line

mysqldump  -e --add-drop-table -u username -h mysqlserver -p dbname tablename > tbl.sql

and resotre as (on unix cmd line)

mysql -u user -h 2ndserver -p newdbname < tbl.sql

alternatively from mysql prompt

select * into tbl.txt FROM mytable

here u require FILE privilege. u cans also import/export as CSV format





----------------
ur feedback is a very welcome desire