Apache Friends Support Forum

Hi everyone,
I search in the forum about how to increase import file size but I have no results here http://community.apachefriends.org/f/search.php?keywords=Increase+import+file+size
I have database which it's size is 165.2MB.
I want to import it into phpmyadmin. My system is Ubuntu 13.04

All posts which I saw was talking about increasing on windows by editing php.ini file
But how can I do it on Ubuntu??!!

The answer for dumping and importing large files / databases is always the same for all systems:
Don't use php for it.

Import your database files in the command line in the connection command
http://www.cyberciti.biz/faq/mysql-import-command/
https://dev.mysql.com/doc/refman/5.5/en/mysql.html

export your databases in the command line with mysqldump
http://blog.saunderswebsolutions.com/ex ... ysql-dump/
https://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

Thank you,
I use this

Code: Select all

mysql -u root -p users < /media/zayan/PHP/DBs/users.sql

and I have this message

Code: Select all

The program 'mysql' is currently not installed. You can install it by typing:
sudo apt-get install mysql-client-core-5.5

If I install it every thing goes right?? or I will have any problem with xampp??

don't install anything.
navigate to the folder your mysql binary is saved

Sorry, I don't understand you.
I search here http://dev.mysql.com/doc/refman/5.0/en/installation-layouts.html
but I don't know what should I do.

any suggestions for me??

FYI new users. I had to type in the FULL PATH to the "mysql" and full path to the database.

It is located in /opt/lampp/bin (if you used xampp to install mysql)

Example command that worked:
$ /opt/lampp/bin/mysql -u root -p cacti < /opt/lampp/htdocs/cacti/cacti.sql
Enter Password: