How Can I Backup A Database Using PHPMyadmin?

Most managed hosting accounts include automatic backup of files and databases, but it is good database management practice to also make regular backups of your database manually just in case. This task can be accomplished easily using PHPMyadmin in cPanel and the database backup can be saved to your hard drive to be restored later if necessary.

  • Logon to your cPanel and open PHPMyadmin.
  • In the left-hand column choose the database you want to backup.
  • In the page that opens will be a list of all the tables in that database. Click on the Export tab at the top.
  • Look in the Export column of the page that opens and make sure all of the tables are selected. If not, simply click "Select All" and the tables should now be highlighted.
  • In the same Export column make certain the SQL button is selected.
  • To the right of the Export column check the Structure box and under that section make sure the "Add AUTO_INCREMENT value" is selected along with "Enclose table and field names with backquotes". Additionally, if this database is a Wordpress blog, make certain that the "Add DROP TABLE/VIEW/PROCEDURE/FUNTION/EVENT" checkbox is selected.
  • Check the Data box in the next section, and make sure "Complete inserts" and "Extended inserts" are selected, as well as "Use hexadecimal for BLOB Export type".
  • Check the "Save as file" box and choose "None" for Compression unless your database is quite large.
  • Click the Go button and you will be prompted to save the file to your computer.
  • 0 Korisnici koji smatraju članak korisnim
Je li Vam ovaj odgovor pomogao?

Vezani članci

What is Cpanel

Web hosting can be a scary world. Dealing with all of the ins and outs of website design is...

How to Use Your Dedicated Server to Send Emails.

When setup correctly, a dedicated server can be used for all email hosting needs - both to send...

How Do I Restore A Database Using PHPMyadmin?

Even though your managed hosting package will likely include automatic backups of your database...

How Do I Access Cpanel?

Accessing the cPanel front end within your dedicated hosting plan for utilising managed hosting...

How Do I Backup My Entire Site in cPanel?

It is very important to always make sure all files and databases stored on a dedicated server...