Differences between backup from phpMySQLAutoBackup and other

Post your support requests/solutions for phpJobScheduler [website]
Dax

Differences between backup from phpMySQLAutoBackup and other

Postby Dax » Thu May 01, 2008 9:07 am

Sorry, I know it's not the good forum but I have just a question, so please just take a minute to read my post.
I have make a comparison between differents backup made by 4 ways.
1. phpMySQLAutoBackup
2. phpMyAdmin
3. backup script
4. backup directly from my classifieds script

Here are the codes, let me know if there's something wrong. Thanks in advance.

1.

Code: Select all

create table phpclass_ad (
  ad_id int(11) not null auto_increment,
  ad_owner int(11) default '0' ,
  ad_cat_id int(11) default '0' ,
  ad_title varchar(255) default '0' ,
  ad_description text ,
  ad_date int(11) default '0' ,
  ad_date_expire int(11) default '0' ,
  ad_date_updated int(11) default '0' ,
  ad_expires_after_days int(11) default '0' ,
  ad_owner_notified tinyint(1) default '0' ,
  ad_has_video tinyint(1) default '0' ,
  ad_has_picture tinyint(1) default '0' ,
  ad_has_doc int(11) default '0' ,
  ad_views int(11) default '0' ,
  ad_votes double(6,2) default '0.00' ,
  ad_voters int(11) default '0' ,
  ad_totalscore double(6,2) default '0.00' ,
  ad_last_vote_ip varchar(20) default '0' ,
  ad_is_validated tinyint(1) default '0' ,
  ad_is_sold tinyint(1) default '0' ,
  ad_is_special tinyint(1) default '0' ,
  ad_is_premium tinyint(1) default '0' ,
  PRIMARY KEY (ad_id)
);

insert into phpclass_ad (ad_id, ad_owner, ad_cat_id, ad_title, ad_description, ad_date, ad_date_expire, ad_date_updated, ad_expires_after_days, ad_owner_notified, ad_has_video, ad_has_picture, ad_has_doc, ad_views, ad_votes, ad_voters, ad_totalscore, ad_last_vote_ip, ad_is_validated, ad_is_sold, ad_is_special, ad_is_premium) values ('32', '20', '72', 'MAISON DE VILLAGE', 'TRES BELLE APPARTEMENT CLIMATISE DANS MAISON AU CENTRE DU VILLAGE', '1174066444', '1210350844', '1202111808', '0', '0', '0', '4', '0', '808', '0.00', '0', '0.00', '0', '1', '0', '0', '0');
insert into phpclass_ad (ad_id, ad_owner, ad_cat_id, ad_title, ad_description, ad_date, ad_date_expire, ad_date_updated, ad_expires_after_days, ad_owner_notified, ad_has_video, ad_has_picture, ad_has_doc, ad_views, ad_votes, ad_voters, ad_totalscore, ad_last_vote_ip, ad_is_validated, ad_is_sold, ad_is_special, ad_is_premium) values ('33', '20', '83', 'YAMAHA VIRAGO', 'TRES BELLE MOTO VIROGO BLEU NUIT 20000KMS ANNEE 91 PORTE BAGAGES PRIX 1800?', '1174067919', '1210352319', '1202111599', '0', '0', '0', '0', '0', '380', '0.00', '0', '0.00', '0', '1', '0', '0', '0');


2.

Code: Select all

CREATE TABLE IF NOT EXISTS `phpclass_ad` (
  `ad_id` int(11) NOT NULL auto_increment,
  `ad_owner` int(11) default '0',
  `ad_cat_id` int(11) default '0',
  `ad_title` varchar(255) default '0',
  `ad_description` text,
  `ad_date` int(11) default '0',
  `ad_date_expire` int(11) default '0',
  `ad_date_updated` int(11) default '0',
  `ad_expires_after_days` int(11) default '0',
  `ad_owner_notified` tinyint(1) default '0',
  `ad_has_video` tinyint(1) default '0',
  `ad_has_picture` tinyint(1) default '0',
  `ad_has_doc` int(11) default '0',
  `ad_views` int(11) default '0',
  `ad_votes` double(6,2) default '0.00',
  `ad_voters` int(11) default '0',
  `ad_totalscore` double(6,2) default '0.00',
  `ad_last_vote_ip` varchar(20) default '0',
  `ad_is_validated` tinyint(1) default '0',
  `ad_is_sold` tinyint(1) default '0',
  `ad_is_special` tinyint(1) default '0',
  `ad_is_premium` tinyint(1) default '0',
  PRIMARY KEY  (`ad_id`)
) TYPE=MyISAM AUTO_INCREMENT=559 ;

--
-- Contenu de la table `phpclass_ad`
--

INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`) VALUES (32, 20, 72, 'MAISON DE VILLAGE', 'TRES BELLE APPARTEMENT CLIMATISE DANS MAISON AU CENTRE DU VILLAGE', 1174066444, 1210350844, 1202111808, 0, 0, 0, 4, 0, 808, 0.00, 0, 0.00, '0', 1, 0, 0, 0);
INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`) VALUES (33, 20, 83, 'YAMAHA VIRAGO', 'TRES BELLE MOTO VIROGO BLEU NUIT 20000KMS\r\nANNEE 91 PORTE BAGAGES PRIX 1800?', 1174067919, 1210352319, 1202111599, 0, 0, 0, 0, 0, 381, 0.00, 0, 0.00, '0', 1, 0, 0, 0);


3.

Code: Select all

CREATE TABLE `phpclass_ad` (
  `ad_id` int(11) NOT NULL auto_increment,
  `ad_owner` int(11) default '0',
  `ad_cat_id` int(11) default '0',
  `ad_title` varchar(255) default '0',
  `ad_description` text,
  `ad_date` int(11) default '0',
  `ad_date_expire` int(11) default '0',
  `ad_date_updated` int(11) default '0',
  `ad_expires_after_days` int(11) default '0',
  `ad_owner_notified` tinyint(1) default '0',
  `ad_has_video` tinyint(1) default '0',
  `ad_has_picture` tinyint(1) default '0',
  `ad_has_doc` int(11) default '0',
  `ad_views` int(11) default '0',
  `ad_votes` double(6,2) default '0.00',
  `ad_voters` int(11) default '0',
  `ad_totalscore` double(6,2) default '0.00',
  `ad_last_vote_ip` varchar(20) default '0',
  `ad_is_validated` tinyint(1) default '0',
  `ad_is_sold` tinyint(1) default '0',
  `ad_is_special` tinyint(1) default '0',
  `ad_is_premium` tinyint(1) default '0',
  PRIMARY KEY  (`ad_id`)
) TYPE=MyISAM AUTO_INCREMENT=534;


INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`) values('32', '20', '72', 'MAISON DE VILLAGE', 'TRES BELLE APPARTEMENT CLIMATISE DANS MAISON AU CENTRE DU VILLAGE', '1174066444', '1210350844', '1202111808', '0', '0', '0', '4', '0', '779', '0.00', '0', '0.00', '0', '1', '0', '0', '0');
INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`) values('33', '20', '83', 'YAMAHA VIRAGO', 'TRES BELLE MOTO VIROGO BLEU NUIT 20000KMS
ANNEE 91 PORTE BAGAGES PRIX 1800?', '1174067919', '1210352319', '1202111599', '0', '0', '0', '0', '0', '352', '0.00', '0', '0.00', '0', '1', '0', '0', '0');


4.

Code: Select all

create table phpclass_ad
(
   ad_id int auto_increment primary key,
   ad_owner int,
   ad_cat_id int,
   ad_title varchar(255),
   ad_description text,
   ad_date int,
   ad_date_expire int,
   ad_date_updated int,
   ad_expires_after_days int,
   ad_owner_notified int,
   ad_has_video int,
   ad_has_picture int,
   ad_has_doc int,
   ad_views int,
   ad_votes real,
   ad_voters int,
   ad_totalscore real,
   ad_last_vote_ip varchar(20),
   ad_is_validated int,
   ad_is_sold int,
   ad_is_special int,
   ad_is_premium int
);

insert into phpclass_ad (ad_id, ad_owner, ad_cat_id, ad_title, ad_description, ad_date, ad_date_expire, ad_date_updated, ad_expires_after_days, ad_owner_notified, ad_has_video, ad_has_picture, ad_has_doc, ad_views, ad_votes, ad_voters, ad_totalscore, ad_last_vote_ip, ad_is_validated, ad_is_sold, ad_is_special, ad_is_premium) values (32, 20, 72, "MAISON DE VILLAGE", "TRES BELLE APPARTEMENT CLIMATISE DANS MAISON AU CENTRE DU VILLAGE", 1174066444, 1210350844, 1202111808, 0, 0, 0, 4, 0, 755, 0, 0, 0, "0", 1, 0, 0, 0);
insert into phpclass_ad (ad_id, ad_owner, ad_cat_id, ad_title, ad_description, ad_date, ad_date_expire, ad_date_updated, ad_expires_after_days, ad_owner_notified, ad_has_video, ad_has_picture, ad_has_doc, ad_views, ad_votes, ad_voters, ad_totalscore, ad_last_vote_ip, ad_is_validated, ad_is_sold, ad_is_special, ad_is_premium) values (33, 20, 83, "YAMAHA VIRAGO", "TRES BELLE MOTO VIROGO BLEU NUIT 20000KMS\r\nANNEE 91 PORTE BAGAGES PRIX 1800?", 1174067919, 1210352319, 1202111599, 0, 0, 0, 0, 0, 330, 0, 0, 0, "0", 1, 0, 0, 0);

davidgwalker
MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
Posts: 1807
Joined: Mon Oct 25, 2004 8:20 pm
Location: Huddersfield, UK
Contact:

Postby davidgwalker » Mon May 26, 2008 3:13 pm

Hi,

It "appears" all the data is there in all the methods used (however, to be sure you should carry out your own testing - make your backup then restore it and check all data is there).

Cheers

Dave.


Return to “phpJobScheduler [forum]”

Who is online

Users browsing this forum: No registered users and 2 guests