1. I think I whoopsied a database
- Posted by ghaberek (admin) Dec 03, 2018
- 1115 views
I don't think my db_dump() output is supposed to look like this.
Database dump as at 2018-12-03 21:22:09 Euphoria Database System Version 4.0 The "address_book.edb" database has 3070230528 tables table "^D", records:16777216 indexblks: 1660944384 -------------------------- block #1, ptrs:1310724 -------------------------- key: -10 data: -10 key: -10 data: -10 key: -10 data: -10 key: -10 data: -10 key: -10 data: -10 ...
-Greg
2. Re: I think I whoopsied a database
- Posted by euphoric (admin) Dec 03, 2018
- 1099 views
That don't look right.
3. Re: I think I whoopsied a database
- Posted by ChrisB (moderator) Dec 06, 2018
- 1007 views
Hi
Have you de whoopsied it yet, and if so what was the procedure?
Cheers
Chris
4. Re: I think I whoopsied a database
- Posted by ghaberek (admin) Dec 06, 2018
- 1017 views
Have you de whoopsied it yet, and if so what was the procedure?
No I'm just generating this from Mockaroo data, so I simply deleted it and started over.
This happened while I was testing the code for Euphoria MVC, and I think I corrupted the file when I killed a process that seemed to be hanging.
There's a chance it might be a bug in EDS, and if I reproduce it I'll put it in a ticket. But I think I whoopsied it by killing it while it was doing something.
Also, I don't recommend using EDS as the storage for a web application. A database server like MySQL or Postgres is much safer.
-Greg
5. Re: I think I whoopsied a database
- Posted by petelomax Dec 06, 2018
- 989 views
A database server like MySQL or Postgres is much safer.
I also have first hand experience of SQLite being very robust.