Mysql / export / import

[sdabbs65]

Originally Posted by Magoth78

Hello,

I would like to export 2 columns (name and charname) from the account table.

Once it's done, I'd like to import it in a table called 'access' wich has 2 columns: Login / Password.
- the datas of the 'charname' column will go in the new Login column
- the datas of the 'name' column will go in the new Password column.

Is it possible to do that just with Mysql commands?

Thx,
Mag

you can outside of mysql

mysqldump -u sdabbs -p account password > accounts.txt

this will dump your passwords into a text file called accounts.
im not sure how to do login and password but if you toy with it you should get it working.