Migration from one server to another

[Stewart Gilray]

Hi I'm moving my store from my own Win32/Apache based server to an account hosted with Pair (great service).

 

Anyway, since I've added so many things to my site over the past 18 months, the database isn't like the normal one that gets installed during a standard install...

 

So my question is this...

 

I've come to "import/"restore" my database, but it is 8.6MB how can I install it without my browser timing out or is there a way I can install it via mysql command**.

 

** - I know there is, but I can't seem to get it to work via pair, anyone tried this, and if so what was the command line with pair, as the one suggested by osc, doesn't have the password listed and I NEED the password to be entered for it to work.

 

I would like some help on this as soon as possible please, as the store is a very popular one, many thanks in advance.

 

Stewart.

[AlanR]

Use phpMyAdmin and zip the file before you try to import it. Zipping it will reduce the file size by about 85% so you won't get the time out. gzip is even better.

 

phpMyAdmin automatically understands zip compressed files (and more).

 

I'd install a private copy of phpMyAdmin because it will give you more options, like defining server directories for import and export.

[Stewart Gilray]

Yeah I have it installed, but it doesn't (seem) to work.

 

Which is ticking me off, I've gzipped it down to 722k but still. hmmmmm...

 

Thanks.

[Stewart Gilray]

I've taken a look at my install of myphpadmin, and it's fairly basic, I've got no "local" import/export dirs specified.

 

I've just tried uploading/importing a 722k version of the database, it uploads, then the browser (phpadmins) window goes blank and says "done" at the bottom...

 

Is there any way to ensure the sql file is ok?! I've tried re-exporting directly from MY own install of myphpadmin gzipped too, and that didn't work either :-/

[Stewart Gilray]

Did a complete re-export and it was only 2.4MB in size....

 

And it imported to the new server fine. many thanks :-)

[AlanR]

In case you revisit this thread here are the config.inc.php lines to add for the server directories.

 

$cfg['UploadDir'] = '/file/system/path/to/the/directory/you/want/';

$cfg['SaveDir'] = '/file/system/path/to/the/directory/you/want/';

 

Basically you'll find all available options in config.default.php which depending on the version of PMA is in the PMA root or in /libraries. The latest versions put it in /libraries. So anything you copy into config.inc.php is read and overrides the defaults in config.default.php.

 

So essentially, config.inc.php is a subset of config.default.php.

 

There are lots of good features most people don't even know about.