In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> 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.
> 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?
Q: What is the most annoying thing on usenet?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php