Apache2Triad Help, Support and Development Forum Index Apache2Triad Help, Support and Development
The apache2triad help , support and development forums
 

mysql imort of large databases?
Click here to go to the original topic

 
       Apache2Triad Help, Support and Development Forum Index -> Databases
View previous topic :: View next topic  
Author Message
cyberghost101



Joined: 30 Nov 2006
Posts: 1

Posted: Thu Nov 30, 2006 4:40 pm    Post subject: mysql imort of large databases?  

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.
Back to top  
Vlad Alexa Mancini



Joined: 07 Jul 2003
Posts: 1538

Posted: Thu Nov 30, 2006 7:59 pm    Post subject: Re: mysql imort of large databases?  

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
Back to top  
 
       Apache2Triad Help, Support and Development Forum Index -> Databases
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.13 © 2001, 2002 phpBB Group