CPU-World.com forums :: View topic - How to make backup of web site

	News · Chips · Information · Forum · Links · About	Contact Us

	FAQ · Memberlist · Usergroups · Profile · Private Messages · Log in · Register	Search

How to make backup of web site

Goto page Previous 1, 2

CPU-World.com forums Forum Index -> Off Topic

View previous topic :: View next topic

Author

Message

Marcin

Joined: 02 Jan 2005
Posts: 8519
Location: Poland

Posted: Wed Mar 19, 2008 2:33 pm Post subject:

Cpuswe wrote:

(Found the link to the mysql software i was looking for...)

For dumping the database i have used this http://www.mysqldumper.de/en/ . If you are allowed to run a cron job, this can dump your database every day/week or so. Otherwise you have to do it manually. If you have access to the database password and other credentials?

When i was in cpanel 9 at my previous provider i made a small cron job that .gzipped the contents of the public_html directory where all my sites where and put it so that my home computer could get it via FTP. On my computer i ran Cobian backup that once a week downloaded the gzipped file via ftp (which also contained the mysql dumps)

The command was "tar czf backup/site.tgz public_html" and i put that as a cron job. I have no idea if that will work on your provider and you have to modify with your directory names and paths. Be aware that this takes CPU!. I had shell access to my site so i could test the command before trying to run it in cron.

Otherwise you just have to download the site with FTP every day/week manually i think.

I did backup by PHP. Took about 20 seconds (all tables). At result I got archived file xxx.sql.gz which have weight 92 kb. That is possible ?
_________________
Visit ABC CPU - Virtual CPU Museum.

Cpuswe

Joined: 15 Mar 2005
Posts: 2214
Location: Karlskrona, Sweden

Posted: Wed Mar 19, 2008 2:46 pm Post subject:

Marcin wrote:

I did backup by PHP. Took about 20 seconds (all tables). At result I got archived file xxx.sql.gz which have weight 92 kb. That is possible ?

Sounds resonable. The database itself only contains text and when you zip it will shrink very much. I made a SQLdump of chipdb.org now to compare, 1.63 Mbyte unzipped and 346 Kilobytes zipped. That is 5273 images in 1131 categories.

Edit: Just unzip the file and open the .sql file in WORDPAD to see how it looks. Its just a looooong file of SQL commands...

--
-- Table structure for table `4images_categories`
--

CREATE TABLE `4images_categories` (
`cat_id` int(10) unsigned NOT NULL auto_increment,
`cat_name` varchar(255) NOT NULL default '',
`cat_description` text NOT NULL,
`cat_parent_id` int(10) unsigned NOT NULL default '0',
`cat_hits` int(10) unsigned NOT NULL default '0',
`cat_order` int(10) unsigned NOT NULL default '0',
`auth_viewcat` tinyint(2) NOT NULL default '0',
`auth_viewimage` tinyint(2) NOT NULL default '0',
`auth_download` tinyint(2) NOT NULL default '0',
`auth_upload` tinyint(2) NOT NULL default '0',
`auth_directupload` tinyint(2) NOT NULL default '0',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_sendpostcard` tinyint(2) NOT NULL default '0',
`auth_readcomment` tinyint(2) NOT NULL default '0',
`auth_postcomment` tinyint(2) NOT NULL default '0',
`cat_master` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_parent_id` (`cat_parent_id`),
KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1324 ;

--
-- Dumping data for table `4images_categories`
--

INSERT INTO `4images_categories` (`cat_id`, `cat_name`, `cat_description`, `cat_parent_id`, `cat_hits`, `cat_order`, `auth_viewcat`, `auth_viewimage`, `auth_download`, `auth_upload`, `auth_directupload`, `auth_vote`, `auth_sendpostcard`, `auth_readcomment`, `auth_postcomment`, `cat_master`) VALUES (16, 'SX2-50', '', 7, 125, 40, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
(17, 'SX2-66', '', 7, 187, 60, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
(954, '5k86', '', 2, 359, 120, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
(955, '250', '', 41, 95, 30, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
(21, '5x86', '', 2, 1024, 130, 0, 0, 2, 2, 9, 0, 0, 0, 0, 1),
(22, '133', '', 21, 233, 10, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
(23, '150', '', 21, 142, 20, 0, 0, 2, 2, 9, 0, 0, 0, 0, 0),
_________________
My collection: http://www.cpucollection.se :::::: http://www.chipdb.org Photos of chips you never knew existed. Now over 6000 different chips in the database.

Marcin

Joined: 02 Jan 2005
Posts: 8519
Location: Poland

Posted: Wed Mar 19, 2008 3:19 pm Post subject:

Cpuswe wrote:

Just unzip the file and open the .sql file in WORDPAD to see how it looks. Its just a looooong file of SQL commands...

I agree that is very looong code after opening in text editor.

Hmmm I changed login and password in this program and after refreshed browser I got 500 Internal Server Error. I cannot open dumper. CPUSwe did you had this problem before ?
_________________
Visit ABC CPU - Virtual CPU Museum.

Cpuswe

Joined: 15 Mar 2005
Posts: 2214
Location: Karlskrona, Sweden

Posted: Wed Mar 19, 2008 3:32 pm Post subject:

Marcin wrote:

Cpuswe wrote:

Just unzip the file and open the .sql file in WORDPAD to see how it looks. Its just a looooong file of SQL commands...

Nope i only used the interface once or twice to generate the config, after that i only ran dumps as a cron job.
_________________
My collection: http://www.cpucollection.se :::::: http://www.chipdb.org Photos of chips you never knew existed. Now over 6000 different chips in the database.

Marcin

Joined: 02 Jan 2005
Posts: 8519
Location: Poland

Posted: Wed Mar 19, 2008 3:43 pm Post subject:

something was done not correctly at changing login inside server because after remove all dumper's files and uploaded new still I get error and is not able to install once again. Maybe I must wait a day when server will refresh its memory I will fight with it later ... backup file is on my HDD _________________ Visit ABC CPU - Virtual CPU Museum.

Display posts from previous:

	CPU-World.com forums Forum Index -> Off Topic	All times are GMT - 5 Hours Goto page Previous 1, 2
Page 2 of 2


	You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum