how to import .sql file that is over 5mb?

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

how to import .sql file that is over 5mb?

Postby chunket » 23. April 2007 01:59

Hi,

How to import .sql file that is over 5mb file size? I have tried to import it via phpmyadmin but hit error.

I guess i have to do it in the console way with the command like below.
mysql -u root -p <

but i dont know where to put the .sql file and how to execute the above command. Please help. Thank you.

best regards
chunket
 
Posts: 5
Joined: 23. April 2007 01:53

Postby chunket » 04. May 2007 03:15

bump. no reply at all. :evil:
chunket
 
Posts: 5
Joined: 23. April 2007 01:53

Postby Mätes » 04. May 2007 08:41

ok, i'll try to help,but no guarantee for success.

i don't know the exact command, i use it not very often.

but if your file isn't much larger than 5 mb you can try the following:

try to find the two lines in the two files and
change the values. possible your max upload-value is at 5mb,
or the phpmyadmin needs longer for the import.

PHP-INI:
; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

php-myadmin - config.inc.php
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)


if your file is much larger than 5 mb, than you should use direct
mysql-commands, but i don't know how to use them, so i think you have
to ask in other messageboards.

greetings,
ma
User avatar
Mätes
 
Posts: 142
Joined: 13. April 2006 09:34
Location: kölle


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 17 guests