Customer Support

To FTP a dumpfile directly from the old host to here, type this at your
old host's shell prompt after you have created the dumpfile:

    ftp ftp.modwest.com

Enter your Modwest username at the first prompt.
Enter your Modwest password at the second prompt. (It will not echo back
as you type).

Then you will be logged in and have a prompt like this:

230 User logged in.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> 

Then type:

     put dbname.sql

where 'dbname.sql' is the name of your dumpfile, and it will copy the
file to your account here. 

When you see:

226 Transfer complete.

It is finished and you can then follow the import FAQ:

    http://www.modwest.com/help/kb.phtml?cat=6&qid=241

To SCP a dumpfile directly from the old host to here, type this at your
old host's shell prompt after you have created the dumpfile:

       scp dbname.sql myself@ftp.modwest.com:/dbname.sql

where "dbname.sql" is the name of the dumpfile you just created and
"myself" is your Modwest hosting account username.

Enter your Modwest password at the prompt. (It will not echo back as you
type).

Then you'll see a progress bar as the file is copied to your account
here. Once it's done, then follow the import FAQ.

To copy tables between 2 databases hosted at Modwest, 

1. Make sure you have at least 2 databases here, both created using the
Add Database section of your Control Panel

2. Use the Manage Databases link in your control panel and you'll see
both databases. 

3. Click the + sign next to the database name in the left window pane to
expand it to see the individual tables.

4. Click a table name in the left pane

5. Click Operations in the right pane

6. Pull down the appropriate dropdown menus for "Move Table To" and then
pull the dropdown for the new database name. Click "Go".

7. Do the same thing for every table in the original db that you want to
copy.

If you have a lot of data, you should avoid the 'extended insert' option
when creating the dump,
(http://dev.mysql.com/doc/mysql/en/mysqldump.html) because otherwise you
could run into 'max_allowed_packet' errors when importing the dump.

Tarantula From Inverted Software can do that for you. Download it and
define the old and new servers. then connect to both of them, right
click the database you need to move and select "copy". then just paste
it into the new server.

For databases on various servers you can specify the database server
with the -h flag.

Two explicit examples

mysqldump -u DBUSER -h db.modwest.com -p DBNAME > DBNAME.sql
mysqldump -u DBUSER -h db1.modwest.com -p DBNAME > DBNAME.sql