Depends on what’ll happen with your domain transfer.
If your host is just moving your domain (and not actually moving your server), all you should have to do is change the URLs in your blog. If your whole account is being picked up and moved by your host … you should still be okay with changing the URLs.
If you’re moving from Server on OLD host to a server on a NEW host, now that’s different.
I’m assuming that you’re just changing the domain name, mind.
Hi,
I’m moving from Server on OLD host to a Server on a NEW host (IP changing).
My point is what has to be ticked in the DATA section of phpMyAdmin to Backup and Restore the exact Database with all its content?
Thanks.
Regards,
Matteo
Just the IP is changing? Then nothing, unless you’ve set up your config file to point to the IP of the database (it should be ‘localhost’). You’re fine. Your host should be taking care of all this for you and most of the time, these moves are seamless.
You may want to check with your host since, without knowing the details of what they’re doing, I’m stuck with guessing.
The IP will consequently change because I’m transferring my WP blog to another Server of a NEW HOSTING SERVICE PROVIDER.
Thanks.
Matteo
You want to backup the ENTIRE database 🙂
Do this:
On your current (existing) server (aka the OLD SERVER)
1) Backup your Database: http://codex.wordpress.org/Backing_Up_Your_Database
2) Download EVERYTHING from your public_html folder to a safe, offline, location.
Then go to the New server.
1) Restore your DB: http://codex.wordpress.org/Restoring_Your_Database_From_Backup
2) Upload everything you saved.
Have a drink.
Yes, I want to backup the ENTIRE database…
As I wrote in my first post the problem is:
2) Regarding the backup and restore of the Database (MySQL – 5.0.32 – Debian_7etch5, phpMyAdmin – 2.8.0.2), following http://codex.wordpress.org/WordPress_Backups in the DATA section I should tick the “Data”, “Complete inserts” and “Use hexadecimal for binary fields” checkboxes… but following http://codex.wordpress.org/Backing_Up_Your_Database in the DATA section I should tick only the “Data” checkbox leaving the other two mentioned above (“Complete inserts” and “Use hexadecimal for binary fields”) unticked… What’s the difference? What’s better?
Anybody helping me, please?
That’s why I linked to http://codex.wordpress.org/Backing_Up_Your_Database
🙂
You should tick the “Data”, “Complete inserts” and “Use hexadecimal for binary fields” checkboxes
Mind you, I don’t think it really matters in the end, I’ve done both and the results were always the same.
OK.
That’s the answer I was waiting for since the beginning!
Sorry for the post duplicated, it seemed to me nobody could understand my request probably because I didn’t express myself so well.
Thank you very much!
Matteo
