I have been building a CMS type system for an intranet, and it all seemed to work well (even though - looking back my coding, it should be re-wrote!)
but the problem...........
over the last couple of days I have noticed that changes that were made to the database are no longer there
When ever I make a change - it reverts back to what was in the table before hand - as if its read only, but even if I log in as a superuser with full rights it doesnt make a difference.
It has been working for months but has suddenly stopped and even my admin.php pages have stopped working
I am also using MySQL Front as the GUI interface and I have discovered that I need to post the data after changing the data, which is ok when in mysql front, but not from my admin pages.
The only thing different that I have done recently is use a command batch routine which dumps my data each nite.
Code: Select all
cd \dbbackup
mysqladmin flush-hosts flush-logs flush-status flush-tables flush-privileges
mysqldump --all --add-drop-table --add-locks --complete-insert --compress --extended-insert --flush-logs --force --opt --verbose --databases myfiles>backup.sqlI have noticed that it dumps the data without logging into MySQL though!?
could this have caused a file lock somewhere?
Thanks for taking the time to read about my mess.
Any help appreciated.
Thanks.