MySQL: Copy One Field From a Table To a File?

Backup one field from a table

[hgolov]

I want to test some changes in my table declaration before actually changing the original table. So I'd like to copy one column to a file and put it in a new table and run the changes and tests. How can I do this from phpMyAdmin?
Thanks for your help!

[le_gber]

not sure how to do it with phpMyAdmin but I usually use DBTools when I want to copy DB's or DB tables.

Try googleing it, it's a free tool.

[physics]

Hi hgolov, welcome to WebmasterWorld.com!
In phpMyAdmin you can go to the 'Operations' tab all the way to the right when you're viewing a table.
Then from there you can choose to copy that table to a new database (make sure you create a new database first if you want to do that ... or you can back it up by adding _bk to it's name or something like that).
Make sure to copy structure _and_ data.