QUOTE (laurent @ Oct 24 2007, 07:39 AM)
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