> 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

You may be striking a mysql limitation; on the import host you may need to 
increase the following configuration value to a size that will allow 
import of your data;

set-variable = max_allowed_packet=4M

Quod subigo farinam

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to