08-23-2011, 10:47 AM
|
|
WHT Addict
|
|
Join Date: Jan 2004
Location: Bay Area
Posts: 133
|
|
Backup large mysql database program ?
Hi all,
My database now is more than 1gb, I used Cpanel and phpmyadmin to backup but it time out all the time it can only back up around 145Mb. Is there is any php back up program out there to do the back up either save to the host or ftp back to local pc . please help me out
thanks
__________________
It's just the same like last time!!!
|
08-23-2011, 11:11 AM
|
|
Junior Guru Wannabe
|
|
Join Date: Mar 2010
Posts: 81
|
|
__________________
sn!.sg!
|
08-23-2011, 11:13 AM
|
|
WHT Addict
|
|
Join Date: Jan 2004
Location: Bay Area
Posts: 133
|
|
do you know the site where I can download the program ?
__________________
It's just the same like last time!!!
|
08-23-2011, 11:44 AM
|
|
Head Geek
|
|
Join Date: Aug 2004
Location: Austin, TX
Posts: 2,562
|
|
Quote:
Originally Posted by vietkool
do you know the site where I can download the program ?
|
http://dev.mysql.com/doc/refman/5.0/...qlhotcopy.html
__________________
Incero's Enterprise Servers - Incero on Facebook, Like?
Gordon: sales(at)incero(dot)com • US: 512.394.8803 • Skype: InceroLLC
Incero: High Spec, Affordable, SATA/SAS/SSD Servers with full IPMI/KVM remote control
Datacenter Locations: Dallas, TX (SSAE 16, SAS 70, Redundant Power & Network)
|
08-23-2011, 12:49 PM
|
|
Junior Guru Wannabe
|
|
Join Date: Jun 2011
Posts: 59
|
|
If you have access to the command line, it would be simple to create a backup script to backup the db then scp it to somewhere else. You can google for scp and mysqldump to get you pointed in the right direction.
|
08-23-2011, 12:57 PM
|
|
Premium Member
|
|
Join Date: Apr 2000
Location: Brisbane, Australia
Posts: 1,073
|
|
Quote:
Originally Posted by vietkool
Hi all,
My database now is more than 1gb, I used Cpanel and phpmyadmin to backup but it time out all the time it can only back up around 145Mb. Is there is any php back up program out there to do the back up either save to the host or ftp back to local pc . please help me out
thanks
|
google search for "mysqldumper" or "mydumper 0.5.1"
mydumper is 3x to 10x times faster than mysqldump 
__________________
:: vB benchmarks = Litespeed Cache 721x times faster than Apache
:: MySQL benchmarks (MariaDB 5.2 Intel Opt >MariaDB 5.2 >Percona 5.5 >MySQL 5.5)
:: MySQL backup/restore = mydumper > mysqldump
:: CentminMod.com = Nginx Menu Installer (ngx_pagespeed + SPDY supported)
|
08-23-2011, 05:30 PM
|
|
Web Hosting Master
|
|
Join Date: Apr 2011
Location: Las Vegas, NV
Posts: 1,385
|
|
Pull it into a different box with rsync. Synchronize as often as you like with a cron job.
|
08-23-2011, 08:09 PM
|
|
Your support partner
|
|
Join Date: Apr 2005
Location: Queen of Arabian Sea
Posts: 2,213
|
|
If you are interested in using a shell script, i can provide you with one.
|
08-24-2011, 09:57 AM
|
|
WHT Addict
|
|
Join Date: Jan 2004
Location: Bay Area
Posts: 133
|
|
Quote:
Originally Posted by eva2000
google search for "mysqldumper" or "mydumper 0.5.1"
mydumper is 3x to 10x times faster than mysqldump |
I did download the program but really don't know what to do with this program 
I am noob in Linux !!!
__________________
It's just the same like last time!!!
|
08-24-2011, 11:51 AM
|
|
Premium Member
|
|
Join Date: Apr 2000
Location: Brisbane, Australia
Posts: 1,073
|
|
online manual outlines usage with examples http://devdocs.mydumper.org/
__________________
:: vB benchmarks = Litespeed Cache 721x times faster than Apache
:: MySQL benchmarks (MariaDB 5.2 Intel Opt >MariaDB 5.2 >Percona 5.5 >MySQL 5.5)
:: MySQL backup/restore = mydumper > mysqldump
:: CentminMod.com = Nginx Menu Installer (ngx_pagespeed + SPDY supported)
|
08-24-2011, 12:58 PM
|
|
Junior Guru Wannabe
|
|
Join Date: Sep 2010
Location: OZ
Posts: 83
|
|
I always do backups manually. table by table. Never mind that last longer. Somehow I feel safer when I have the backup of the database on my computers.
__________________
Palm Beach limo and Fort Lauderdale limo , services clients needing prestige access to limos in: Palm Beach International Airport, Fort Lauderdale Airport, Boca Raton Airport and Miami International Airport...
|
08-25-2011, 02:23 AM
|
|
Web Hosting Master
|
|
Join Date: May 2009
Posts: 1,342
|
|
You must use MySQL replication.
The best even if you have a DB size of more than 10GB.
I have a database with 40 GB and its the best to replicate.
__________________
Softaculous - Auto Installer for cPanel, Direct Admin, InterWorx, Plesk, H-Sphere
The only Auto Installer that installs 260+ scripts. Install in just ONE STEP!
Virtualizor - VPS Control Panel supporting OpenVZ, Xen, KVM and has 60+ OS Templates
Webuzo - Softaculous for the Cloud i.e. Softaculous Standalone
|
08-26-2011, 09:44 AM
|
|
WHT Addict
|
|
Join Date: Jan 2004
Location: Bay Area
Posts: 133
|
|
Quote:
Originally Posted by infoman66
I always do backups manually. table by table. Never mind that last longer. Somehow I feel safer when I have the backup of the database on my computers.
|
manual? my forum total 192tables, and there are 2 or 3 tables contain threads, posts up to 300mb or 400mb for each table . How do you backup that table? the cpanel and phpmyadmin time out when doing back up around 145mb.
That's the reason why I need some third party can do the backup a large database without asking the hosting to do backup.
__________________
It's just the same like last time!!!
|
08-26-2011, 10:10 AM
|
|
Lord of live chats
|
|
Join Date: Jul 2009
Location: UK
Posts: 1,223
|
|
BACKUP:
mysqldump -u root -h localhost -pYOURPASSWORD database_name > mydatabase.sql
RESTORE:
mysql -uroot -pYOURPASSWORD < mydatabase.sql
Done.
|
08-26-2011, 02:58 PM
|
|
WHT Addict
|
|
Join Date: Jan 2004
Location: Bay Area
Posts: 133
|
|
I dont have root access , there is no way for me to do the command line like you show.
What I need is a program that upload to my host then config that program to run the backup the database.
__________________
It's just the same like last time!!!
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
| Postbit Selector |
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
| Login: |
|
|
| Advertisement: |
|
|
| Web Hosting News: |
|
|
|
