Do you know how to move MySql databases? I need someone I can trust.. - GoFuckYourself.com - Adult Webmaster Forum

X

spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#1

Do you know how to move MySql databases? I need someone I can trust..

06-18-2006, 06:09 AM

This is giving me a headache trying to figure out,,,,
I'm trying to move all my sites & need to do it without any downtime.. This means moving all the content & databases off the old host to the new one & then once everything is completed & in working order, then I can change the dns once it is all properly functional.. (How do I check it, if the dns isnt changed)..

anyway.. this is a ballbuster for me because I don't know how to move MySql & really don't know anything about it at all, so am looking to pay somebody to do it for me,,,,

I need someone I can trust.. Trust is important as you'll have access to ftp of both hosting accts, as well as all the db info, etc....

also, payment will be via paypal.....

Leave your email, icq, price & I'm going to want reputable references...I need to be sure my shit isnt going to get fucked with.. like jacking my sites or DB/domains, etc...
Tags: None
Love Sex

Confirmed User

Join Date: Nov 2004

Posts: 1905
Share

Post
#2

06-18-2006, 06:29 AM

your new host will do it no problemo.
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#3

06-18-2006, 06:29 AM

well, the new host has phpmyadmin. the old host does not...

I see under manage databases it has an export option.. so, I got an old blog database i could fuck with because the blog was deleted, so i clicked export thinking this was the option to send that table to the new host or something.. anyway, that does not look like it does this as it gave me a text file of the table, so i go to the other host hoping for an import option or a create table option & was thinking i could copy the tables 1 by 1 until the whole db was finished..

I'm ready to just fucking dump all of it & start over....
Comment
Meorazhar

Confirmed User

Join Date: May 2005

Posts: 672
Share

Post
#4

06-18-2006, 06:33 AM

Just sent you an ICQ.. I don't have PayPal but i just moved my wordpress blog to another server and can give you the instructions.
Comment
minusonebit

So Fucking Banned

Join Date: Feb 2006

Posts: 7391
Share

Post
#5

06-18-2006, 06:56 AM

$10 per DB or $40 an hour, whichever winds up being cheaper. You didnt say how many need to be moved.

ICQ in my sig. Can do this sometime this evening.

As far as checking to see if your DNS changes have propagted, you can just ping your domain and see if it resolves to the IP of your new host or your old host.
Comment
Jace

FBOP Class Of 2013

Join Date: Jan 2004

Posts: 35562
Share

Post
#6

06-18-2006, 07:05 AM

You can set up phpmyadmin yourself dude, just install it and set it to call the database you need....easy cheesy
Comment
gooddomains

Too lazy to set a custom title

Join Date: Jul 2003

Posts: 10127
Share

Post
#7

06-18-2006, 07:21 AM

that's an easy one to do, did it like 4 times already this year alone
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#8

06-18-2006, 09:46 AM

Originally posted by Jace

You can set up phpmyadmin yourself dude, just install it and set it to call the database you need....easy cheesy

It is setup on the new host, I just don't know what to do with it
Comment
Heywood Jablome

Confirmed User

Join Date: Dec 2003

Posts: 869
Share

Post
#9

06-18-2006, 11:09 AM

Originally posted by spacedog

It is setup on the new host, I just don't know what to do with it

Export your databases and save them to your harddrive.

At your new host, use the phpmyadmin to import your exported data into your new databases. Just choose your database, click on the "SQL" button, and then browse your harddrive for your data file and press 'Go'.

email: [email protected]
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#10

06-18-2006, 11:29 AM

Originally posted by Heywood Jablome

Export your databases and save them to your harddrive.

At your new host, use the phpmyadmin to import your exported data into your new databases. Just choose your database, click on the "SQL" button, and then browse your harddrive for your data file and press 'Go'.

I do this & still not working.,, I exported & saved as .sql & tried just what you state & i get No sql query & under that i get No tables found in database.
Comment
Jace

FBOP Class Of 2013

Join Date: Jan 2004

Posts: 35562
Share

Post
#11

06-18-2006, 11:39 AM

Originally posted by spacedog

I do this & still not working.,, I exported & saved as .sql & tried just what you state & i get No sql query & under that i get No tables found in database.

if you are doing that on your new host that makes sense, there is nothing there

ypou need to setup phpmyadmin on your old host and export from there

I am taking a nap right now, but I will be back in about 2 hours, if you still don't have it done I will give you a hand
Comment
testpie

Mostly retired

Join Date: Apr 2006

Posts: 3231
Share

Post
#12

06-18-2006, 11:44 AM

Do you have shell access to the old host?

Affiliates: DogFart ~ Domain parking: NameDrive ~ Traffic broker: Traffic Holder
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#13

06-18-2006, 11:57 AM

Originally posted by Jace

if you are doing that on your new host that makes sense, there is nothing there

ypou need to setup phpmyadmin on your old host and export from there

I am taking a nap right now, but I will be back in about 2 hours, if you still don't have it done I will give you a hand

i setup db on new host.. i went to phpmyadmin on old host & exported & saved file as an .sql i went to new host phpmyadmin & did what he said in the above post & got the results i posted...

the export options are ;

SQL

LaTeX

CSV for Ms Excel data

CSV data

XML

I chose sql as looks like the obviously correct one to me..

so, next to this are sql options with check boxes;
Structure ( i have checked)
Add 'drop table' ( i do not have checked)
Add AUTO_INCREMENT value (i have checked)
Enclose table and field names with backquotes (i have checked)

underneath is another option;
Add into comments Creation/Update/Check dates ( i do not have checked)

then after that is
Data ( i have checked)(& the next 3 not checked)
Complete inserts
Extended inserts
Use delayed inserts
& under that is a selction box ; Export Type & options are insert, update, & replace.. I had insert selected..

then saved as file w/ __DB__ template & no compression
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#14

06-18-2006, 11:57 AM

Originally posted by testpie

Do you have shell access to the old host?

only shell on the new host.. phpmyadmin on both.
Comment
testpie

Mostly retired

Join Date: Apr 2006

Posts: 3231
Share

Post
#15

06-18-2006, 12:02 PM

Hmm. I'd be willing to help out, but i assume you probably don't know me - so trust will probably be an issue. I've helped BHC_Webmistress before with some FTPing, and that's about all the references i have.

But if you believe in the kindness of a stranger...

Affiliates: DogFart ~ Domain parking: NameDrive ~ Traffic broker: Traffic Holder
Comment
directfiesta

Too lazy to set a custom title

Join Date: Oct 2002

Posts: 30184
Share

Post
#16

06-18-2006, 12:40 PM

rsync ....

If your new host doesn't know this, well .....

Seems I am going to have 4 virtual accounts for grab:

P4 3.0 ghz
1 gig DDR ram
WHM/Cpanel
I dedicated IP
NS on other box

Storage: 30 gigs
BW: 500 gigs

Price : 45.00/month

Available from Monday ....

I know that Asspimple is stoopid ... As he says, it is a FACT !

But I can't figure out how he can breathe or type , at the same time ....
Comment
directfiesta

Too lazy to set a custom title

Join Date: Oct 2002

Posts: 30184
Share

Post
#17

06-18-2006, 12:45 PM

Originally posted by spacedog

only shell on the new host.. phpmyadmin on both.

On old server -----> phpmyadmin hahahaha=> export db

result: db-backup.txt

New Server -------> create db name, user and pass ( identical to old db )

phpmyadmin ------=> select created db ------> sql hahahaha> browse for the above db-backup.txt file on your station ... Execute.

Done.

I know that Asspimple is stoopid ... As he says, it is a FACT !

But I can't figure out how he can breathe or type , at the same time ....
Comment
spacedog

Yes that IS me. Bitch.

Join Date: Nov 2001

Posts: 14149
Share

Post
#18

06-18-2006, 12:58 PM

Originally posted by directfiesta

rsync ....

If your new host doesn't know this, well .....

Seems I am going to have 4 virtual accounts for grab:

P4 3.0 ghz
1 gig DDR ram
WHM/Cpanel
I dedicated IP
NS on other box

Storage: 30 gigs
BW: 500 gigs

Price : 45.00/month

Available from Monday ....

thanks for the offer, but that's gonna be a step down from what I got... I'm leaving my current host to get a better deal on a bigger package..

right now I got 150gigs storage & 1500 gigs bandwidth, on old host I only got 250 gigs bw & thats why I am moving...

The host I am moving from has a price match guarantee, but I seriosuly doubt they will honor it when they find out how much I am paying for 1500 gigs... I'd stay if they did match it, but the new host has plenty more advanced options that my current host does not, like shell access, included in package ssl, etc.. all kinds of addons that cost extra at my current host
Comment
directfiesta

Too lazy to set a custom title

Join Date: Oct 2002

Posts: 30184
Share

Post
#19

06-18-2006, 01:10 PM

Originally posted by spacedog

thanks for the offer, but that's gonna be a step down from what I got... I'm leaving my current host to get a better deal on a bigger package..

right now I got 150gigs storage & 1500 gigs bandwidth, on old host I only got 250 gigs bw & thats why I am moving...

The host I am moving from has a price match guarantee, but I seriosuly doubt they will honor it when they find out how much I am paying for 1500 gigs... I'd stay if they did match it, but the new host has plenty more advanced options that my current host does not, like shell access, included in package ssl, etc.. all kinds of addons that cost extra at my current host

NP, but the offer was not directed to you, but surfers looking here at the thread ...

I have dedicated ( same specs ) with 2000 gigs/month , Cpanel/WHM/ 160 gigs storage for 169.00 ... no set up...

But for your DB, try either solutions I posted ... It should work.

I know that Asspimple is stoopid ... As he says, it is a FACT !

But I can't figure out how he can breathe or type , at the same time ....
Comment

Previous template Next

Working...