I may be wrong about this, but I don't think the mysqldump has create statements in it. So - it can't restore tables if the table spaces don't exist.

I usually use phpmyadmin or mysql to create a backup of a table and ask this to include create statements. Then when I create an empty database, I just use copy the sql file completely into the sql command box.

Not sure if this helps much. I'm not sure how to use the mysqldump without having to manually create the tables.

-Tina

Néstor wrote:

I meant to say 'site' instead of 'wite'

And my question
Is it that you can not recover from a mysqldump?

should be
Is it that you can not recover an INNODB databse using a mysqldump.sql file?

Thanks :-)

On Fri, Sep 11, 2009 at 2:21 PM, Néstor <rotsen@gmail.com> wrote:

After recovering my site I did a mysqldump to be able to recover easier.

So decided to create a duplicate wite using the MySQL dump

I go into mysql and create a database 'newsite'
I read in the SQL file into the 'newsite' database
I copied my scroller612 folder to newsite folder
but when I go to see the 'newsite' apges, then it shows
vertically.

Is it that you can not recover from a mysqldump?

:-(
--
[ Drupal support list | http://lists.drupal.org/ ]