Home

Exporting and Importing a mySQL Database


Tags: 

Export:
       mysqldump -u username -ppassword database_name > db_backup.sql

Import:
       mysql -u username -ppassword database_name < db_backup.sql

»
mysql importing VERY big files to tables
Submitted by Jarek Lotz (not verified) on Thu, 01/27/2011 - 11:26.

If U realy NEED to load data to tables (eg. 50G file 100mln records) use:

LOAD DATA LOCAL INFILE 'X:/FOLDER/FILE.DAT' INTO TEBLE TABLE.NAME ETC...

50G FILE -> 2 MINUTES (WITHOUT INDEXES, COMPOSIT INDEXES ETC..)

JAREK LOTZ

»