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

[spacedog]

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...

[Love Sex]

your new host will do it no problemo.

[spacedog]

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....

[Meorazhar]

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.

[minusonebit]

$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.

[Jace]

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

[gooddomains]

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

[spacedog]

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

[Heywood Jablome]

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'.

[spacedog]

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.

[Jace]

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

[testpie]

Do you have shell access to the old host?

[spacedog]

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

[spacedog]

Originally Posted by testpie

Do you have shell access to the old host?

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

[testpie]

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...

[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 ....

[directfiesta]

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.

[spacedog]

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

[directfiesta]

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.