You would do better posting to the mysql lists, as this isn't really
related to the OS.
I would suggest you use the command line utilities to load the records. I
would first slice them into chunks not too big, then iterate through
them. If the records are in some order, if you get an error, you can
pickup where you left off.
-Derek
At 08:17 AM 9/7/2006, VeeJay wrote:
Hello
Just wondering if I can get an advice from this forum?
What kind of hardware i.e.(Processor, RAM) I need to accomplish following
jobs on a FreeBSD plateform:
I have some mysql dumps around 2 GB each....with each record is 100 KB...
1. What is the best method to import them into a mysql database without
getting any "Out of Memory" Error? or freezing MySQL?
2. If I run a little Perl script and read a mysql record per iteration, how
can I avoid "illigle memory address" access errors?
Somebody talked about AMD 64 processor with FreeBSD 64 version, etc?
I will be really grateful for your kind advices/suggestions....
Regards
VeeJay
--
Thanks!
BR / vj
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
