Sluggers, I've got a large (2.6G) MySQL dump containing extended SQL inserts which I need to import onto a server.
Normally, I'd import using something like:
sudo nice mysql itm_integ < sqldump.sql
but in this case it grinds the server into the ground, presumably
because it loads the file into memory/swap as it imports.
I'm thinking I somehow need to split this file into manageable chunks to
import it, but the script I coded in PHP can't handle files of that size.
Anyone have any pointers on how I can split the file based on the string
'CREATE TABLE' or something like that? A file per table would be fine to
import.
Server is FC2 based and we're running a very old MySQL - 4.024
Thanks in advance,
Rob.
signature.asc
Description: OpenPGP digital signature
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
