Hi. I've created a MySQLDump of a quite large database, and am trying to re-import the data into it. When I created it, I didn't invoke the drop tables stuff with --add-drop-tables. Is there a way I can do this with 'mysql' ? i.e....

mysql --drop-tables -uxxx -pxxx DatabaseName < file.sql

... or is it a case of having to totally wipe the database, and re-doing it from scratch with the MySQLDump file? I'm hoping there is a different option to the latter

TIA

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

You could open up the dump file and before every CREATE TABLE statement add a DROP TABLE IF EXISTS table_name statement.

Cheers,

Alex
--
Gossamer Threads Inc.

Its 1.8Gb in size

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Use TextPad to open the file, which can handle files past 2.0 GB.
========================================
Buh Bye!

Cheers,
Me

Create a drop.sql that just has the drop table statements, then run that one first, and then the other sql. Alternatively, join them together (cat main.sql >> drop.sql).

Cheers,

Alex
--
Gossamer Threads Inc.