I need help moving a site with mysql db to another domain - GoFuckYourself.com

DWB · 07-15-2008, 12:08 PM

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.

czarina · 07-15-2008, 12:10 PM

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

Evil E · 07-15-2008, 12:12 PM

Quote:

Originally Posted by czarina

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

That's right

Evil E · 07-15-2008, 12:12 PM

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

buzzy · 07-15-2008, 12:13 PM

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.

Phoenix · 07-15-2008, 12:15 PM

host...dont mess with it

HorseShit · 07-15-2008, 12:16 PM

I can do it np

czarina · 07-15-2008, 12:17 PM

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

areagirls · 07-15-2008, 12:20 PM

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

baddog · 07-15-2008, 12:21 PM

How big of a file? Have phpmyadmin?

Ad3pt · 07-15-2008, 12:23 PM

Doing this for someone right now and available to help.

83830150

DWB · 07-15-2008, 12:23 PM

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

DWB · 07-15-2008, 12:27 PM

Thanks everyone!

07-15-2008, 12:08 PM	#1
DWB Registered User Industry Role: Join Date: Jul 2003 Location: Encrypted. Access denied. Posts: 31,779	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.

07-15-2008, 12:12 PM	#4
Evil E Confirmed User Join Date: Apr 2005 Location: Lazyness is a lifestyle Posts: 3,201	I'm no coder or designer but I could probably give you help. __________________ A girl once told me "Give me 8 inches and make it HURT". So, I fucked her twice and hit her with a brick.

07-15-2008, 12:15 PM	#6
Phoenix BACON BACON BACON Industry Role: Join Date: Nov 2002 Location: Poems everybody, the laddie fancies himself a poet Posts: 35,465	host...dont mess with it __________________ Skype Phoenixskype1 Telegram PhoenixBrad https://quantads.io

07-15-2008, 12:20 PM	#9
areagirls Confirmed User Join Date: Feb 2005 Posts: 1,678	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 __________________ WhoPaidMe - Cheque names, ePassporte IDs, Alexa data, combined review scores, new site launches & promos, for every sponsor and every niche!

07-15-2008, 12:23 PM	#11
Ad3pt Confirmed User Join Date: Aug 2002 Location: California Posts: 476	Doing this for someone right now and available to help. 83830150 __________________ Don't look here for the joke. It's in your pants. South O - World Class surfer destination since 2001.

07-15-2008, 12:10 PM	#2
czarina Webmaster Extraordinaire Industry Role: Join Date: Jul 2002 Location: A beautiful beach... Posts: 10,748	have the new host import it, they usually do it for free

07-15-2008, 12:13 PM	#5
buzzy Confirmed User Join Date: May 2007 Posts: 2,606	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.

07-15-2008, 12:16 PM	#7
HorseShit Too lazy to set a custom title Join Date: Dec 2004 Posts: 17,513	I can do it np

07-15-2008, 12:17 PM	#8
czarina Webmaster Extraordinaire Industry Role: Join Date: Jul 2002 Location: A beautiful beach... Posts: 10,748	ah, and if you need a designer, I'd love to help

07-15-2008, 12:21 PM	#10
baddog So Fucking Banned Industry Role: Join Date: Apr 2001 Location: the beach, SoCal Posts: 107,089	How big of a file? Have phpmyadmin?

07-15-2008, 12:27 PM	#13
DWB Registered User Industry Role: Join Date: Jul 2003 Location: Encrypted. Access denied. Posts: 31,779	Thanks everyone!