[TYPO3] Typo3 Super Noob - Site Transfering

Christopher qozmiq at gmail.com
Wed Mar 12 13:30:36 CET 2008


Do I need to transpose anything where it says...your_dump_file or just use
that verbatim?

On Wed, Mar 12, 2008 at 1:27 PM, Francois Suter <fsuter at cobweb.ch> wrote:

> Hi,
>
> > I am trying to import a very large (650mb) SQL database due to a host
> > transfer.  Does anyone suggest anything other than using myphpadmin?
>
> Well, if you have access to the command line, I would do it from there:
>
> mysql database_name -u user_name -p < your_dump_file
>
> If the database is UTF-8, add --default-character-set=utf8
>
> Otherwise, you will first need to raise the limit of file size that
> PHP accepts. Then recent version of phpMyAdmin are able to manage
> import a large dump in chunks to avoid timeout, so you should be
> fine, except that it's much slower than the command line.
>
>


More information about the TYPO3-english mailing list