1 |
Hey list, |
2 |
|
3 |
I too had problems with a single database that didn't restore correct.. |
4 |
A rather large one (a few mb's) that was in a single line in the |
5 |
backupfile that was suggested in the guide. After I removed that line |
6 |
from the guide, the databases restored correctly and I had no other |
7 |
problems upgrading mysqld. |
8 |
|
9 |
So now I'm running two mysqld's - one for the db that didn't restore, |
10 |
and one for all the others. Just untill I , or someone else , find out |
11 |
how to do this so it works. |
12 |
|
13 |
Just my .02, |
14 |
/Jakob Rosenlund |
15 |
|
16 |
Covington, Chris wrote: |
17 |
|
18 |
>>all you need to do is the follow step by step what's written |
19 |
>>here : http://www.gentoo.org/doc/en/mysql-upgrading.xml |
20 |
>> |
21 |
>> |
22 |
> |
23 |
>I followed that and I wasn't able to restore my backup. Specifically, |
24 |
>the snort database was screwed up: |
25 |
> |
26 |
>frank2k3 ccovington # cat BACKUP_MYSQL_4.0.SQL | mysql -uroot |
27 |
>-hlocalhost --max_allowed_packet=16M |
28 |
>ERROR 1005 (HY000) at line 1813: Can't create table './snort/data.frm' |
29 |
>(errno: 150) |
30 |
> |
31 |
>So I'm still using 4.0.25 |
32 |
> |
33 |
> |
34 |
>--- |
35 |
>Chris Covington |
36 |
>IT |
37 |
>Plus One Health Management |
38 |
>75 Maiden Lane Suite 801 |
39 |
>NY, NY 10038 |
40 |
>646-312-6269 |
41 |
>http://www.plusoneactive.com |
42 |
> |
43 |
> |
44 |
> |
45 |
|
46 |
-- |
47 |
gentoo-server@g.o mailing list |