Restore_Single_Table_From_Mysql Linux

How to restore single table from mysql .sql database

mv wom_user_management.bak wom_user_management.sql
cat wom_user_management.sql | grep "wom_users " > /opt/backup/13-Oct-2015/opt/backup/13-Oct-2015/wom_users.sql
cat wom_users.sql
cat wom_user_management.bak | grep "wom_users " > users.sql
head users.sql
tail users.sql
cat wom_user_management.bak | grep "`wom_users` " > users.sql
cat wom_user_management.bak | grep "\`wom_users\` " > users.sql
cat users.sql | head -10
cat users.sql | head -1
cat users.sql |grep "INSERT" | head -1
cat users.sql | head -2
cat users.sql | head -3
cat users.sql | head -4
cat users.sql | head -3
vi +1 users.sql

comment first line if duplicate: like below

-- CREATE TABLE `wom_users` (
LOCK TABLES `wom_users` WRITE;
/*!40000 ALTER TABLE `wom_users` DISABLE KEYS */;

cat users.sql | head -3
mysql -u root -p'dbpassword' wom_user_management < /opt/backup/14-Oct-2015/opt/backup/14-Oct-2015/users.sql
mysql -u root -p'dbpassword' -e "use wom_user_management; truncate table wom_users"
mysql -u root -p'dbpassword' wom_user_management < /opt/backup/14-Oct-2015/opt/backup/14-Oct-2015/users.sql
mysql -u root -p'dbpassword'



use wom_user_management;
show tables;
select count(*) from wom_users;
select id from wom_users;
desc wom_users;



###############################################################

#####    Dump and restore a single table from .sql:  #########

##############################################################


Dump and restore a single table from .sql

###   Dump

mysqldump db_name table_name > table_name.sql

Dumping from a remote database

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

For further reference:

http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html

Restore

mysql -u <user_name> -p db_name
mysql> source <full_path>/table_name.sql

or in one line

mysql -u username -p db_name < /path/to/table_name.sql
Dump and restore a single table from a compressed (.sql.gz) format

Credit: John McGrath

Dump

mysqldump db_name table_name | gzip > table_name.sql.gz

Restore

gunzip < table_name.sql.gz | mysql -u username -p db_name