|
|
Posted by pwiegers@gmail.com on 12/31/06 15:34
Brian Huether schreef:
> My webhost does not give me shell access. Normally, I use this sort of
> command on my local machine:
>
> c:\data> c:\mysql\bin\mysql -uroot -pxxxxx db < file.sql
>
> My webhost gives me PhpMyAdmin access, but I can never use that successfully
> with large files. The sql file I need to import is 15MB.
This is a tricky one. I tried it myself, and only succeded by splitting
the large dump by hand, using a editor. Then you can upload it by php
myadmin.
I used this command:
mysqldump -uuser -p database --compatible=mysql323
--set-variable=net_buffer_length=16384 > totaaldump20061027
to get a format that is easily editable by hand...
It worked for me.. if you find a better solution, I'm all ears....
Paul
Navigation:
[Reply to this message]
|