Moving from GoDaddy

[Geo]

Hi,

like some others on this board GoDaddy have forced me off their servers by claiming high CPU usage and shutting off my site.

Only now I find I cannot access mysql database. I have managed to download a 'sqlbackup.tar'.

If I make a fresh install nother server, is the 'sqlbackup.tar' enough to enable me to restore my blog?

Thanks.

[garvinhicking]

Hi!

That depends on the contents of your sqlbackup.tar package. Did you look into it, does it contain a complete SQL dump with all of your data?

If you load that to a new server, you'll have your database intact. You will still need all the extra files you possibly had on your old blog: Media files (images, documents) and possibly custom plugins (if you uploaded them previously) or custom templates/modifications. You'll need to get those via FTP as well.

Then you can upload a usual serendipity release to your blog, and manually create a serendipity_config_local.inc.php file. It should look like this:

Code: Select all

<?php
        $serendipity['versionInstalled']  = '1.3-alpha1';
        $serendipity['dbName']            = 'serendipity';
        $serendipity['dbPrefix']          = 'serendipity10_';
        $serendipity['dbHost']            = '127.0.0.1';
        $serendipity['dbUser']            = 'root';
        $serendipity['dbPass']            = 'pass';
        $serendipity['dbType']            = 'mysql';
        $serendipity['dbPersistent']      = false;
?>

You must there enter the right database access details to your new imported database, and you must enter the versionInstalled number of the serendipity version you had on your old host.

Feel free to ask for specific details if you're having problems.

Regards,
Garvin

[Geo]

Hi Garvin

My '2007-10-10-22-37_sqlbackup.tar' contains 32 sql files. Does that sound right?

One has INSERT_serendpity_emtries.sql etc... and is about 1MB

However when I extract it, it makes a new 'last_backup' direcrory which contains much smaller files and not all the data.

On my new server can I upload the uncompressed '2007-10-10-22-37_sqlbackup.tar'?

Thanks.

[Geo]

OK I managed to upload my entries.sql from the .tar file using PhpAdmin import, but I haven't done the rest.

Is there a faster way to do this,rather than manually adding each .sql file by hand? Can I use FTP and which directory wwould I upload the .sql files to?

Thanks

[chickens]

I've had good luck importing SQL data with BigDump when not having access to the shell.
http://www.ozerov.de/bigdump.php