Date parsed: 19/04/2008 10:21:49
Date: Sat, 19 Apr 2008 09:21:49 +0100

Tony wrote:
> Please, how can I get the SQL data moved from one host to another? I've
> done Google!
>

Sounds like you're a long way from understanding your problem, let alone
the solution, so you seem a bit out of your depth (as we all have been
at some point). Noone here will be able to tell you anything useful
without much more detail about your current set up. I'm guessing there
is a database-driven website which you want to relocate, and you want to
know how to download the data from one site and reload it to another.
You'll need to tell the group what database software is being used (same
on both hosts?), and then someone who uses that software might be able
to advise you. If you don't have that information, then at least tell
us which blogging package is being used.

Phil, London

Date parsed: 20/04/2008 13:07:15
Date: Sun, 20 Apr 2008 13:07:15 GMT

"Mark Goodge" <usenet@listmail.good-stuff.co.uk> wrote in message
news:3tej04dectlhi0q45p23rb3cmrf63u4c9t@news.markshouse.net...
> On Sat, 19 Apr 2008 07:48:05 GMT, Tony put finger to keyboard and
> typed:
>
>>Please, how can I get the SQL data moved from one host to another? I've
>>done Google!
>
> Short answer: Install phpMyAdmin on your existing host, use that to
> generate an SQL backup, install your blog and PhpMyAdmin on the new
> host and then import the SQL backup that you prepared earlier. There
> are detailed instructions for backing up and restoring a blog using
> PHPMyAdmin at http://codex.wordpress.org/Backing_Up_Your_Database -
> this is applicable even if you're not using Wordpress.

Sorry to be ignorant but as this is not really a commercial concern it is
not possible to pay experts and I have to do it myself as best I can! I am
very grateful for all help. I am prepared to learn to use as much SQL as
necessary but unfortunately I have a few other things to do.

My host already has phpMyAdmin installed. There is no backup command shown
as such but there is a command to save a dump as a file which I have now
done. The dump appears to be a set of SQL commands for creating and
populating a set of tables. So presumably I can just create an empty
database, point SQL on my new host to the text file and ask it to run.
Right?

BTW the blog is currently runing on Nucleus.

--
Tony W
My e-mail address has no hyphen
- but please don't use it, reply to the group.

Date parsed: 20/04/2008 15:57:20
Date: Sun, 20 Apr 2008 14:57:20 +0100

Message-ID: <7eHOj.11724$yD2.10729@text.news.virginmedia.com> from Tony
contained the following:

> So presumably I can just create an empty
>database, point SQL on my new host to the text file and ask it to run.
>Right?

You do it via PHPMyadmin. Click the import tab and then point it at the
location of this text file.

Occasionally I've had problems doing this between different versions,
but they are not too difficult to sort out.
--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011

Date parsed: 22/04/2008 10:17:55
Date: Tue, 22 Apr 2008 10:17:55 GMT

"Geoff Berrow" <blthecat@ckdog.co.uk> wrote in message
news:0kln04183scvtd7s269r5u28ptudvpclqp@4ax.com...
>
> Click on one of the tables in the left hand pane and it will bring up
> details of the table. The import tab should be at the top of the right
> hand pane.

That's the problem - there are no tabs :) I really think it must be Lycos
Europe's version of PhpMyAdmin that is odd.

Anyway I have now decided I need to understand the whole thing better so I
have set up WAMP on my home Windows PC so I can play. (After a few hiccups
of course!) PHPMyAdmin on my own PC has two panes and tabs as you
describe, and I have successfully imported the tables that I dumped. So I
am more confident of being able to transfer the tables to a new host. Now I
will have a go at transferring the works of the blog to my home PC ...
Thanks for advice, no doubt I will be back for more!

--
Tony W
My e-mail address has no hyphen
- but please don't use it, reply to the group.

Date parsed: 25/04/2008 00:05:44
Date: Thu, 24 Apr 2008 23:05:44 +0100

In message <7ilr04dm2v8gjjvvnelrp5obiedb63uqga@4ax.com>, Geoff Berrow
<blthecat@ckdog.co.uk> writes
>Message-ID: <nXiPj.12819$yD2.11716@text.news.virginmedia.com> from Tony
>contained the following:
>
>>That's the problem - there are no tabs :) I really think it must be Lycos
>>Europe's version of PhpMyAdmin that is odd.
>>
>>Anyway I have now decided I need to understand the whole thing better so I
>>have set up WAMP on my home Windows PC so I can play. (After a few hiccups
>>of course!) PHPMyAdmin on my own PC has two panes and tabs as you
>>describe, and I have successfully imported the tables that I dumped. So I
>>am more confident of being able to transfer the tables to a new host. Now I
>>will have a go at transferring the works of the blog to my home PC ...
>>Thanks for advice, no doubt I will be back for more!
>
>
>You may be able to find a backup script somewhere if you don't have any
>luck with the phpMyAdmin

Indeed - this is the PHP I use on a number of sites for the client to
make a backup of the MySQL database.

//set the database parameters ready for the mysqldump command
$host = "";
$database = "";
$user = "";
$password = "";

$filename = "web_data_" . date("Y-m-d-H-i-s") . '.gz';

//set the site and directory in following line
$backupfile = "/home/site/backup_dir/".$filename;

//build the backup command
$command = "mysqldump --opt --host=$host --user=$user --password=$password $database | gzip > $backupFile";

//run the command
$result = system($command, $retval);

//serve the file to the user's browser
header ("HTTP/1.0 200 OK");
header ("Content-Type: application/x-gzip");
header ("Content-Disposition: attachment; filename=$filename");
readfile($backupfile);


--
Dominic Sexton