Re: Transfering large mysql database
| From: | David Robley | Date: | Wed, 10 Dec 2003 03:22:40 +0000 |
| Subject: | Re: Transfering large mysql database | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31953@lists.php.net to get a copy of this message | ||
In article <20031209111303.35809.qmail@pb1.pair.com>, 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?