Load Data

Hi,
For example we use mysqldump to backup one DB with several tables inside. Can we use 'LOAD DATA INFILE ’ to extract it to one PC with Mysql inside, by auto. creating both the DB and all the tables?

Did you try?