Why dont you gzip the files of database and write them in a CD? Its safe and (maybe) faster if the tables are large files. Nikos > ----- Original Message ----- > From: "J.Veenhuijsen" <info@xxxxxxxxxxxxxxxx> > To: <php-db@xxxxxxxxxxxxx> > Sent: Tuesday, December 09, 2003 1:13 PM > Subject: Re: Transfering large mysql database > > > > 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
