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.<br><br>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.<br>
<br>Thanks for the help and replies.<br><br>Néstor :-)<br><br><div class="gmail_quote">On Fri, Sep 11, 2009 at 6:06 PM, Tina Callahan <span dir="ltr"><<a href="mailto:tina.callahan@udel.edu">tina.callahan@udel.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
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.<br>
<br>
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.<br>
<br>
Not sure if this helps much. I'm not sure how to use the mysqldump
without having to manually create the tables.<br>
<pre cols="72">-Tina
</pre>
<br>
<br>
Néstor wrote:
<blockquote type="cite"><div><div></div><div class="h5">I meant to say 'site' instead of 'wite'<br>
<br>
And my question<br>
Is it that you can not recover from a mysqldump?<br>
<br>
should be<br>
Is it that you can not recover an INNODB databse using a mysqldump.sql
file?<br>
<br>
Thanks :-)<br>
<br>
<div class="gmail_quote">On Fri, Sep 11, 2009 at 2:21 PM, Néstor <span dir="ltr"><<a href="mailto:rotsen@gmail.com" target="_blank">rotsen@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">After
recovering my site I did a mysqldump to be able to recover easier.<br>
<br>
So decided to create a duplicate wite using the MySQL dump<br>
<br>
I go into mysql and create a database 'newsite'<br>
I read in the SQL file into the 'newsite' database<br>
I copied my scroller612 folder to newsite folder<br>
but when I go to see the 'newsite' apges, then it shows<br>
vertically.<br>
<br>
Is it that you can not recover from a mysqldump?<br>
<br>
:-(<br>
<br>
</blockquote>
</div>
<br>
</div></div><pre><div class="im"><hr size="4" width="90%">
--
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</div></pre>
</blockquote>
</div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>