I Need To Move A Database

[combs84]

Please Read this before you say you can do it. I have had 4 people say they could do it, eventually ending up saying, oh wait...I can't.

I have 2 Databases I need to have moved. One for one site, and one for another.

One is around 50MB, one is bigger than 100mb i believe.

You cannot use PHPMYADMIN for this. You can export the db's with PHPMyAdmin, however the new host it is moving to only allows DB uploads of up to something stupid like 2MB.

So you must upload the Databases using SSH. Here are the directions that the new host gives.

To import a MySQL dump, first upload the dump file to your web space via FTP.
Once the file is in your web space, please login to your shell account via SSH and
run this command:

myShell:~ > mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
Enter password:
mysql>

You must use a SSH program.

If you know how to do this for me, please let me know. I am willing to overpay a little bit to get this done. Hopefully you also have a messaging program as well, MSN, Yahoo or AIM...

Name a price. Tell me you are SURE you can do it. Tell me when you can do it. And lets do it!!

 

[NewYorkBum]

How did you backup the db at the old server ?
Do you have the db backed up and placed on the new server already ?
Did you try it yourself ? If yes, what was the problem

 

[netzilla]

PM Sent

 

[Robert Allen]

I have uploaded a 250mb SQL database using this method before, but that was nearly a year ago, and i don't think i can remember how i did it, but your hosts directions are not very good compared to the tutorial i was reading.

Pm me if you are interested, i cant garentee that i can do it.

Rob

 

[combs84]

How did you backup the db at the old server ?
Do you have the db backed up and placed on the new server already ?
Did you try it yourself ? If yes, what was the problem

I still have the DB's on the other servers. They can be backed up and saved via the other hosts phpmyadmin.

I uploaded it via FTP when I tried it..but a new one needs to be one there as it;s old now obviously.

3.Yes I did. And the prob was I didn't know what I was doing

I got Pm'd for somebody to do it for $100..kind of a lot more than I was expecting.

Anybody do it in the $50 range?

 

[netzilla]

PM replied.

 

[G33K]

Why don't you ask your new host if they can do you a favor and install it for you?

they might charge like only 20 dollars or something.

doesn't hurt to ask!!!

 

[faisj]

Hi there,

maybe this will would work.
I tested it just now, and it should work.

It's the NamePros MySQL Database Backup / Restore Tool LOL

Download the 2 files, edit them and I think you understand the idea of the files.
Goodluck!

kind regards,

Faisj

 

[ablaye]

Do you still need someone for this job?