You should be able to pull each table (create + inserts) out into a stand
alone file
table1.sql
table2.sql
etc...
and then you can restore table by table.
This might be harder depending on the size of your database tables. If you
have a million rows, chances
are your .sql file is huge and it would require a pretty robust text editor
that could handle such a big file.
In vi you could just locate the 1st line of the CREATE and the last line of
the last insert (before the next create)
and then do : 1,100 w table1.sql
----- Original Message -----
From: "kent stand" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, March 08, 2006 1:17 PM
Subject: Restoring a database from a complete MySQL dump
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then
downgraded again, back to 4.1.14. I took a complete dump of all
databases/tables into a .sql file, and now I would like to restore just
specific databases or tables from it.
Is this possible without restoring everything or without having to restore
everything somewhere else, and then make new back-ups of the specific
tables/databases?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]