IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
Free Database Backup Software, One click backup
Thom Pearson
post 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 smile.gif

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 :)
Go to the top of the page
 
+Quote Post
laurent
post 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 smile.gif

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
Go to the top of the page
 
+Quote Post
Thom Pearson
post 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 :)
Go to the top of the page
 
+Quote Post
Thom Pearson
post 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



QUOTE (laurent @ Oct 24 2007, 07:39 AM) *
Hi Thom,

Thank you for this great tool smile.gif

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 smile.gif

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 :)
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 28th March 2024 - 10:57 AM