Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home MySQL MySQL dump table

MySQL dump table

In a certain database, there are may just some main tables which controls everything in your application and contain all your main contents which are updated daily by your staff or your members.

When you want to backup or get the content in SQL or CSV format of a particular table in your database, you don’t need to backup the whole database. It may waste your time/resources and the process will take more time to finish.

In this tutorial, I’ll show How to backup and restore a single table using MySQLDump:

1. Backing up a single table from a database:

mysqldump -u db_user -p database_one TABLE_NAME < /var/www/backups/TABLE_NAME.sql

mysqldump -u db_user -p database_one table_name < /var/www/backups/table_name.sql

2. Restoring the table into another database:

mysql -u db_user -p database_two <  /var/www/backups/TABLE_NAME.sql

mysql -u db_user -p database_two < /var/www/backups/table_name.sql

With UTF-8: , try this:

mysql -u db_user -p --default-character-set=utf8 database_two <  /var/www/backups/table_name.sql

mysql -u db_user -p --default-character-set=utf8 database_two < /var/www/backups/table_name.sql

Feb 20, 2011Hoan Huynh
PHP remove vietnamese accents
You Might Also Like:
  • Mysql restore database from dump file with GZIP compression
  • Schedule Backup And Zip MySQL Database In Windows
  • Replace String In MySQL
  • MySql backup database with gzip compression
  • Shell script backup all Mysql Databases in Linux
  • PHP Store Session In MySQL Database
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • How To Track Website With Multiple Google Analytisc Accounts
  • PHP Connect To MS SQL Server
  • Save Table Structure Changes When Remote Access To SQL Server
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

10 years ago MySQLbackup, mysqldump, restore, utf 8116
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
22,170 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
20,044 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
15,826 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,307 views
C# Read Json From URL And Parse/Deserialize Json
9,794 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • How to Compose Your Essay To Me – 4 Easy Steps to Write My Essay
  • How to Find a Photo Editor
  • Installment Loans – Making Sense of Online Software
  • Apple Pay Casino Canada
  • Casinos austria
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (28)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (105)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development