In article <20031209111303.35809.qmail@xxxxxxxxxxxx>, info@solid- digital.nl says... > 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 Cheers -- 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
