Restoring a specific database table from a shared dump

N

niakrisn2011-07-13 10:34:32

MySQL

niakrisn, 2011-07-13 10:34:32

Greetings, tell me how to restore a specific table from a large dump in which there are many tables?

MySQL database server.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Ano, 2011-07-13
@niakrisn

awk '/CREATE TABLE `TheTable`/,/UNLOCK TABLES/' thedump.sql

W

winntpooh, 2011-07-13
@winntpooh

How was the dump done?
There are many ways and tools. It all depends on your degree of access to the server OS.
Several options:
PHPmyAdmin - well, this is a classic. I think the comments are redundant.
Sypex Dumper 2 - this is if the range of tasks is smaller, and the volume of databases is larger. Processing speed is phenomenal. There is both a free and commercial version, which differs precisely in the ability to restore specific tables, and not just the database as a whole.
EMS SQL Manager - As an application for Windows. Paid software.