SitePoint Sponsor |
|
User Tag List
Results 1 to 13 of 13
Thread: Help! MySQL data dissappeared
-
Apr 6, 2002, 09:24 #1
- Join Date
- Aug 2001
- Location
- Switzerland
- Posts
- 395
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Help! MySQL data dissappeared
I don't know if this is the correct forum to ask this question but...
I run a message board (vBulletin-powered) and I have just noticed that all the data on the MySQL database have dissappearedAnd me being so stupid, I didn't do any backup (although I was planning to start doing this soon, but I guess we all say this until something bad happens).
The strange thing is that I did a 'locate' on telnet and it says that the MySQL tables are still here. But when I try to access or list them, it says there is no file. So why does 'locate' tell me the tables are here? Does locate work by indexing the files structure somewhere? (which would mean the tables WERE there) or coud this mean there has been an hard drive corruption which messed up the file structure?
Please help, if the tables are definitely lost I'll start again with a fresh install but I just want to make sure there is no hope before doing thisLast edited by exhale81; Apr 6, 2002 at 09:29.
Sebastien Rosset
:: Commercial: BlackSonic | ScriptsCenter
:: Non-Profit: VJCentral | ReclaimYourSoul
-
Apr 7, 2002, 15:09 #2
- Join Date
- Apr 2002
- Location
- The Office
- Posts
- 616
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Is it worth asking your web host if they backup your database. I know that most don't..but you might get lucky. Just a thought ...I know that when these things happen it can be a real pain. I hope you get it sorted. You might want to try a specialist MySQL forum as well...I can't name any right now but a quick search on google should throw something up.
Good luck!
Simon
-
Apr 7, 2002, 15:44 #3
- Join Date
- Jul 1999
- Location
- Derbyshire, UK
- Posts
- 4,411
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
locate creates a cache of the file system, hence why you can still see the tables in it. Asking your host about backups would be a good first step, if they are running CPanel then there is a good chance they will have a backup.
Thanks,Karl Austin :: Profile :: KDA Web Services Ltd.
Business Web Hosting :: Managed Dedicated Hosting
Call 0800 542 9764 today and ask how we can help your business grow.
-
Apr 7, 2002, 16:31 #4
I agree with the above 2 posts that you should e-mail your host about a backup. But as far as you can tell is there any data that is actually missing like posts/members etc.. If not then I think that the problem or discrepancy that you might be seeing has to do with the search index table. I have noticed that sometimes it is larger and sometimes smaller, depending on the usage, and if it is the searchindex table which can be one of the biggest tables in VB, then you have nothing to worry about.
HTH
StevenInsider Hosting.com - Top Quality Hosting At An Affordable Price.
-
Apr 7, 2002, 23:07 #5
- Join Date
- Aug 2001
- Location
- Switzerland
- Posts
- 395
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Thanks people, someone on the vBulletin forum told me about the cache used by locate. My database is definitely gone
Contacting my host will be useless anyway because I have a dedicated server.
Thanks anywaySebastien Rosset
:: Commercial: BlackSonic | ScriptsCenter
:: Non-Profit: VJCentral | ReclaimYourSoul
-
Apr 8, 2002, 10:33 #6
- Join Date
- Nov 1999
- Location
- Brisbane, Australia
- Posts
- 682
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by exhale81
Thanks people, someone on the vBulletin forum told me about the cache used by locate. My database is definitely goneContacting my host will be useless anyway because I have a dedicated server.
Thanks anyway
eva2000 = prequel
-
Apr 8, 2002, 10:45 #7
- Join Date
- Nov 2001
- Location
- Gods' Own Country
- Posts
- 890
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by prequel
eva2000 = prequelDeath --the last sleep? No, it is the final awakening.
TinyPlanet.org
Discuss and Debate World Events, Politics and Religion
-
Apr 8, 2002, 11:41 #8Originally posted by Indian
Really? I've seen you at venturesonline forums.
StevenInsider Hosting.com - Top Quality Hosting At An Affordable Price.
-
Apr 8, 2002, 11:57 #9
Except this one
SeanHarry Potter
-- You lived inside my world so softly
-- Protected only by the kindness of your nature
-
Apr 8, 2002, 15:30 #10
- Join Date
- Jul 1999
- Location
- Derbyshire, UK
- Posts
- 4,411
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by Indian
Really? I've seen you at venturesonline forums.
My advice woul dbe to start backing up your databases (But then again I bet you've guessed that), even a simple script (run everyday from cron) to tar each directory and copy it to elsewhere on the server will stop things like this happening again.Karl Austin :: Profile :: KDA Web Services Ltd.
Business Web Hosting :: Managed Dedicated Hosting
Call 0800 542 9764 today and ask how we can help your business grow.
-
Apr 10, 2002, 12:23 #11
- Join Date
- Nov 1999
- Location
- Brisbane, Australia
- Posts
- 682
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by insiderhosting
I case you didn't notice it yet, George is everywhere, there is no escaping. I think that he has at least 1000 posts at every forum he visits.
Steven
-
Apr 10, 2002, 12:25 #12
- Join Date
- Nov 1999
- Location
- Brisbane, Australia
- Posts
- 682
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by seanf
Except this one
Sean
as Karl said a simple backup cron script will do.. can be found in vbulletin.com's mysql forum sticky thread
-
Apr 12, 2002, 05:23 #13
- Join Date
- Jun 2000
- Location
- Sydney, Australia
- Posts
- 3,798
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by prequel
that'll change once sitepointforums gets a better server and speeds up the forums ...
Bookmarks