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

[Néstor]

I actualy did a dump using phpmyadmin and when read in the file, the site
was messed up.  I am wondring if there is another way to do a dump for
INNODB files.

The mysql system admin tools 1.1 has a tool that allows you to set up things
and one of them is for backing up the database.  I just do nto how to run
it.  I need to read about.

Thanks for the help and replies.

Néstor :-)

On Fri, Sep 11, 2009 at 6:06 PM, Tina Callahan <tina.callahan at udel.edu>wrote:

>  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> 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/ ]
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090912/563f055f/attachment.htm>