Skip to content

Search for:

Home
Shop
Cart
Checkout
My Account
Contact Us

Home
Cart
Checkout
Contact Us Page
My Account
Shop

Search for:

Home
Shop
Cart
Checkout
My Account
Contact Us

How to Linux / MySQL / PHP

Restoring a MySQL table back to the database

by linuxgeek · January 28, 2014

When we need to restore a single MySQL table from big data MySQL backup. Most modern text editors should be able to handle a text file that size, if your system is up to it. so you can use sed.

sed -n -e ‘/DROP TABLE.*table_name/,/UNLOCK TABLES/p’ backupfile.sql > mytable.sql

Share

Tags: mysql mysql backup mysql table restore php

You may also like...

Backup MySQL Database to a file

July 18, 2012

by linuxgeek · Published July 18, 2012 · Last modified June 18, 2015
Kankun KK-SP3 – OpenWrt Webserver and Comandline Hacks

November 12, 2014

by linuxgeek · Published November 12, 2014 · Last modified June 18, 2015
Arduino IR Remote identification

July 31, 2013

by linuxgeek · Published July 31, 2013

Follow:

Next story Hide database from user
Previous story PHP Client IP address

Search for:

Products

ESP8266 WiFi Stack - Expansion Board - 6 pcs ~~$6.00~~ $5.00
ESP8266 Wifi Stack Expandable - IOT ~~$13.00~~ $10.00
ESP8266 Wifi Stack Expandable - IOT With USB to Serial Coverter ~~$15.00~~ $12.00
Raspberry Pi B+ Metal Case ~~$12.00~~ $10.00
DIY ATTiny ISP Shield (Un-Assembled) ~~$5.00~~ $3.00

Recent Posts
Popular Posts
Recent Comments
Tags

ESP32 / ESP8266 / Hardware / IOT / nodemcu

ESP32 from Espressif has Dual Core SoC, Features Faster WiFi, Bluetooth 4.0 LE, and More Peripherals and Pinouts than ESP8266

10 Dec, 2015
ESP8266 / Hardware / IOT / nodemcu / PHP

ESP8266 Power Monitor

7 Dec, 2015
ESP8266 / Hardware / IOT / nodemcu

ESP8266 OLED Example

30 Nov, 2015
ESP8266 / How to Linux / IOT / nodemcu

Install ESP8266 SDK toolchain on Linux (Ubuntu 14.10 Desktop)

17 Sep, 2015
Android / ESP8266 / IOT

Connect Arduino to ESP8266 WiFi module

27 Jun, 2015
Uncategorized

Tools and Firmware for ESP8266

15 May, 2015
ESP8266 / Hardware / How to Linux / IOT / nodemcu

Initial Prototypes of ESP8266 Stack

15 May, 2015
How to Linux

Creating Software RAID on Ubuntu14.04 Server

4 Apr, 2015
Ardunio / ESP8266 / nodemcu

ESP8266 NodeMCU

24 Mar, 2015
Ardunio / ATtiny

ATTiny ISP Shield

19 Mar, 2015
Hardware / How to Linux

Installing Eagle CAD Software in Ubuntu 14.04

27 Jan, 2015
Android / How to Linux

How To Fix: error: insufficient permissions for device with ADB

20 Jan, 2015
Android / How to Linux

Easily Install Android Studio Via PPA In Ubuntu

19 Jan, 2015
How to Linux

Install Oracle JDK in Ubuntu 14.04

19 Jan, 2015
How to Linux

BURG-Brand-new Universal loadeR from GRUB

5 Jan, 2015
Ardunio / ESP8266 / Hardware

ESP8266 JSON Weather Display

2 Jan, 2015
Ardunio / ATtiny

ATtiny ISP Shield makes programing bare AVR ICs easy and also helps shrinkfy your arduino projects.

12 Nov, 2014
How to Linux / IO / Kankun KK-SP3

Kankun KK-SP3 – OpenWrt Webserver and Comandline Hacks

12 Nov, 2014
Hardware / How to Linux / IO

Local Time Synchronisation on OpenWrt -KanKun Small K

5 Nov, 2014
Hardware / How to Linux / IO

Kankun Runs on OpenWrt firmware

5 Nov, 2014

How to Linux / IO / Kankun KK-SP3

Kankun KK-SP3 – OpenWrt Webserver and Comandline Hacks

12 Nov, 2014
How to Linux

Perl Script to Backup MySQL Databases

20 Jul, 2012
How to Linux

Script to Backup Files Over a Network Using Rsync

20 Jul, 2012
How to Linux

Top 4 Terminal GUI Applications

20 Jul, 2012
How to Linux

NMAP to Identify MAC and IP of Machines on LAN

20 Jul, 2012
How to Linux

Create HTML reports with nmap

20 Jul, 2012
Hardware

Darpa Funds Hack Machine You’d Never Notice

23 Jul, 2012
How to Linux

Linux Set Date and Time From a Command Prompt

24 Jul, 2012
Hardware / How to Linux

Linux iotop Check What’s Stressing And Increasing Load On Your Hard Disks

24 Jul, 2012
How to Linux

Crontab Code Generator

20 Jul, 2012
How to Linux

Popular Version control systems

20 Jul, 2012
How to Linux

Auto mounting a partition

20 Jul, 2012
ESP32 / ESP8266 / Hardware / IOT / nodemcu

ESP32 from Espressif has Dual Core SoC, Features Faster WiFi, Bluetooth 4.0 LE, and More Peripherals and Pinouts than ESP8266

10 Dec, 2015
How to Linux

Backup MySQL Database to a file

18 Jul, 2012
How to Linux

Change SSH Welcome Banner on Ubuntu

18 Jul, 2012
How to Linux

Change Ubuntu Desktop from DHCP to a Static IP Address

18 Jul, 2012
Hardware

Raspberry Pi to get camera add-on by October

18 Jul, 2012
How to Linux

Linux Directory Structure

20 Jul, 2012
How to Linux

Linux Distros for Beginners in 2012

20 Jul, 2012
How to Linux

NetworkManager ‘device not managed’ Fix

20 Jul, 2012

Andreas says:

@linuxGeek thx for your post. I have expanded on this. I...
Andreas says:

@Azad: try 1234 and p9z34c
Azad says:

The password of root@192.168.x.x is not admin. I tried root and...

0.96" oled arduino Atmega32u4 arduino Atmega32u4 Breakout backup crontab crosstool-NG with support for Xtensa database esp8266 esp8266 iot esp8266 oled esp8266 power monitor esp8266 sdk esp8266 toolchain extensa toolchain gcc-xtensa hacking kankun small k IPaddress kankun kankun login kankun small k Leonardo linux linux-xtensa mysql mysql backup nmap nodemcu nodemcu display nodemcu oled oled oled code openwrt openwrt webserver perl php remote router hacks script SSD1306 tinycpu TL-WR703N tplink wifi smart plug wifi smart socket

Copyright www.htlinux.com @ 2015