Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Migration from one server to another


Stewart Gilray

Recommended Posts

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.

Link to comment
Share on other sites

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.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

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 :-/

Link to comment
Share on other sites

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.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...