Go Job Hunting at the LQ Job Marketplace
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 07-22-2011, 05:25 AM   #1
Registered: Jan 2011
Location: Dhaka
Posts: 80

Rep: Reputation: 1
Restore 200+ mysql database with shell script


I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.

Thanks for your help in advance!
Old 07-22-2011, 06:16 AM   #2
Registered: May 2010
Location: Nairobi, Kenya
Distribution: Ubuntu
Posts: 66

Rep: Reputation: 3
i suggest u check out this page to see if its of help to your case


mysqldump, scripting

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] mysql will not restore database moodah Linux - Server 2 02-22-2011 03:02 PM
How do I Restore a mysql database ? Glenn D. Linux - Software 1 07-30-2010 08:12 AM
how to interact with mysql database using shell script vinaytp Linux - Newbie 3 04-24-2009 07:46 AM
mysql database restore help compused Linux - General 3 10-28-2008 04:48 PM
Import records to MySQL Database from a shell script chrisk5527 Linux - General 12 03-24-2004 09:49 PM

All times are GMT -5. The time now is 10:42 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration