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 mailto: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/ ]