Need help testing a Wiki restore

[BarryK]

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!

[BarryK]

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: Select all

$ 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: Select all

$ 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?

...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?

[MU]

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

[raffy]

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

[Guest]

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.

[raffy]

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).

[flavour]

I can do this - have PM'd Barry

F