Linode Forum
Linode Community Forums 		 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development
  Previous topic | Next topic 
Author Message
sisko
 Post subject: phpmyadmin php.ini
PostPosted: Thu May 27, 2010 9:06 am 
Offline
Senior Newbie

Joined: Thu May 27, 2010 9:00 am
Posts: 14
Hi guys,

the problem is I need to import an sql dump into phpmyadmin so I can
populate my fresh database with the contents of a previous one.

But the file upload size setting in Linode is too small. As I understand it, the change needs to be made in phpmyadmins php.ini ??

Can someone tell me if that is right, where I find this file and what I edit ... please ?
Top
   
Reply with quote  
jax
 Post subject:
PostPosted: Thu May 27, 2010 9:43 am 
Offline
Junior Member
User avatar

Joined: Wed Aug 13, 2003 12:13 am
Posts: 29
Website: http://parazoid.net
AOL: maristgeek
Location: NY
That depends on what distro you installed, the file is somewhere in /etc assuming you installed the distro's packages for php instead of source. Go to /etc and do a find for php.ini.
Top
   
Reply with quote  
sisko
 Post subject:
PostPosted: Thu May 27, 2010 10:15 am 
Offline
Senior Newbie

Joined: Thu May 27, 2010 9:00 am
Posts: 14
jax wrote:
That depends on what distro you installed, the file is somewhere in /etc assuming you installed the distro's packages for php instead of source. Go to /etc and do a find for php.ini.


Thanks for responding.

I am working with the Ubuntu 10 distro.

I amended etc/php5/apache2.php.ini and added the following at the very bottom of the file:

Code:
php_flag upload_max_filesize 50M
php_flag max_execution_time 300
php_flag memory_limit 64M


I then executed :
Code:
sudo apache2ctl restart


Upon refreshing and attempting to reload my sql dump, it still timed out.
Phpmyadmin still has a value of Max: 2,048 KB next to the fileupload
Top
   
Reply with quote  
Guspaz
 Post subject:
PostPosted: Thu May 27, 2010 10:40 am 
Offline
Senior Member
User avatar

Joined: Tue May 26, 2009 3:29 pm
Posts: 1691
Location: Montreal, QC
You shouldn't be using phpmyadmin to import large SQL datasets, you should be doing it with the mysql commandline tool.

IIRC the syntax was something like:

myfile.sql > mysql -u guspaz -p

Although what other parameters you need (such as database) depend on what's in the script.
Top
   
Reply with quote  
sisko
 Post subject:
PostPosted: Thu May 27, 2010 11:11 am 
Offline
Senior Newbie

Joined: Thu May 27, 2010 9:00 am
Posts: 14
Guspaz wrote:
You shouldn't be using phpmyadmin to import large SQL datasets, you should be doing it with the mysql commandline tool.

IIRC the syntax was something like:

myfile.sql > mysql -u guspaz -p

Although what other parameters you need (such as database) depend on what's in the script.


Ok, I was not aware of that. I'will try that shortly.

Could you tell me if that mysql command is active from a specific directory or just any where?
And perhaps the general syntax of how to upload from my desktop to mysql on my remote server, please.

Thanks
Top
   
Reply with quote  
bryantrv
 Post subject:
PostPosted: Thu May 27, 2010 11:45 am 
Offline
Senior Member
User avatar

Joined: Fri Dec 11, 2009 7:09 pm
Posts: 168
sisko wrote:
I am working with the Ubuntu 10 distro.

I amended etc/php5/apache2.php.ini and added the following at the very bottom of the file:

Code:
php_flag upload_max_filesize 50M
php_flag max_execution_time 300
php_flag memory_limit 64M



Did you look at the rest of that file for the settings? On my Debian Lenny install there is a setting already in /etc/php5/apache2/php.ini :
Code:
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
upload_max_filesize = 8M


; Maximum number of files that can be uploaded via a single request
max_file_uploads = 50

_________________
--
Chris Bryant
Top
   
Reply with quote  
rsk
 Post subject:
PostPosted: Thu May 27, 2010 5:19 pm 
Offline
Senior Member
User avatar

Joined: Tue Nov 24, 2009 1:59 pm
Posts: 362
Guspaz wrote:
myfile.sql > mysql -u guspaz -p

*facepalm*

That'll give a "command not found" error and create empty file called mysql. You want to READ the file, and > is "capture the output".

Code:
mysql DatabaseNameHere -u UsernameHere -p < filename.sql

It'll prompt for password.
Top
   
Reply with quote  
devjonfos
 Post subject:
PostPosted: Thu May 27, 2010 9:35 pm 
Offline
Junior Member
User avatar

Joined: Thu Apr 29, 2010 3:32 pm
Posts: 44
Website: http://devjonfos.net
Location: Oregon
sisko wrote:
...
And perhaps the general syntax of how to upload from my desktop to mysql on my remote server, please.
...


There's a Linode library guide here: http://library.linode.com/networking/file-transfer/
FileZilla allows you to use SFTP with your PuTTY key.
Top
   
Reply with quote  
Guspaz
 Post subject:
PostPosted: Fri May 28, 2010 1:17 pm 
Offline
Senior Member
User avatar

Joined: Tue May 26, 2009 3:29 pm
Posts: 1691
Location: Montreal, QC
rsk wrote:
Guspaz wrote:
myfile.sql > mysql -u guspaz -p

*facepalm*

That'll give a "command not found" error and create empty file called mysql. You want to READ the file, and > is "capture the output".

Code:
mysql DatabaseNameHere -u UsernameHere -p < filename.sql

It'll prompt for password.


Wups. My excuse will be insufficient sleep. I do know the difference ;)
Top
   
Reply with quote  
Rog_Enk
 Post subject:
PostPosted: Sat May 29, 2010 2:55 pm 
Offline
Senior Newbie

Joined: Sat May 29, 2010 2:48 pm
Posts: 5
Location: Cambs, UK
sisko wrote:
Could you tell me if that mysql command is active from a specific directory or just any where?


You can run that pretty much any where, but you will of course need to specify the source file including it's path unless it is in the directory from which you issue the mysql command.

Have you already created the database to receive the import?

sisko wrote:
And perhaps the general syntax of how to upload from my desktop to mysql on my remote server, please.

Thanks


If Windows is you usual OS you may want to try WinSCP for your file transfers.
As well as being free (a quick google will get you the download) it can also be used for quick file edits ;)
Top
   
Reply with quote  
Display posts from previous:  Sort by  
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development


Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group