Restore from db backup missing information
Hello, I am new to databases and everything so bear with me....
I work for a small hospital and we have a website built with the 'Jaws-Project' for PhpMyAdmin, DNS, etc..
Recently we had a power outage that took down our virtual servers which killed our intranet website but I was able to restore to a backup and everything looked fine. We have forms that were saved to the website itself, not on our file server or anything, and they are the old information. Whenever I go to the PhpMyAdmin page and look through the database the information/forms are there.. Is there a way to force the new information to come over? It says the import was successful and like 517 items were imported but the information never changes..
I have command line access to the server and access to everything so if you have any ideas I'm willing to try them all... please help! I've been trying to figure this out for 2 days and I cannot figure out why the information isn't coming through.
Thanks in advance,
Mackenzie
-
Hello :) You may want to check with the script configuration to ensure it's using the correct database name. If the data appears in the database itself when you view it via phpMyAdmin or the command line, then it's likely the issue is with the script itself. Thank you. 0 -
Where would I check the script configuration? That makes perfect sense though! Just not sure where to check :) Thanks for the quick reply. 0 -
Sorry for the double post.. I was looking at some other posts on here I tried the command "myisamchk -r /var/lib/mysql/web1db1/*.MYI*" and it found the 77 items needed - then I did the -i switch and under the FileBrowser (which is where the files are stored I'm missing) it says Records 77, Lost space 77.. is that normal? 0 -
1. Every script is different, so there is no specific location for a configuration file. You can consult with the script developer for that information if necessary. 2. Lost space does not always indicate database corruption. It could simply be data that was removed. You can check the status of the database with a command such as: mysqlcheck database_name
Thank you.0 -
I did that mysqlcheck and everything shows OK. I will see if I can get on the Jaws forum and find out something. 0
Please sign in to leave a comment.
Comments
5 comments