Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Thu 23 May 2013, 00:29
All times are UTC - 4

 Forum index » Taking the Puppy out for a walk » Announcements
Need help testing a Wiki restore
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [7 Posts]  
Author Message
BarryK
Puppy Master


Joined: 09 May 2005
Posts: 6856
Location: Perth, Western Australia
PostPosted: Mon 03 Oct 2005, 23:37    Post subject:  Need help testing a Wiki restore  
Right now, I am attempting to backup the mysql database.
I don't know what happens if people are editing it at the same time!
Back to top
View user's profile Send private message Visit poster's website 
BarryK
Puppy Master


Joined: 09 May 2005
Posts: 6856
Location: Perth, Western Australia
PostPosted: Mon 03 Oct 2005, 23:54    Post subject: Okay, wiki backed up  
Well, that was easy.

For anyone else who is interested, this is what I did:

1.
Used one of Puppy's very easy SSH telnet programs to login to goosee.com.

2.
Ran this command:
Code:
$ mysqldump -p -u username databasename > mydata.sql
$ gzip mydata.sql


Now I can download it.
Apparently, to use it on a new server, all we need to do is upload it then:

Code:
$ gunzip mydata.sql.gz
$ mysql -p -u username mydatabase < mydata.sql


...I wonder though, do you think it would be best if the new mysql
database has the same name?

So, Puppy Foundation, where's the new server to upload to?
Smile
...doesn't matter. now that I know how to backup, I'll do it regularly
until we are ready to move.
...though, I would like to do a test move. If I make mydata.sql.gz
available for download, could someone test setting it up with wika wiki?
Back to top
View user's profile Send private message Visit poster's website 
MU


Joined: 24 Aug 2005
Posts: 13642
Location: Karlsruhe, Germany
PostPosted: Tue 04 Oct 2005, 00:22    Post subject:  
I want to have a closer look to my database at noforum.de this weekend, might try it then, if no one else will try before.

Mark
Back to top
View user's profile Send private message Visit poster's website 
raffy

Joined: 25 May 2005
Posts: 4636
Location: Manila
PostPosted: Tue 04 Oct 2005, 01:11    Post subject: Ready  
Site is ready anytime:

stet-vip.net

This can use only 5 GB bandwidth per month and 250 MB storage - good enough for testing.

Am trying to solicit for donation of high-bandwidth server - hope the reply will be OK Smile
_________________
Puppy user since Oct 2004. Want FreeOffice? Get the sfs (English only).
Back to top
View user's profile Send private message 
Guest
Guest
PostPosted: Tue 04 Oct 2005, 05:22    Post subject:  
I have provided raffy with the download details.
Mark, if you decide to test it, send me a p.m.

Note, the download file is 3.5M, becomes 23M uncompressed.
Back to top
raffy

Joined: 25 May 2005
Posts: 4636
Location: Manila
PostPosted: Tue 04 Oct 2005, 09:17    Post subject: Need server with higher MySQL version  
The server mentioned above uses these versions:

PHP version 4.3.11
MySQL version 4.0.24-standard-log

Barry's MySQL version is 4.1.7-standard-log

Anyone has the same or higher version please do the testing (PM Barry).
Back to top
View user's profile Send private message 
flavour

Joined: 08 Sep 2005
Posts: 124
Location: Bicester, UK
PostPosted: Tue 04 Oct 2005, 13:36    Post subject:  
I can do this - have PM'd Barry

F
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [7 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Taking the Puppy out for a walk » Announcements
Jump to:  


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 can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.0468s ][ Queries: 12 (0.0074s) ][ GZIP on ]