Re: Transfering large mysql database
| From: | J.Veenhuijsen | Date: | Tue, 09 Dec 2003 11:13:12 +0000 |
| Subject: | Re: Transfering large mysql database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31947@lists.php.net to get a copy of this message | ||
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