General table Cookbook

Showing all the fields of a table Deleting a table Showing all tables Creating a table Cloning a table Finding all tables with a specific column name Removing a temporary table Renaming a table Creating a temporary table Restoring a table from an sql file Backing up a table

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

Backing up a table in MySQL

Database

MySQL

Cookbooks

Tables Cookbooks

General table Cookbook

Jul 1, 2022

Last updated

local_offer MySQL

Tags

Table of Contents

We can back up a MySQL table to a .sql file using the below command:


        
        
            
                
                
                    mysqldump -u {username} -h {host} -p database_name table_name > /filepath/backup.sql

To backup the table with a particular condition applied:


        
        
            
                
                
                    mysqldump -u {username} -h {host} -p database_name table_name --where="id=3" > /filepath/backup.sql

To backup the table to a compressed sql .sql.gz file:


        
        
            
                
                
                    mysqldump -u {username} -h {host} -p database_name table_name | gzip > /filepath/backup.sql.gz

From the .sql or .sql.gz file created, it is possible to restore and recreate the table at a later point in time.

Restoring a table from an sql file in MySQL

We can restore a table from an .sql file in MySQL using the following command: mysql -u {username} -p database_name < /filepath/backup.sql