Page 1 of 1

import a database

PostPosted: 02. July 2021 13:42
by dotKer
I have a database file named "myDB1.sql" which size is 501KB and it has several tables.

I like to import "myDB1.sql"

(1) I open phpMyAdmin.
(2) I create a database named "myDB1".
(3) I select myDB1 among database list.
(4) I click the button "import"
(4) I choose myDB1.sql
(5) I click the EXE button.

Then
it says like the following
Incorrect format parameter

As I look at carefully the import screen of phpMyAdmin, I found "maximum : 40MB" next to the file selection button.
Because the size of "myDB!.sql" is more than 40MB, I guess it produces error.
I don't know how to make the mximum file size more than 40MB.
Can I import myDB1.sql successfully with your help?

Re: import a database

PostPosted: 02. July 2021 15:13
by Altrea
501KB is less than 40MB

Re: import a database

PostPosted: 02. July 2021 15:28
by dotKer
Altrea wrote:501KB is less than 40MB

I am afraid I was careless.
I see just the number 501 and 40 and didn't see the unit KB and MG.
I was blind because I was frustrated by "Incorrect format parameter".
Then, what problem cause the the error "Incorrect format parameter"?
How to fix it?