Thursday, 17 December 2015

Importing Multiple Files to MYSQL database


Import multiple files of mysql dump .SQL files: (Example: many dump files containing table structure and data)

This is through Linux Terminal:
cd /glide/mysql/server/bin


ls -1 /glide/tempbackup/dumped_data/*.sql | awk '{ print "source",$0 }' | ./mysql --batch -u username -p databasename

Once data imported, go to MYSQL terminal and see those imported data:

From Terminal: sudo -su mysql
From Terminal: export PATH=/glide/mysql/server/bin:$PATH
From Terminal mysql -u root -p  (This command will prompt you to enter the mysql root password)

No comments:

Post a Comment