How to recover a MySql table?


Back to databases.


*f11e40    (2010-02-18)
How to recover a MySql table?

Hi, I've got a problem when doing a request looking at this : DELETE FROM 'mytable' WHERE field LIKE '_%'

It should have deleted only the elements that start with an underscore right? But no, it deleted all elements and now I would like to recover my table. I have a base.sql backup file but it is quite big and I would like to import this table ONLY from the file with a Linux command line (it is too big to import it through PhpMyAdmin), does anyone know how to do this?

Thank you.


See also


ficgs
More websites

You must register to see these links, as this is a collaborative page, then you may change the order of the links by clicking the icons before the titles.



admin
Other websites

The following links might be less relevant, please change their ranks if you find them useful.


 Repairing a mySQL Database/Table - How to restore/repair/recover - Crucial Paradigm - Affordable Web Hosting, Dedicated Servers, Reseller Hosting
crucialp > resources/tutorials/server administration
  1. How to Copy Files Across a Network/Internet in UNIX/LINUX (Redhat,
  2. How to install ffmpeg, ffmpeg-PHP, Mplayer, Mencoder, flv2tool, LAME
 Recover Tables From A MySQL .frm File
astahost > info.php/Recover Tables Mysql Frm File t5097

This textarea will convert to Rich-Text automatically (IE, Firefox,...
Sometimes in a table especially if i do alot of things in it i start...

 MySQL :: MySQL 5.0 Reference Manual :: 12.5.2.7 RESTORE TABLE Syntax
dev.mysql > doc/refman/5.0/en/restore table

You cannot use RESTORE TABLE from within an application that is...
If you don't have enough space for a repair, try the myisamchk...

 Recover a MySQL Table with Zmanda Recovery Manager | Linux Journal
linuxjournal > content/recover mysql table zmanda recovery manager

FlashVideoReplacer - Use Native Video Playback Facilities On Sites...
Please note that comments may not appear immediately, so there is no...

 How to restore a MySQL database from backup - Video Tutorial
ntchosting > videos

Here is an overview of the three simple steps you need...

 How to Back Up and Restore a MySQL Database
webcheatsheet > SQL/mysql backup restore.php

 MySQL Tutorial - MySQL Export - How to backup and restore your MySQL database
siteground > tutorials/php mysql/mysql export.htm

(which will add the drop table functionality if the table already...
(which will save the file locally to your computer in an...

 MySQL :: How to recover deleted records in mysql table
forums.mysql > read.php?132,220480,220480

 MySQL :: Recovering from Crashes
dev.mysql > tech resources/articles/recovering from crashes

and we could apply it and get our data how it was at the moment of...
file contains the list of all MySQL binary logs in the directory...

 Backing Up and Restoring Your MySQL Database
devshed > c/a/MySQL/Backing up and restoring your MySQL Database

Storing Class Properties of Persistent Objects in MySQL...
The easiest way to backup your database would be to telnet to the...

 How to restore MySQL database from sql dump file? - Techie Corner
techiecorner > 31

How to backup MySQL Database in command line with...
If you think this article helps you to solve your problem and...

 How can I Backup and Restore a MySQL database?
kb.mediatemple > questions/129

Can I manually extract files from backups created by...
Use FTP to upload the file to your server, your public html directory...

 Recover deleted records from a MySQL table
searchenterpriselinux.techtarget > expert/KnowledgebaseAnswer/0,289625,sid39 gci

 How to Backup & Restore MySQL Database
blog.taragana > index.php/archive/note to self backup restore procedure for mysq

 raw_logs mysql table corruption - how to recover? - Zimbra - Forums
zimbra > forums/administrators/13696 raw logs mysql table corruption

logger won't start: /opt/zimbra/bin/zmlogswatchctl: line 69: kill:...
# df Filesystem 1K-blocks Used Available Use% Mounted...
071219 15:56:04 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Disk...

 Backup and Restore MySQL Database Using mysqldump
thegeekstuff > 2008/09/backup and restore mysql database using mysqldump

Firefox Add-On: Hire 7 Personal Bodyguards to Browse Internet...
12 Amazing and Essential Linux Books To Enrich Your...
Linux Directory Structure (File System Structure) Explained with...

 Ways to repair MYSQL Databases
felipecruz > repair mysql database.php

But then, has anyone seen a SQL-Server buglist recently?...
You can also repair multiple tables in a database, by listing them...
141: Duplicate unique key or constraint on write or update...

 Data recovery utilities restore deleted hard disk files software partition iPod USB drive
recoverdata

Data recovery utilities recover deleted corrupted files laptop...
Internet explorer password recovery utility allows you to restore all...

 Checking and repairing MySQL tables
articles.techrepublic.com > 5100 10878 11 5193721

Perform a quick check, only verifying if the table handler closed...
Perform a faster check, by calculating a checksum for the indexes in...
Perform a thorough check of the table, verifying the data in each...

 Recover MySQL root Password
cyberciti > tips/recover mysql root password

Linux display bandwidth usage on network interface by...
MySQL create an Anonymous or limited access only...

 How to Restore a MySQL Database | eHow.com
ehow

Know that when you enter phpMyAdmin, the left side of the screen will...
Be aware that after the import is complete, a message will be loaded...

 Automatic Mysql Database Backup And Restore
articlesbase > computers articles/automatic mysql database backup and restore 18

Liked this article? Click here to publish it on your website or blog,...
Rapid E-Learning Suite Deluxe combines four sensible but easy-to-use...


Response  
 

Guest name   (option)     Register
Please sum : 1569 + seven  




Trackbacks : If you talked about this article in your blog or website, you may instantly get a backlink 
There's no trackback at the moment.