Free Database Backup Software, One click backup |
Free Database Backup Software, One click backup |
Oct 7 2007, 03:18 PM
Post
#1
|
|
I am, therefore I think :) Group: PM Unlimited Posts: 4,269 Joined: 5-January 06 From: Denmark Member No.: 125 |
This is what I use to backup my databases.
It is very easy to setup http://www.dwalker.co.uk/phpmysqlautobackup/ It says on the site " Operating System: FreeBSD or Linux", but I have not yet found any system it does not run on, and I run a few different systems. When you have it setup just make a favorites link in your browser to the run.php on the server and Voila your database backup arrives in your email inbox a few seconds after you click it. best wishes Thom -------------------- Verify Script My Forum - inc. Free Plugins For Ventrino TEs When you signup at the forum you have to ask for access to the hidden areas before you can see what goes on :) |
|
|
Oct 24 2007, 07:39 AM
Post
#2
|
|
WSF Junkie Group: PM Unlimited Posts: 184 Joined: 10-February 06 Member No.: 172 |
Hi Thom,
Thank you for this great tool Did you check the files inside zip files ? Is it one INSERT per field ? (because of the limitation of char per insertion) Did you perform one database restore (with the restored database matching exactly the backup database) ? I will also do these tests because here in France we use a different charset (é à è and A LOT OF ' ) Regards -------------------- regards
laurent |
|
|
Oct 24 2007, 08:13 AM
Post
#3
|
|
I am, therefore I think :) Group: PM Unlimited Posts: 4,269 Joined: 5-January 06 From: Denmark Member No.: 125 |
-------------------- Verify Script My Forum - inc. Free Plugins For Ventrino TEs When you signup at the forum you have to ask for access to the hidden areas before you can see what goes on :) |
|
|
Oct 24 2007, 08:26 AM
Post
#4
|
|
I am, therefore I think :) Group: PM Unlimited Posts: 4,269 Joined: 5-January 06 From: Denmark Member No.: 125 |
Hi Thom, Thank you for this great tool Did you check the files inside zip files ? Is it one INSERT per field ? (because of the limitation of char per insertion) Did you perform one database restore (with the restored database matching exactly the backup database) ? I will also do these tests because here in France we use a different charset (é à è and A LOT OF ' ) Regards hi Laurent, Is this what you mean? CODE // Below you can uncomment the variables to specify separate tables to backup, // leave commented out and ALL tables will be included in the backup. //$table_select[0]="MyFirstTableName"; //$table_select[1]="mySecondTableName"; //$table_select[2]="myThirdTableName"; //note: when you uncomment $table_select only the named tables will be backed up. $table_select[0]="ventrino_bb_configvars"; $table_select[1]="vtp_adclicker"; $table_select[2]="vtp_admins"; $table_select[3]="vtp_admin_limits"; $table_select[4]="vtp_alertpay"; $table_select[5]="vtp_approve"; $table_select[6]="vtp_auction"; $table_select[7]="vtp_banners"; $table_select[8]="vtp_blocks"; $table_select[9]="vtp_canned"; $table_select[10]="vtp_cash"; $table_select[11]="vtp_categories"; $table_select[12]="vtp_cheats"; $table_select[13]="vtp_comp"; $table_select[14]="vtp_configvars"; $table_select[15]="vtp_controlled_rotation"; $table_select[16]="vtp_emailfilter"; $table_select[17]="vtp_exchange_summary"; $table_select[18]="vtp_extend_execution"; $table_select[19]="vtp_faq"; $table_select[20]="vtp_gamelist"; $table_select[21]="vtp_items"; $table_select[22]="vtp_levels"; $table_select[23]="vtp_manager_extra"; $table_select[24]="vtp_material"; $table_select[25]="vtp_members"; $table_select[26]="vtp_member_info"; $table_select[27]="vtp_menus"; $table_select[28]="vtp_multihits"; $table_select[29]="vtp_newsletter"; $table_select[30]="vtp_partner"; $table_select[31]="vtp_paypal"; $table_select[32]="vtp_paypal_config"; $table_select[33]="vtp_pro_upgrade"; $table_select[34]="vtp_ptc_adverts"; $table_select[35]="vtp_ptc_campaign"; $table_select[36]="vtp_ptc_packages"; $table_select[37]="vtp_ptc_tracker"; $table_select[38]="vtp_quickie"; $table_select[39]="vtp_reported"; $table_select[40]="vtp_schedule"; $table_select[41]="vtp_slot"; $table_select[42]="vtp_slot_tracking"; $table_select[43]="vtp_soloads"; $table_select[44]="vtp_solo_tracking"; $table_select[45]="vtp_styles"; $table_select[46]="vtp_textad"; $table_select[47]="vtp_ticketposts"; $table_select[48]="vtp_tickets"; $table_select[49]="vtp_tracker_urls"; $table_select[50]="vtp_transfers"; $table_select[51]="vtp_upline_items"; $table_select[52]="vtp_urls"; $table_select[53]="vtp_virtual"; $table_select[54]="vtp_wordfilter"; $table_select[55]="ip2nation"; $table_select[56]="ip2nationcountries"; $limit_to=10000000; //total rows to export - IF YOU ARE NOT SURE LEAVE AS IS $limit There is one other setting that is not explained in the documentation In files/config.inc.php Change this line, change 'localhost' to your mysql server - example 'r1server3.ventrino.com' CODE $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address If you need any help, just ask best wishes Thom -------------------- Verify Script My Forum - inc. Free Plugins For Ventrino TEs When you signup at the forum you have to ask for access to the hidden areas before you can see what goes on :) |
|
|
Lo-Fi Version | Time is now: 26th September 2024 - 08:53 PM |