Yes, you are probably pretty screwed since it sounds like your dump doesn't include the necessary create statements.
If you sourced a version of the peq database that matches the schema of your dump you could truncate each table (perhaps heidi lets you select them all at once for this) and then source your dump into the empty but created tables.
mysqldump will create a file that includes the necessary drop/create statements to recreate the exact same database. The same options probably exist in Heidi as you saw a little too late, but I'm not familiar enough with it to know for sure.
|