Mysql / export / import

[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

[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.

[Magoth78]

This will export the entire account table, sdabbs65. I'd just want the columns: "name" (account's login) and "charname" (character name attached to the account) of the table so I can source them into 2 others columns of a different table.

[sdabbs65]

Originally Posted by Magoth78

This will export the entire account table, sdabbs65. I'd just want the columns: "name" (account's login) and "charname" (character name attached to the account) of the table so I can source them into 2 others columns of a different table.

No it dont it just get's the password field from accounts.
if you want the names and password you should be able to but I never got 2
fields from a table just 1.