Tags: inux err Linux data recovery spro file src E30 recycle ext3In the operation of Linux system operations, often encountered due to careless operations, operation errors and other causes of file data loss situation. What is referred to here is a complete deletion, that is
No matter what operating system you are running, in many cases, you will face disaster recovery operations. Your main boot area is overwritten, your hard drive cannot be started, or an important file is deleted, or your display card flashes when it is started on a black screen. This article will make some technical discussions on these issues, to help you in the face of these problems, do not be unprepared.
The first need is an emergency boot floppy
In Linux Redhat 5.4, the recovery process for RM accidental deletion of database files is as follows:(Found online, tested OK)1. First, test RM's accidental deletion of database files.
[Oracle @ primary dbwdn] $ LLTotal 2153164-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control01.ctl-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control02.ctl-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control03.ctl-RW-r ----- 1 Oracle DBA
environment is just as rational as it is, and the data you accidentally deleted can be restored. But how can I restore the holiday photos on my CF card?
PHOTOREC: restores and deletes files about a week ago. it supports over 300 popular file formats, including ZIP, HTML, PDF, and JPG. No matter what file system, supports hard disk, USB, memory card, iPods, etc., can read data on FAT,
= device BS = 64 K"
# Tar-CVF-| SSH remote_host "dd If = device BS = 10 K"
# Cpio-oacvb | SSH remote_host "dd If = device BS = 5 K"
Linux bare metal recovery method:
1. Back up important metadata # fdisk-L>/etc/fdisk-l.txt
2. Use a local tool to back up the system # cd/; tar CF-. | gzip-C>/backup/xxx.tar.gz
3. The system is damaged. Use other media to guide the system (BOOT disk, knoppix, etc ).
4. Partiti
Label:Friends who often use php+mysql are generally managed by phpMyAdmin to manage the database. Some daily debugging development work, the use of phpMyAdmin is really convenient. But when we need to export hundreds of trillion or even a few g of the database, phpMyAdmin will be very card. Even if you want to import large amounts of data, phpMyAdmin is completely unable to complete. Because phpMyAdmin is based on a PHP Web page, it is not possible to
assignment of tasks, and thinking of the object packaging will make the website development efficiency greatly improved.
Attached: Code test Platform
Above program code all in the following platform test pass
RedHat Linux 6.1+apache1.3.12+
php4.0+mysql3.22.32
The installation configuration process for the database is:
cd/usr/local/src/mysql*
./configure--refix=/usr/local/mysql
Make
Make install
The installation configuration process for Apache is:
cd
Today, we will focus on the actual application code for backing up and recovering DB2 databases in Linux, I saw data on the actual application code of the DB2 database backup and recovery in the Linux environment on the relevant website two days ago. I thought it was good and I would like to share it with you.
After two days of unremitting efforts, finally recovered a mistake to delete production server data. Record this accident process and solution, alert yourself, also suggest others mo make this mistake. Also hope that friends who encounter problems can find a hint of inspiration to solve the problem.
Accident background
Arrange for a sister to install Oracle on a production server, sister side of the research side of the installation, feel loaded inc
Fix for Linux file system error Ddrescue replace DD Recovery software backup Super blockA recently processed Linux server power outage causes the file system to not read and write, the data is not availableExample, now summarizes the Linux file system error repair method.EXT
For mysql database backup or recovery, we often use Direct Copy database backup. For mysqldump database backup and mysqlhotcopy database backup, let's take a look.
Mysqldump command mode
The backup IP address is 192.168.1.100:
The Code is as follows:
Copy code
D:/APM/APMServ5.2.6/MySQL5.1/bin>Mysqldump-h 192.168.1.100-u root-p ucenter> d:/SQL/uc_20130306. SQLEnter password :****
Back up a table in a database:
T
only store the data in the hbase table at the moment when the snapshot is saved. snapshots do not support incremental data after the snapshot;
Ii. Export table export and copy table copytable
Hbase's table export tool is a built-in function that enables data to easily import sequencefiles under the HDFS directory from hbase. It creates a map reduce task, the cl
-------------------------
[email protected]:/data/backup# Mysqlbinlog-- No-defaults--base64-output=decode-rows-v/data/mysql/mysql-bin.000001 8. Third-Party online backup tool xtrabackup Xtrabackup is a hot backup tool that supports backup of engine objects such as innodb,myisam,csv, or is more popular. Installation of Xtrabackup: First to Percona official website to download the latest version of the Xtr
Http://www.linuxidc.com/Linux/2013-09/90156.htmToday on the Internet to check the implementation of Linux in the process of the suspension and recovery, the poor data, most of them are paste copy. There is no complete and detailed code. So I tidied up a bitThe program flow is: The main thread to create a child thread (
MySQL binary log recovery data error: @ GLOBAL. GTID_MODE = OFF.
When MySQL Recovers Data using binary logs, the following ERROR occurs: ERROR 1781 (HY000) at line 16: @ SESSION. GTID_NEXT cannot be set to UUID: NUMBER when @ GLOBAL. GTID_MODE = OFF.
At work, when using binary logs to help developers recover data, an e
Install and configure the SVN server in Linux-backup-recovery-scheduled tasks
Introduction:SVN is short for Subversion. It is an open-source version control system. Compared with RCS and CVS, it adopts a branch management system. Its design goal is to replace CVS. Many version control services on the Internet have been migrated from CVS to Subversion.Running ModeSvn servers can run in two ways: independent
Tags: next state solution Gtid table System development Col SeleTroubleshoot MySQL using binary logs to recover data error: Error 1781 (HY000) at line: @ @SESSION. Gtid_next cannot is set to Uuid:number when @ @GLOBAL. Gtid_mode = OFF.Work, the use of binary logs, to help develop colleagues to recover data, there has been an error alarm:[[email protected] tmp]# mysqlbinlog--no-defaults mysql-bin.000614|mysq
Mondo Rescue is an open-source free fault recovery and backup tool. You can easily create a complete (Linux or Windows) cloned or backed up ISO image, these images can be stored on CD, DVD, tape, USB device, hard disk, and NFS. Mondo Rescue can also be used to quickly restore or redeploy a working image to another system. In case of data loss, you can restore as
Case 3:
--All of the table space data files are lost, restore data files (open)
1) test environment
07:37:23 sql> INSERT INTO scott.test values (6);
1 row created.
07:39:18 sql> INSERT INTO scott.test values (7);
1 row created.
07:39:20 sql> INSERT INTO scott.test values (8);
1 row created.
07:39:21 sql> commit;
Commit complete.
07:39:23 sql> SELECT * from Scott.test;
Id
----------
6
7
8
1
/20170720200333510?watermark/2/text/ ahr0cdovl2jsb2cuy3nkbi5uzxqva2fpcnvpmtiz/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/ Southeast "alt=" here to write a picture describing "title=" "/>Xtrabackup Import and export of tablesWhen you export a table, you need to enable the Innodb_file_per_table option for the server.
When you import a table, you need to have the server-enabled innodb_file_per_table and Innodb_expand_import options
Export table
Innobackupex--apply-log--export
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.