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
Tags: Mondo Linux Centos system operation and maintenanceI. INTRODUCTIONMondo Rescue is an open source, free recovery and Backup tool that allows users to easily create ISO images of system (Linux or Windows) clones or backups that can be stored on CDs, DVDs, tapes, USB devices, hard drives, and NFS. Mondo Rescue can also be used to quickly recover or redeploy wo
recover command at 17:56:31RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u01/app/oracle/fast_recovery_area/CSDB/archivelog/2013_06_29/login _. arc'ORA-10562: Error occurred while applying redo to data block (file #2, block #70876)ORA-10564: tablespace SYSAUX.ORA-01110: data file 2: '/u01/app/oracle/oradata/csdb/sysaux01.dbf'ORA-10561: block type 'transactiona
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
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
Article Title: backup and recovery on Linux servers. Linux is a technology channel of the IT lab in China. Including desktop applications, Linux system management, kernel research, embedded systems, open source and other basic categories for general backup should be the highest priority for responsible system managers.
, log files, and PWD files, which are placed in the same directory as the original system. If the directory changes, you need to create another control file to modify pfile.(4) create a service: Run oradim-New-Sid gbicc in cmd to create a service. The SID is gbicc. This step is not required in Linux.(5): Set up a listener: Net configuration assintant. (We recommend that you copy the files in the network of the source system and modify them according t
Run the DBV command to check whether the data file contains bad blocks before recovery.
DBV file = D: \ oracle \ oradata \ mydb \ ronly. DBF blocksize = 8192
You can view the data file number and block number of the bad data block to perform a full table scan on the table, for example:
Select count (*) from tablename;
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
Article title: linux fault recovery skills. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Author: Arthur Reid
No matter what operating system you are running, in many cases, yo
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
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
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
directly to the database directoryStop the MySQL service before execution and restart the MySQL service after copying.Disadvantage: The InnoDB engine table is not supported.Quick recovery with MysqlhotcopyCopy the mysqlhotcopy exported data to the MySQL database file directory and restart the MySQL service. You need to specify the owner of the database file in Linux
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
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
[Data recovery failure description]
A Web server, brand for assembly, the use of Tyan (Taian) motherboard, AMD cpu*4, 4 pieces of 68-pin SCSI hard disk RAID0 composed of storage system (heard 2007 years spent 50,000 yuan to buy, and the use of RAID0, this professional degree is really not flattering).
Operating system for Linux, important
This script enables remote Linux host to log in and install MySQL RPM package while importing MySQL data for automated installationParamikohelper class in this blog http://www.cnblogs.com/djoker/p/5906711.htmlScript content:ImportParamikohelperImportOssshobj= Paramikohelper.myparamiko (IP,'Root','xxxxxxxx') FilePath='/opt/packages/mysql'#指定rpm包的目录, download it via yum-y install MySQL mysql-server--downloado
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.