Page 1 of 1

Unable to import Database

PostPosted: 12. May 2008 07:14
by donleehk
I had install 'xampp-linux-1.6.6.tar.gz' on my mandriva machine
Setup everything, including the security.

MyPHPAdmin just could not import a database.
I even tried to export a database from the MyPHPAdmin.
Den maunally drop that database.
Tried to import but always failed

Is there any configuration i might missed out?

Below are the pics:

The Error Msg
Image

The Sql File which i exported
Image

PostPosted: 14. May 2008 20:21
by gunni49
Hi there,

Your error message seems to be related to the standard settings in the php.ini. To check your settings go to /opt/lampp/etc and download the file php.ini. Open the file with a text editor f.e vim and search for "size". You will find

; Maximum size of POST data that PHP will accept.
post_max_size = 8M

and

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

There you have to make the necessary modifications depending on the filesize of your sql database. I have set for both sections 32M.

Gunni

PostPosted: 31. May 2008 09:34
by sizuki
gunni49 wrote:Hi there,

Your error message seems to be related to the standard settings in the php.ini. To check your settings go to /opt/lampp/etc and download the file php.ini. Open the file with a text editor f.e vim and search for "size". You will find

; Maximum size of POST data that PHP will accept.
post_max_size = 8M

and

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

There you have to make the necessary modifications depending on the filesize of your sql database. I have set for both sections 32M.

Gunni


Not work for me..., my sql file only 10 kB