using phpmyadmin, you can select 'view dump' to get a text file of mysql table structure - an option exists also for getting/backup data as a text file