-
48 GByte should be enough ;)
I still don't understand what happened though. Let me know if the problem persists.
2009-10-21 15:25:56 UTC by wedesoft
-
# df /var
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 73742752 21393352 48603448 31% /
thanks for the unzip script. i really need to get into shell scripting more.
http://www.recipesource.com/ is what i was using, they have both mealmaster and mastercook[chef].
2009-10-21 15:12:58 UTC by jerjoz
-
You can get tons of Mealmaster recipes from Glen's MealMaster Archive at http://thehoseys.com/recipes.html . You need to unzip them though. The fastest way is to use a for-loop in the shell to do this.
mkdir x
cd x
for i in ../*.zip; do unzip -n $i; done
If you find that a full "/var"-partition is the issue, you could copy the /var/lib/mysql folder (using "cp" with "-a" option) to a...
2009-10-20 21:04:29 UTC by wedesoft
-
yah thats the thing, they were not mealmasters formated so they would not import. not really an error just an annoyance when trying to suck in as many recipes as i could find.
ill issue that command later tonight when im off of work.
2009-10-20 20:47:19 UTC by jerjoz
-
Mealmaster import allows you to ignore errors or write erroneous recipes to a file. I've tested the AnyMeal import with 300,000 recipes and there should be no issues with importing recipes.
Another possibility is that your "/var"-folder is full. Can you run "df /var" (without the apostrophes) to check whether there is disk space available for the database?.
2009-10-20 20:44:56 UTC by wedesoft
-
i was having some issues batch importing some individual recipes. so since i started building this recent database i would import, search for the recipe, disconnect, close out anymeal and continue with the next recipe.
it is in network mode, youve said debian will not allow anything else
i am not that familiar with the var/lib directory to know if it would be deleted by the os or not. no...
2009-10-20 20:37:12 UTC by jerjoz
-
I don't know what happened. Did you have a working database connection (importing recipes and then searching and displaying them)? Are you using the "Network" mode both when creating and reconnecting to the database?
MySQL usually stores the data under "/var/lib/mysql/anymeal". Does your system delete this information? AnyMeal certainly should not delete any database tables (such as...
2009-10-20 20:31:53 UTC by wedesoft
-
thats understood, my question know is what is to stop this from happening again after i re-load all my 3k worth of recipes? as this database was created and only accessed by anymeal.
2009-10-20 14:26:13 UTC by jerjoz
-
The database wizard will not reuse and existing database if it does not contain the expected tables already.
You need to delete 'anymeal' using "File->Delete" and then create it again using the database wizard. I.e. "File->Connect", press "New"-button, and walk through the setup process.
2009-10-20 10:52:18 UTC by wedesoft
-
so, how does the database become empty without deleting entries or the database?
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| anymeal |
| mysql |
+--------------------+
3 rows in set (0.00 sec)
mysql> use anymeal;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql>.
2009-10-20 03:22:35 UTC by jerjoz
