Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

Author Topic: MySQL backup problem via PHPMyAdmin  (Read 2994 times)

0 Members and 1 Guest are viewing this topic.

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

Divi WordPress Theme
Tags:
 

Related Topics

  Subject / Started by Replies Last post
1 Replies
3831 Views
Last post November 25, 2008, 10:04:22 AM
by Kevin
4 Replies
3891 Views
Last post July 20, 2010, 11:43:20 AM
by webhosting.am
2 Replies
1674 Views
Last post June 15, 2013, 11:26:37 AM
by Web_news
0 Replies
361 Views
Last post March 28, 2016, 04:02:26 PM
by VictorVictories
0 Replies
346 Views
Last post March 30, 2016, 05:28:12 PM
by WHUK