How to increase import file size

Problems with the Linux version of XAMPP, questions, comments, and anything related.

How to increase import file size

Postby zayanit » 19. June 2013 05:01

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
[color=#000040][url=http://rasoulallah.net/index.php/en/home]Who is Muhammed![/url][/color]
User avatar
zayanit
 
Posts: 8
Joined: 17. June 2013 12:43
Location: Egypt
Operating System: Linux Ubuntu 13.04

Re: How to increase import file size

Postby zayanit » 20. June 2013 08:03

All posts which I saw was talking about increasing on windows by editing php.ini file
But how can I do it on Ubuntu??!!
[color=#000040][url=http://rasoulallah.net/index.php/en/home]Who is Muhammed![/url][/color]
User avatar
zayanit
 
Posts: 8
Joined: 17. June 2013 12:43
Location: Egypt
Operating System: Linux Ubuntu 13.04

Re: How to increase import file size

Postby Altrea » 20. June 2013 17:52

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: How to increase import file size

Postby zayanit » 20. June 2013 18:14

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??
[color=#000040][url=http://rasoulallah.net/index.php/en/home]Who is Muhammed![/url][/color]
User avatar
zayanit
 
Posts: 8
Joined: 17. June 2013 12:43
Location: Egypt
Operating System: Linux Ubuntu 13.04

Re: How to increase import file size

Postby Altrea » 20. June 2013 18:31

don't install anything.
navigate to the folder your mysql binary is saved
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: How to increase import file size

Postby zayanit » 20. June 2013 20:49

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.
[color=#000040][url=http://rasoulallah.net/index.php/en/home]Who is Muhammed![/url][/color]
User avatar
zayanit
 
Posts: 8
Joined: 17. June 2013 12:43
Location: Egypt
Operating System: Linux Ubuntu 13.04

Re: How to increase import file size

Postby zayanit » 21. June 2013 22:24

any suggestions for me??
[color=#000040][url=http://rasoulallah.net/index.php/en/home]Who is Muhammed![/url][/color]
User avatar
zayanit
 
Posts: 8
Joined: 17. June 2013 12:43
Location: Egypt
Operating System: Linux Ubuntu 13.04

Re: How to increase import file size

Postby LogicMonster » 01. November 2013 16:56

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:
LogicMonster
 
Posts: 1
Joined: 01. November 2013 16:52
Operating System: Ubuntu


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 27 guests