Export the database in phpmyadmin – setting name and filetype.

Always save a backup of your data.

An important aspect is the date when the backup was made??.

Today I will show you how to format the backup name so you know since you have.

Select the database and go to the Export tag and Custom – display all possible options.

If you select only one table, you only backup that table.

export database

I prefer a format like this:

If you accidentally selected a table then you will see:

Here is how to select the format name.

format name

You can also choose the output format sql, zip or other archive.

sql zip formats

These are just some settings that you should know.

The phpmyadmin offers multiple possibilities for setting up and configuring


born 1976, Falticeni , Suceava , Romania
Posted in Programming, SQL Databases. Tagged with , .