1. Web Hosting community for Webmasters
  2. Design and Development
  3. Databases
  4. MySQL
  5. MySQL backup problem via PHPMyAdmin

Divi WordPress Theme
« previous next »
Pages: [1]   Go Down

Topic: MySQL backup problem via PHPMyAdmin  (Read 4754 times)

Offline Alex

  • New Member
  • *
  • Posts: 32
  • iTrader: +0/-0
    • View Profile
MySQL backup problem via PHPMyAdmin
« on: December 17, 2008, 11:19:19 AM »
Hi,

I have database of the size around 800 MB and when I try to take the backup it is not downloading complete database backup. Is there any other way to take the backup of MySQL database. I have cPanel control panel.

Thanks,

=: Alex :=
VPS Hosting - AccuWebHosting

Offline Kevin

  • Junior Guru
  • **
  • Posts: 72
  • iTrader: +4/-0
    • View Profile
Re: MySQL backup problem via PHPMyAdmin
« Reply #1 on: December 19, 2008, 01:09:30 AM »
It is not recommended to take the backup of the large MySQL database from PHPMyAdmin because there is a risk that it doesn't take the full backup of your database due to large size. You will need to take the backup from command line.

Generally it downloads the incomplete database due to time out in the PHP script.

Kevin
Shopify Divi WordPress Theme
Pages: [1]   Go Up
« previous next »
Tags:
  1. Web Hosting community for Webmasters
  2. Design and Development
  3. Databases
  4. MySQL
  5. MySQL backup problem via PHPMyAdmin