Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 mysql imort of large databases?
Google
Post new topic Reply to topic
Author Message
cyberghost101
 
 


Joined: 30 Nov 2006
Posts: 1

PostPosted: Thu Nov 30, 2006 4:40 pm Reply with quoteBack to top

Im having a big proble. I can set up the apachie server to see out fine. Can load a vBulliton forum fine. But when I try to import the sql table in the restore funstion of the mysql it does not import but a small part of the sql.
The sql table dump is like 80 mb. Phpadmin seems to have this same limitation also. I am running this on a deticated test server with a p4 3.2 processor and Windows Server 2003 Enterprise Edition. Over a gig of ram and sata drives.
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Thu Nov 30, 2006 7:59 pm Reply with quoteBack to top

cyberghost101 wrote:
Im having a big proble.

your severe wording problem should not be taken lightly either

as for big mysql imports you can do them this way

Quote:
mysql -D dbname < backup.sql

or
Quote:
mysqlimport dbname backup.sql


and obviously from the mysql console with sql commands
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
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
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT