I need help moving a site with mysql db to another domain
 

Who is available for a small job? I had a guy about to start on this but as most coders and designers do, they just go MIA and leave ya hanging.

have the new host import it, they usually do it for free

That's right

I'm no coder or designer but I could probably give you help.

I'm sure you can do it by one click in cpanel.

Click upload backup then go to php my admin and upload the sql file and voila, done.

host...dont mess with it

I can do it np

ah, and if you need a designer, I'd love to help :)

If the database is huge, here's what I do:

1. Use this script to back up your current database.
- Edit the user/pass/database variables in that script
- Edit the BACKUPS directory variable to a temporary directory on your server, with 777 permissions.
- Rename that script to whateveryouwant.php and run it on your server.
- That will give you a compressed GZ file of your database, and it will be placed in the directory you specified above.
- It's also handy to run this script as a cron job for backups of your DB.

2. Now, on your new server....
- Upload the .GZ file from above
- Grab a copy of this script (it's called Big Dump) and edit the mysql variables for your NEW
database on your NEW server. (They're on line 80)
- Rename the script to whateveryouwant.php and put it on your new server.
- Put this script file in the same directory as the .GZ file, and run the script. From there you can select the .GZ file and it will import it to your new database, no matter how big that database might be.

Hope that helps. Let me know if you want help, I could probably move your database in about 2 minutes.

Mike

How big of a file? Have phpmyadmin?

Doing this for someone right now and available to help.

83830150

Covered. Big D to the rescue in about 4 seconds flat.

Thanks everyone!