I just found that I can run mysql db -e 'source exporteddbdata.sql'
The question I would like to ask is. Is there a speed difference between
mysql db < exporteddbdata.sql and mysql db -e 'source exporteddbdata.sql' (using source)
Reason im asking is, I got a exported 5.4GB database file, and I need to import it as quickly as possible. When I initially testing it, is ran for 170m40.935s
Generally I just scp the files (learnt this from Mylvmbackup), but the problem is, is that the source DB is Mysql 5.1 and the target is Mysql 5.0.
Thanks Brent
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Mar 10
Dan Nelson Re: mysql < vs source
Mar 10, 2011; 13:55
Dan Nelson
Re: mysql < vs source
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!