Re: Transfering large mysql database
| From: | Nikos Gatsis | Date: | Tue, 09 Dec 2003 18:54:29 +0000 |
| Subject: | Re: Transfering large mysql database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31951@lists.php.net to get a copy of this message | ||
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@solid-digital.nl>
> To: <php-db@lists.php.net>
> Sent: Tuesday, December 09, 2003 1:13 PM
> Subject: [PHP-DB] 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
> >
>