You can use phpmyadmin to export structure and data. You have to be aware that the first line of the output has to commented (# at start of line) Otherwise phpmyadmin generates an error.
Jochem
Harlan Lax wrote:
Does anyone have a recomendation on an app that will help me transfer a large table from one host provider to another. I have tried phpmyadmin but if I export to SQL the import doesn't seem to work. If I export to csv I lose the column formating.
On one host I have access to the root and on the other I am very limted.
Thanks Harlan
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php