How do i make my Mysql Upload More Filesize to Navicat?
Printable View
How do i make my Mysql Upload More Filesize to Navicat?
MySQL has no 'file' limits.
PHP.Net has a variable for PHPMyAdmin for importing limited files, so big databases can't be imported. But I was pretty sure this wasn't at navicat?Quote:
Originally Posted by Matthew
Find and edit these lines in your "php.ini" file (C:\xampp\php\php.ini OR C:\Program Files\PHP\PHP 5.3\php.ini)
Change the 10M to another size (400M = 400 MB)Code:file_uploads = On
upload_max_filesize = 10M //needs to be in {x}M format
Navicat doesn't use PHP.. Just edit your mysql.ini, or whatever it's called
Import your dump via "MySQL Workbench" works much better and it's free.
In your my.ini : myisam_max_sort_file_size=100G