List:General Discussion« Previous MessageNext Message »
From:Brent Clark Date:March 10 2011 6:35pm
Subject:mysql < vs source
View as plain text  

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
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.

mysql < vs sourceBrent Clark10 Mar
  • Re: mysql < vs sourceDan Nelson10 Mar