database Archives

Command to take a backup of MySQL database table Structure and Data

January 1, 2021May 30, 2020 by Heyan Maurya

command to backup of MySQL database table Structure and Data

Here we will talk about how can we back up the whole database or a single table structure and data in the database. But why are we doing all these things so I want to tell you if you accidentally drop the database then this …

How to copy a table structure without copying data in MySQL?

January 1, 2021May 22, 2020 by Heyan Maurya

Copy old MySQL table structure wihout the data

In this post, we are going to show how you can copy a table structure without copying the data values present in it. So, let’s start it, nothing special has to be done for this just type a simple command on MYSQL console. You can …