Re: Transfering large mysql database
| From: | Justin Patrin | Date: | Tue, 09 Dec 2003 00:19:32 +0000 |
| Subject: | Re: Transfering large mysql database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31943@lists.php.net to get a copy of this message | ||
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 HarlanWhat kind of error do you get when importing? Not sure how phpMyAdmin does it, but you can always use the mysqldump command (this is command-line, not PHP) to get a dump of any database or table. -- paperCrane <Justin Patrin>