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@udel.eduwrote:
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/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]