[support] [drupal] HELP - I messed up my site

[Tina Callahan]

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 at gmail.com 
> <mailto:rotsen at 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/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090911/73fcfa05/attachment.htm>