LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-10-2008, 10:12 AM   #1
Roosta21
Member
 
Registered: Aug 2004
Distribution: Fedora core 4
Posts: 55

Rep: Reputation: 15
Restoring individual database from a universal dump


If i backed up all data in mysql using i.e

mysqldump -u sadmin -p pass21 Customers > custback.sql

is it possible to retrieve individual databases or user from this dump?
 
Old 11-10-2008, 02:42 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Yes, but depending on it's size, a painstakingly task. You either need to do some crafty scripting or edit it to strip out the portions you want to restore.

In the future, if you have more than one database, backup each one individually to it's own dump.
 
Old 11-10-2008, 06:31 PM   #3
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,269

Rep: Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028
Actually, Customers is your DB name (see 1st option here: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html). Perhaps you meant can you restore individual tables?
 
  


Reply


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
Restoring a running mysql database mazzo Linux - Server 4 04-27-2007 11:25 AM
LXer: REAL Software Ships REALbasic 2007 Release 1; Improves Universal Binary and Database Support LXer Syndicated Linux News 0 01-03-2007 04:33 AM
restoring mysql database MrSako Linux - Software 2 12-09-2006 02:42 PM
MySQL :: Restoring Dump Swakoo Linux - General 6 09-09-2005 01:27 AM
Help restoring file permissions from a Dump bminish Linux - Newbie 3 12-12-2004 01:34 PM


All times are GMT -5. The time now is 01:35 PM.

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