LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 03-29-2007, 08:02 PM   #1
ballistic509
Member
 
Registered: Feb 2006
Distribution: CentOS
Posts: 114

Rep: Reputation: 15
MySQL Database Import


I currently have a 6MB SQL file, phpMyadmin only allows up to 2MB. How can I import this whole file into MySQL?
 
Old 03-29-2007, 09:39 PM   #2
kstan
Member
 
Registered: Sep 2004
Location: Malaysia, Johor
Distribution: Dual boot MacOS X/Ubuntu 9.10
Posts: 851

Rep: Reputation: 31
Hi ballistic509,

inside the phpmyadmin folder, type
grep -n "max" * (Max, MAX, or etc)

to see whether have any ideal

Good luck,
Ks
 
Old 03-30-2007, 07:52 AM   #3
Guttorm
Senior Member
 
Registered: Dec 2003
Location: Trondheim, Norway
Distribution: Debian and Ubuntu
Posts: 1,136

Rep: Reputation: 230Reputation: 230Reputation: 230
I think the 2mb limit is in php.ini, not in phpmyadmin. On my server I've increased it to 40mb in php.ini and phpmyadmin says the limit is 40mb.

A simpler solution is to gzip/bzip2 the sql file before uploading. Phpmyadmin will autodetect that it's compressed and uncompress it on the fly.
 
Old 03-30-2007, 12:22 PM   #4
ballistic509
Member
 
Registered: Feb 2006
Distribution: CentOS
Posts: 114

Original Poster
Rep: Reputation: 15
Thanks both of you for your replies. As I researched into this, i learned that the best way to do bigger databases was to use the mysql command from the console so thats what I did and it worked just fine.

kstan,

When I used the command you gave I just got a screen full of information I couldnt make out lol, but thanks.
 
Old 03-31-2007, 01:26 AM   #5
kstan
Member
 
Registered: Sep 2004
Location: Malaysia, Johor
Distribution: Dual boot MacOS X/Ubuntu 9.10
Posts: 851

Rep: Reputation: 31
hi, the command will tell you what keyword you find in particular file (and the row number too). So you can slowly see through and find which file you going to ammend.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL Database Import Behrooz_Ice Linux - General 2 09-08-2006 04:15 AM
how to import mysql database to oracle LinuxLover Linux - Software 1 07-22-2006 07:30 AM
MySQL Database Import sbb Linux - Software 1 06-04-2006 11:15 AM
MySQL import database akines Linux - Software 3 04-19-2006 01:14 AM
How to import a mysql database from backup WindowBreaker Slackware 6 03-16-2006 11:08 PM


All times are GMT -5. The time now is 07:44 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration