LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-26-2012, 04:25 AM   #1
karthilin
LQ Newbie
 
Registered: Sep 2012
Location: Chennai
Posts: 13

Rep: Reputation: Disabled
Doubt in MySQL query


I want to delete one row in my table but I wrongly deleted whole table,suddenly I tried mysqldumb but datas not stored. How to I get my data and Where all mysql data stored in Linux?


Thanks

Last edited by karthilin; 10-26-2012 at 04:27 AM.
 
Old 10-26-2012, 05:40 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
mysqldump is a backup program, but it can only backup data that is there.
If you've already deleted the table contents, then its gone....
I think there's a SQL session cmd you can set so that its always possible to use the rollback cmd if you stay inside the same session (for data only).
If you drop a table, that can't be rolled back.

See https://dev.mysql.com/doc/refman/5.0...rent-apis.html
https://dev.mysql.com/doc/refman/5.1...it-commit.html
for examples of 'set autocommit' on/off
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql doubt maheshp86 Linux - Server 1 09-14-2010 08:29 AM
Doubt in MySql vibinlakshman Programming 2 02-17-2009 01:08 PM
interesting MySQL query/view query :s mjh Programming 3 03-25-2008 08:30 AM
mysql use output of one query in another query secretlydead Programming 2 11-19-2007 02:25 AM
help with mysql query: return nth rows in query hawarden Programming 2 07-31-2006 07:36 PM


All times are GMT -5. The time now is 08:53 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration