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