<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body 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 class="moz-signature" cols="72">-Tina
</pre>
<br>
<br>
Néstor wrote:
<blockquote
cite="mid:a304e2d60909111426t4f24f091n3e5baa9ef341e8bf@mail.gmail.com"
type="cite">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 moz-do-not-send="true" href="mailto:rotsen@gmail.com">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>
<pre wrap="">
<hr size="4" width="90%">
--
[ Drupal support list | <a class="moz-txt-link-freetext" href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</pre>
</blockquote>
</body>
</html>